Datasheet

Tipping off your keyboard
Excel provides a feature called KeyTips that allow you to access every command
on the Ribbon using the keyboard, without having to memorize keystroke com-
binations! So, what are KeyTips? KeyTips are little alphanumerical indicators
containing a single letter, a combination of two letters, or a number, indicating
what to type to activate the command under them, as shown in Figure 1-5.
Follow these steps to access a command in 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 interface for this exercise.)
2. Press the key that represents the KeyTip for the Ribbon tab 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 com-
mand 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.
Remember: If the command you want to use requires a number key, you must use
the number keys on the main keyboard. The KeyTip feature does not work with
the numeric keypad.
Hiding the Ribbon commands
If you find that the Ribbon commands take up too much of your screen area, you
can hide them using any of the following methods:
 Press Ctrl+F1
 Double-click any Ribbon tab
Figure 1-5
12 Part 1: Getting to Know Excel 2007
03_046716 ch01.qxp 11/16/06 6:40 PM Page 12