If you are a fan of using the keyboard, you might have noticed one problem in Excel 2003. There were often menu items that did not have a keyboard shortcut.
In Excel 2007, every menu item can be selected from the keyboard. To access the new keyboard shortcuts, press and release the Alt key on the keyboard. Excel displays a single-character keyboard shortcut for each tab of the ribbon. If any contextual ribbon tabs are visible, they will have a two-character shortcut key.
All of the icons on the QAT are assigned a numeric keyboard shortcut. The fi rst nine items are assigned the keys 1 through 9. Icons after that are assigned a two-character shortcut starting with a zero.
Office 2007 Shortcuts Tips
When you press F, H, N, P, M, A, R, or W, Excel displays the appropriate tab of the ribbon. The original shortcut key tips are replaced with new keytips that allow you to select any of the items in the ribbon.
Referring to Data ribbon, some of the key tips make sense: A for Sort Ascending; D for Sort Descending; W for What If; V for Validation. Other shortcuts just seem to use the left over letters. If you type W to select What If Analysis, its dropdown provides you with three new shortcut keys from which to select items.
While the keyboard shortcuts for the QAT will constantly change, depending on how your QAT is customized, you should find that the keyboard shortcuts for the ribbon will remain constant. You can memorize that Alt+A+A will sort in ascending order. Alt+A+W+G will open the Goal Seek dialog.