Excel 2007 Keyboard Shortcuts for the Ribbon

While trying to type a hyphen in Excel 2007, I stumbled onto a handy keyboard shortcut.

I had a bit of an overreach on the hyphen, and hit the F10 key instead. To my amazement, the Ribbon filled with little tags.

RibbonTags

Maybe I’ve been living under a rock, but I don’t remember seeing those before.

There’s a number or letter on each Ribbon tab, and each icon on the Quick Access Toolbar (QAT).

Use the Shortcut keys

Pressing the F10 key activates the Ribbon. Then, type the letter(s) or number(s) that you see on any tab or QAT command.

For example, I can type an A to activate the Data tab. (Note: Even if the Data tab is active, you’ll have to type an A to see its command tags.)

Tags will appear on the available Data commands.

RibbonTagsData

Because there’s a table on my worksheet, most of the commands are available, so I can type T to add an AutoFilter or type Q to start an Advanced Filter.

It seems like a useful feature, and the only shortcut that I have to memorize is the F10 key. Anyway, it’s nice to know that a typo can lead to an interesting discovery.

_____________________

You may also like...

4 Responses

  1. Tim Mayes says:

    Deb, this is especially useful if you keep the Ribbon minimized. I do that during presentations to maximize screen space.

    This same technique can be used by pressing the Alt key (as with old shortcuts like Alt-F to launch the File menu, but now opens the Office Button). I didn’t know that F10 did the same thing. Good catch.

  2. Not a keyboard person, huh? It’s OK, I won’t hold it against you. :)

    The Alt key does the same thing. And of course the slash key also, to appease all those 1-2-3 users who are still converting.

  3. Thanks Tim, I hadn’t tried it with the Ribbon minimized. Nice that it shows the commands temporarily, then minimizes again, after you select a command.

    Dick, I appreciate your tolerance. I have a few favourite keyboard shortcuts, but use the mouse most of the time.
    At least I’m not still converting from 1-2-3!

  4. aileen says:

    thank you it helps me a lot

Leave a Reply to Dick Kusleika Cancel reply

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