I have already created, and update from time to time, one of the most comprehensive lists of keyboard shortcuts available online. Regardless of your level of Excel knowledge, you can always learn a new shortcut and, considering the huge amount of Excel keyboard shortcuts that you have available, is likely that you'll never memorize them all.In the most recent versions of Excel, keyboard shortcuts allow you to work with virtually every command or feature by using the keyboard.Not knowing the right keyboard shortcut means that, instead of quickly typing the relevant key combination, you need to (i) lift your hand from the keyboard, (ii) reach for the mouse in order to do what you want, and (iii) return to the keyboard. Keyboard shortcuts are extremely useful for purposes of improving your speed and productivity when working with Excel.

The following are some of the reasons that explain this:

Here is the list in a format you can print or clip.Keyboard shortcuts are, perhaps, one of the Excel topics that virtually any user can (or should) be interested in. Which are your favourite time-saving Excel shortcuts? Which ones should be on this list? It is worth spending a little time to learn the shortcuts on this page, they are the ones people ask me about the most, and to continue discovering more of your own. Shortcuts are a great way to minimise the amount of clicking and selecting that you would have to do when working with large spreadsheets. There are many ways to accomplish the same tasks in an Excel spreadsheet. You can usually locate the key just above the key – it’s not the same as that you use all the time. + to show formulas and again to hide formulas. This command is found in the Formula Auditing Group of the Formulas tab in Excel. Speaking of SUM and formulas in general, few people know that they can do this at all but it’s essential when you need to troubleshoot or audit an existing spreadsheet, when you want a bird’s eye view of how it’s built and check that formulas are consistent.

List all excel shortcut keys