Excel Shortcut Keys

20 Excel Shortcut Keys to Speed Up Your Workflow

In Basic by theexcelpert0 Comments

Share with:


Clicking. Dragging. Right-Clicking. Searching through Ribbons and Tabs. All of this takes time. Using Excel is about being effective and efficient. The faster you know how to move, the more you can get accomplished, which means you’re spending less of your life staring into a computer screen (yay!).

I’m going to skip over the rudimentary Control + C / Control + V and assume you already know the super basic copy and paste functions.

So let’s talk about some of the (other) top shortcut keys to take you from slow-poke to super-freak.

  1. Select Entire Row | Shift + Spacebar
  2. Select Entire Column | Control + Spacebar
  3. Select Entire Range | Control + Shift + Spacebar
  4. Select to End of Range (Horizontally) | Control + Shift + Right (or Left) Arrow
  5. Select to End of Range (Vertically) | Control + Shift + Down (or Up) Arrow
  6. Fill a Range | Select your range, beginning with the cell whose formula you’d like to fill, then enter that cell (F2), then press Control + Enter
  7. Change format to a Number (with 2 Decimals) | Control + Shift + 1
  8. Change format to Currency | Control + Shift + 4
  9. Change format to Percent | Control + Shift + 5
  10. Create a Border Around the Selected Range | Control + Shift + 7
  11. Insert Current Date | Control + ;
  12. Insert Current Time | Control + Shift + ;
  13. Create Chart from Data | Select the range, then press F11
  14. Enter Cell | Select the cell you want to enter, then press F2
  15. Lock Reference | Click on the reference in your formula to lock, then press F4
  16. Evaluate (highlighted part of) a Formula | F9
  17. Open a New Workbook | Control + N
  18. ‘Save As’ Current Workbook | F12
  19. Open a Workbook | Control + O
  20. Enter VBA | Alt + F11

And there you have it. 20 quick and easy shortcut keys that will speed up your workflow in no time. As you progress from newbie to I-might-as-well-work-for-Microsoft you’ll find that there are so many more.

If this starter list isn’t enough for you, check out Microsoft’s more extensive list, as well. If you’re new to Excel, their list may be a little overwhelming; don’t worry, mine should get you started with the basics.

Good luck!

Share with: