Datasheet

Introducing the Ribbon — Introducing the Quick Access Toolbar (QAT) 13
✓ Click the Ribbon’s Minimize button in the Excel title bar (to the left of the
help button)
✓ Press Ctrl+F1
✓ Double-click any Ribbon tab
✓ Right-click in the Ribbon area and choose Minimize the Ribbon from the
contextual menu
After you hide the commands, only the Ribbon tabs are displayed. If you click a
tab after you hide the Ribbon commands, Excel displays the tab commands
temporarily. The commands are hidden again after you select a command in the
tab or click away from the Ribbon area. Similarly, you can use KeyTips to select
a command when the command display is hidden.
To redisplay the commands permanently after you hide them, use the same
methods described for hiding the commands.
Remember: Excel maintains the hidden condition of the Ribbon commands if you
exit and subsequently relaunch Excel.
Introducing the Quick Access Toolbar (QAT)
The Quick Access toolbar (or QAT) is an area of the user interface that provides
quick access to commands. The QAT is designed to reduce the amount of
navigation you have to do in the Ribbon to access the features that you use
frequently. The QAT is located at the top left of the Excel title bar, above the
Ribbon tabs (see Figure 1-6).
Figure 1-6
The QAT contains three default commands (Save, Undo, and Redo); you can add
additional commands.
Follow these steps to add a command to the QAT:
1. Select the Ribbon tab that houses the command you want to add.
2. Right-click the command and choose Add to Quick Access Toolbar in the
menu that appears.
To quickly add some commonly used commands to the QAT, click the arrow to
the right of the toolbar and choose a command from the menu.
03_527559-ch01.indd 1303_527559-ch01.indd 13 4/1/10 6:59 PM4/1/10 6:59 PM