Join Curt Frye for an in-depth discussion in this video Controlling Excel 2007 using keyboard shortcuts, part of Migrating from Excel 2003 to Excel 2007.
The Office User Experience team changed the Excel 2007 user interface to make the program's features easier to discover for beginning and intermediate users. They did realize though that many frequent Excel users rely on its keyboard shortcuts to control the program. The Microsoft Excel Programming team ensured that every keyboard shortcut available in Excel 2003 was available in 2007. All of the familiar user shortcuts, such as Ctrl+C to Copy, Ctrl+V to Paste, Ctrl+S to Save, and Ctrl+P to Print, still work, but you can also access the Ribbons commands by pressing keyboard sequences.
To access the Ribbon using the keyboard, press and release the Alt key. When you do, Excel overlays a series of numbers and letters on the Ribbon, indicating which keys you need to press to display a Ribbon tab or activate a button on the Quick Access Toolbar. Let's say that I press the N as in Nancy key to display the Insert tab. When the Insert tab appears, Excel displays the key sequences I need to press to activate these further options. Notice that the Chart Groups Dialog Expander has its own keystroke, K, assigned to it. Let's assume in this case that I want to insert a shape, so I will press S-H and that is in sequence.
You don't have to press the two keys at the same time. When I press S-H, the Shapes Gallery expands, and the first shape in the gallery is highlighted. I can now use the Arrow keys, Down and Up, Left and Right, to select the shape that I want to insert, and let's say that I just want to go for a basic rectangle. Once that shape is highlighted, I can press Enter and my mouse pointer changes to a black crosshair. Now that I have the crosshair, I can draw the shape and when I release the mouse button, the shape appears in my worksheet. Now let's say that you're controlling the Ribbon using the keyboard and you pressed the wrong key by accident, such as going to the wrong tab on the Ribbon.
To illustrate the point, I will press Alt and then press H to go to the Home tab. If I'd want it to display the Insert tab, I should've pressed N. To back up a step, I can press the Escape key, which takes a back to the previous level, and then I can press N to go back to the Insert tab. The Ribbon takes up very little room on most modern monitors, but you might want to minimize the Ribbon if you're using Excel on a small monitor in a reduced size program window, or if you are just tired of looking at it. To minimize the Ribbon, you press the key sequence Ctrl+F1 and that is a simultaneous press.
You hold down Ctrl and press F1. If you'd like to bring the Ribbon back, you can press Ctrl+F1 again. Keyboard shortcuts enable you to manipulate Excel quickly and efficiently. If you'd like to learn more about the keyboard shortcuts available in Excel 2007, open the Excel's Help System and search for the phrase Keyboard Shortcuts, the topic Excel Shortcut and Function Keys is the one you want.
- Changing the default file format in Excel 2007 Using the Compatibility Pack to open 2007 files in earlier versions of Excel Customizing the Excel 2007 interface Working with Excel files in a mixed-version environment Creating macro-enabled workbooks and templates