One key to rule them all…

altkeygeneral1

If you’re like me, you spend 90% of your day with your head buried in Excel spreadsheets. The faster you can navigate around the program, the quicker you can finish the project at hand, and the quicker you can get to work on your infinite backlog of tasks. If you have already mastered the standard program shortcuts, it’s time to throw away your mouse for good and turn your all-seeing eye towards the all-powerful Alt key.

Press it. Go ahead, press it. Now look at the Excel ribbon. See all those letters? Press one. Get the idea?

The Alt key allows you to control all aspects of the Excel interface, including actions that have no pre-defined keyboard shortcut. Just press ‘Alt’, then press the letter that corresponds to the correct ribbon section, and then another letter to access any actions within that subsection. You now have an unlimited number of keyboard shortcuts at your disposal. Keep in mind that if you have ASAP Utilities or any other Excel add-ins installed, the Alt functionality works with those as well.

Here are a few of my favorites:

-ALT + N + V

-Instantly create a pivot table from the selected range or table. Boom.

-ALT + H + O + I

-Expand all columns from your selected cells.

-ALT + A + M

-Remove all duplicates in your selection.

Try these out, and explore the menu combinations on your own to create any number of powerful shortcuts.

2 Comments

  1. Oliver January 20th, 2015

    Alt -> H -> V -> V
    Paste Values

  2. Garrett January 20th, 2015

    Thanks Oliver, that’s a great one!

Leave a Comment

Garrett Bugbee
Garrett was an account associate at 3Q Digital. Garrett graduated from Cornell University with a bachelor's degree in Biology. He currently lives in the beautiful state of Vermont.