Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Lazy Cheating Bum’s Guide To Excel Shortcuts

January 19, 2016 by terp 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…]

Filed Under: Alt Shortcuts, Cut Copy Paste, Delete, Excel Shortcuts, Menu Key, Paste Values Tagged With: Alt Shortcuts, Excel Shortcuts, Format Painter, Paste Values

Excel Menu Key

November 1, 2015 by terp 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.

Filed Under: Excel Keyboards, Format Cells, Menu Key, Paste Special, Right Click Tagged With: Excel Keyboard Shortcuts, Excel Keyboards, Excel Shortcuts, Menu Key, Paste Special

Excel Keyboard Review

September 15, 2015 by terp Leave a Comment

I recently got rid of my standard keyboard in favor of something that would make me faster.  Research and testing consumed me for nearly a week so I figured I’d do an Excel Keyboard Review based on my findings.

When using Excel, I generally like having my right hand on the mouse, and rarely use the number pad on the right side of the keyboard.  So it makes sense for me, on the right hand side of the keyboard, to do away with the number pad and lay out the remaining useful keys (the navigation cluster) more efficiently than the standard layout which has lots of extra space.  This would allow me to have a smaller keyboard and position my mouse in the liberated desktop space.  Doing this puts my right hand (while on the mouse) closer to the keyboard, which enables faster switching between mouse and keyboard when necessary.  If you use your hands differently you may have a different perspective on the keyboards I review below.

The Excel Keyboard I Dumped

Below is the keyboard I had — the Microsoft Wireless Comfort Keyboard 5000.  The curved layout and the wrist pad are ergonomic pluses, and did have the very useful Menu key which effectively allows you to right click on the mouse by typing a key (which is useful when your right hand is on the keyboard to, e.g., use the navigation keys).  But the right side layout was a big negative.  As noted above, I can do without the number pad.  And while the navigation keys are useful, they could be arrayed more efficiently.  Finally, the numerous keys on the top row were useless to me (though they didn’t create any usability issues).  Basically, the keyboard felt bulky and forced me to position it semi-diagonally (rising from the left to the right) so I could make some room for my mouse.  So I decided to dump it.

Micorosoft-quiet-comfort-keyboard-5000
Microsoft Quiet Comfort Keyboard 5000 – Excel

[Read more…]

Filed Under: Excel Keyboards, Keyboard Shortcuts Tagged With: Excel Keyboards, Excel Shortcuts

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel