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