Faster At Excel

Lazy Cheating Bum’s Guide To Excel Shortcuts

by Leave a Comment

How Can I Become A Lazy, Cheating Bum With Excel Shortcuts?

Excel shortcuts are for “lazy” people (actually, for smart and efficient people).  But I’d like to take laziness to another level — and show you how to be lazy about being lazy.

excel-shortcuts-cheating

Excel provides some easy ways to discover shortcuts, or remind yourself of them if you’ve forgotten.  These methods work with some types of shortcuts, and only in some situations.  However, they can be very useful, especially while you’re learning shortcuts.  Or, if you’re too lazy to remember shortcuts, this is your easy way out.
[Read more…]

Excel Menu Key

by Leave a Comment

What is the Menu Key and why is it important in Excel?

This is a short but hopefully useful post.

Right-clicking, as you probably already know, brings up an Excel “context menu” that gives you quick access to lots of common commands.  The menu differs, not surprisingly, based on the context.  Hitting the Menu Key (or “Context Menu Key” or “Application Key”) brings up the identical menu.  The Menu Key is typically located on the bottom right side of the keyboard, somewhere between the Alt and Ctrl keys.  Below is a picture (your keyboard may be different and smaller keyboards may not even include it – but if yours doesn’t you should consider getting one that does — see my Excel Keyboard Review):

menu-key-keyboard-excel

If you look at a close-up you’ll see that it resembles a mouse pointing at a drop-down menu – as if you had just right clicked.

menu-key-closeup-excel

Thus, you can use the Menu Key to do things in Excel like Paste Special, Insert, Delete, open the Format Cells dialog box and other things you might normally do with the mouse.

If your ultimate goal is to become a keyboard only user in Excel, then the Menu Key is very helpful.  It can turn hybrid shortcuts (that combine the mouse and the keyboard) into plain old keyboard shortcuts.   And it can provide shortcuts that are faster than Alt shortcuts or other keyboard shortcuts.

In general, I advocate using the Menu Key (vs. the mouse) when your right hand is already on (or going to) the keyboard.  Otherwise, I find right clicking to be a faster way to pull up the context menu.