Professor Excel

One way of speeding up Excel is to integrate keyboard shortcuts in your workflow. Excel experts hardly use a mouse at all, because using a mouse takes more time and is often not precise.

But in total, there are more than 500 keyboard shortcuts in Excel. Which ones are important? Which shortcuts should you memorize?

Before we start: Do you want to download the complete package of keyboard shortcuts in Excel? Just sign up for our newsletter and you’ll get the download link.

 

Different Types of Excel Keyboard Shortcuts

There are two main types of keyboard shortcuts:

  1. Accessing the ribbon (“Alt” shortcuts)
  2. Direct shortcuts

 

Accessing the Ribbon Shortcuts

The first type of keyboard shortcuts accesses the ribbon. You can try it by pressing the Alt-key. After pressing Alt key, letters will be shown on the ribbon. Press one of these letters and the corresponding ribbon will open. New letters show how to access each specific function.

This type is easy to use as you are guided through it. You don’t even have to remember the complete shortcut, but just on which ribbon your desired function is located.

 

Direct Shortcuts

The second type comprises all other shortcuts. Some of them require the Ctrl key or others function keys (F1, F2, e.g.). One of the advantages is that they are usually shorter than ribbon shortcuts. Furthermore, many of the direct shortcuts are the same in other Windows programs (Word, PowerPoint, Windows Explorer e.g.) or similar on other platforms (Mac). The disadvantage is that you have to remember them. Some may be easy to be memorized, while some are quite difficult.

When direct shortcuts are available, they are usually shown when the mouse is moved to a function on the ribbon. The corresponding description text will appear.

 


Hold on a second. Was this information helpful so far?

Keyboard Shortcuts for Excel on Windows and Mac

If yes: Why don't you subscribe to our monthly, free Excel newsletter? You get all this:

newsletter The best Excel tips, tricks and tutorials.
newsletter 1x per month.
newsletter No spam. Promised.

Keyboard Shortcuts for Excel on Windows and Mac

Your welcome gift: Our big 45 pages keyboard shortcuts package.

Keyboard Shortcuts for Excel on Windows and Mac

Subscribe now!

Learn more


 

Which Shortcuts should I remember?

This highly depends on what you do with Excel. If you use Excel only for keeping a To-Do-List, the keyboard shortcuts that you require, could be very different from those you need for financial controlling purpose for your company.

But anyway, the following list provides shortcuts for different tasks on a Windows computer and Mac. You can download them as a pdf document, print it out and stick at your computer screen. This serves as a daily help and eventually you could memorize the shortcuts.

 

Excel Keyboard Shortcuts Windows:

keyboard, shortcuts, excel, microsoft, xls, xlsx, windows

Professor Excel’s Keyboard Shortcuts for Excel 2010 and 2013 (Windows)

 

Excel Keyboard Shortcuts Mac:

keyboard, shortcuts, excel, microsoft, xls, xlsx, mac

Professor Excel’s Keyboard Shortcuts for Excel 2011 (Mac)