Datasheet

12 Part 1: Getting to Know Excel 2010
It is important to note that at each stage of downward resizing, no command
groups or commands disappear entirely from the Ribbon. The multiple layout
options for the command groups ensure that nothing is lost as space becomes
more limited. If you reduce the size of the Excel window sufficiently, however,
the Ribbon disappears altogether.
Tipping off your keyboard
Excel provides KeyTips, which allow you to access every command on the
Ribbon using the keyboard, without having to memorize keystroke combinations!
So, what are KeyTips? KeyTips are little alphanumerical indicators containing a
single letter, a single number, a combination of two letters, or a combination of a
letter and a number, indicating what to type to activate the command under
them, as shown in Figure 1-5.
Figure 1-5
Follow these steps to access a command on a Ribbon tab using a KeyTip:
1. Press the Alt key. The KeyTips appear over the Ribbon tabs. (Ignore the
KeyTips that appear in the other areas of the user interface for this
exercise.)
2. Press the key that represents the KeyTip for the Ribbon tab that you want
to access. For example, press N to select the Insert tab. Note that you do
not have to hold down the Alt key. If you need to select a different tab
after you select the KeyTip for a tab, press the Esc key.
3. Press the key or key combination that represents the KeyTip for the
command you want to use.
If the command you select is a drop-down gallery or drop-down grid, you can
use an arrow key or the Tab key to highlight your choice and then press the
Enter key to select your choice.
Remember: KeyTips are associated with in-Ribbon galleries, so you have to press
the key that represents the KeyTip for the gallery before you can choose an
option in the gallery.
Hiding the Ribbon commands
If you find that the Ribbon commands take up too much room in the Excel
window, you can hide them using any of the following methods:
03_527559-ch01.indd 1203_527559-ch01.indd 12 4/1/10 6:59 PM4/1/10 6:59 PM