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+Shift+Alt+F9, be sure to look them up.
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
Alert: Watch for my special gift on the download page.