Every advanced Excel user in history will tell you the same sad story. First, you discover basic keyboard shortcuts (like F2), then you learn about Pivot Tables and VLookup and feel pretty accomplished. But then you go on to learn about Array / Matrix formulas, and eventually you put the entire list of Excel keyboard shortcuts under your pillow at night because you just can’t live without them.

But sooner or later, you’ll be annoyed by certain mouse clicks that you just can’t get rid of, no matter how many shortcuts you learn.

KeyRocket to the rescue!  Voilá, here’s the list of easy keyboard shortcuts which are automatically at your fingertips with KeyRocket but aren’t available in Microsoft Excel on its own:

Function Shortcut
Clear Filter Alt+Shift+L
Sort Ascending Alt+Shift+Arrow-Down
Sort Descending Alt+Shift+Arrow-Up
Insert Sheet Shift+F11
Delete Sheet Ctrl+Shift+F11
Rename Sheet Ctrl+Shift+F2
Trace Precedents Ctrl+Alt+[
Trace Dependents Ctrl+Alt+]
Clear Arrows Ctrl+Alt+\
Hide Detail Ctrl+Alt+Arrow-Left
Show Detail Ctrl+Alt+Arrow-Right
Gridlines Toggle Ctrl+Alt+G
Increase Font Size Ctrl+Shift+F
Decrease Font Size Ctrl+Shift+G
Increase Decimal Ctrl+,
Decrease Decimal Ctrl+.
Border – Top Ctrl+Alt+Shift+Arrow-Up
Border – Bottom Ctrl+Alt+Shift+Arrow-Down
Border – Left Ctrl+Alt+Shift+Arrow-Left
Border – Right Ctrl+Alt+Shift+Arrow-Right
Border – Outline Ctrl+Shift+7
Border – None Ctrl+Shift+-
Wrap Text Ctrl+Shift+W
Increase Indent Alt+Arrow-Right
Decrease Indent Alt+Arrow-Left

Please send all feedback to jans@keyrocket.com

Background: After developing ‘KeyRocket Custom Shortcuts’, we realized that most users need the same ‘most frequent’ custom shortcuts. So, instead of having everybody assign their own shortcut, we decided we’d take the established industry standards and implement them as defaults.

If you haven’t already done so, be sure to get your Free Download of KeyRocket to master keyboard shortcuts and take advantage of these additional shortcuts that Microsoft forgot.


Related Articles:


5 Responses to “The Missing Keyboard Shortcuts for Microsoft Excel”

  1. Phil

    Clear Filters doesn’t just switch off the filter, it removes it entirely. Also I have yet to find a simple way to switch off (but not remove) all filters from all sheets in a workbook which must be done before a “Find All” operation can be executed.

  2. bệnh gout có bị lây không

    Greate pieces. Keep posting such kind of info on your page.

    Im really impressed by it.
    Hi there, You have performed an incredible job. I
    will definitely digg it and for my part recommend to my friends.
    I am confident they will be benefited from this web site.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.