Datasheet

8
Chapter 1: Working with Excel Files
4. Click anywhere in the Excel workbook to close the
Customize Status Bar menu.
Figure 1-5
Figure 1-6
Select Commands with the Keyboard
1. Click any cell on the worksheet.
2. Press the Alt key on the keyboard. Shortcut letters appear on
the Ribbon, and numbers appear on the Quick Access toolbar
(see Figure 1-5).
Numbers control commands on the Quick Access toolbar.
3.
Press a letter on your keyboard to select a tab on the Ribbon;
for example, press the P key to display the Page Layout tab.
Shortcut letters then appear for each command on that tab.
4. Press a letter on your keyboard to select a command. Excel
displays options for the command you selected.
5. Press a letter or use the arrow keys and then press Enter on
the keyboard to select an option. Excel performs the com-
mand you selected, applying the option you chose.
Press the Esc key to step the KeyTips back one step.
Change Status Bar Indicators
1. Right-click anywhere along the status bar at the bottom of
the window. Excel opens the Customize Status Bar menu.
2. Active features have a check mark next to them and inactive
features do not. To activate an inactive feature, click it. This
automatically adds a check mark. In Figure 1-6, the Caps
Lock feature is off.
3. To deactivate any active feature, click it to remove the check
mark.
05_501641-ch01.indd 805_501641-ch01.indd 8 4/23/10 8:59 PM4/23/10 8:59 PM