Home >

Download Charley's Complete
Excel Shortcuts Workbook

by Charley Kyd

My Excel shortcuts workbook contains two worksheets with lists of shortcuts:

• The Dialogs sheet shows all the shortcuts I've found that launch dialog boxes.
   
• The All Shortcuts sheet maps out more than 250 Excel shortcut key combinations for all versions of Excel since Excel 97.

Honestly, I can't remember most of those 250+ shortcuts. So here are a few ways I use this workbook...

• I browse it once in a while to see if there's a shortcut that I should be using. That's how discovered the Ctrl+1 key combination several years ago, which I now use many times a day.
   
• When I'm doing a repetitive task, I often use Excel's Edit, Search command to search the workbook for terms related to what I'm doing. If I'm lucky, there's a shortcut that makes my work easier. For example, I rediscovered Ctrl+* this way.
   
• In rare cases, the shortcut keys perform tasks that we otherwise only can do with macros. To see what I mean, check out the four Calculate options shown for the F9 key, and when you're working with PivotTables, check out Ctrl+Alt+F5.
   
• When another Excel user mentions a favorite shortcut that I don't use, I look it up in this workbook for a quick explanation. For example, if you don't know Ctrl+1, Ctrl+*, Ctrl+Alt+F5, and Ctrl+Shift+Alt+F9, be sure to look them up.

Special Request...

After you start to use this workbook please email me with any additions or corrections that you discover. I want this workbook to continue to be the most complete and accurate source for Excel shortcut keys. Whenever I update the workbook, I'll alert you to the update in my newsletter.

Just enter your email address to get your workbook.