Posted by .

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:

The Missing Shortcuts for Microsoft PowerPoint

Press Release (PDF) – ‘The Shortcuts Microsoft Forgot’ – Add your own keyboard shortcuts to Excel, PowerPoint, and Visual Studio with KeyRocket

Shortcut Conflicts – What can I do when a shortcut is already in use?

How do I remove or delete a KeyRocket Custom Shortcut?

 

 

3 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.

    Reply
    • Nash Horne

      Best I’ve come up with is putting the “Clear all” button on the quick access bar above (or below) the ribbon, or creating a macro.

      Reply
    • Joey Potts

      If you presss “Alt + D then F then S” then that will clear any filter you have

      Reply

Leave a Reply

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