Datasheet

17
Chapter 1: Getting Familiar with the Excel 2010 Interface
Customizing the Quick Access toolbar
In addition to the three default command buttons, the Quick Access toolbar contains a
Customize Quick Access Toolbar button (the one with the line above a downward
pointing triangle) that, when clicked, opens a pull-down menu. The options on this
pull-down menu enable you to quickly customize the command buttons on this toolbar.
In addition, you can change the placement of the toolbar by moving it down so that it
appears immediately below the Ribbon and above the Formula bar.
Exercise 1-5: Quickly Customizing the Quick Access Toolbar
In Exercise 1-5, you get practice customizing the contents and position of the Quick
Access toolbar using options that appear on the Customize Quick Access Toolbar
menu. Make sure that Excel 2010 is running and an empty Sheet1 worksheet is active on
your computer monitor (see Chapter 2 for information on launching Excel).
1. Click the Customize Quick Access Toolbar button and then click the Show Below
the Ribbon option on its menu.
The Quick Access toolbar with its three command buttons and the Customize
Quick Access Toolbar button now appears immediately above the Formula bar.
2. Click the Customize Quick Access Toolbar button and then click the Quick Print
option.
Excel adds the Quick Print button to the Quick Access toolbar that you can click to
send the current worksheet to the printer.
3. Use the same technique to add the New, Open, and Print Preview and Print
command buttons to the Quick Access toolbar on your own.
Use the ScreenTips attached to each button to verify that you’ve correctly added
the Quick Print, New, Open, and Print Preview and Print buttons to the Quick
Access toolbar, noting the shortcut keys listed.
Adding more commands to
the Quick Access toolbar
When customizing the command buttons on the Quick Access toolbar, you aren’t
limited to the selection of commands that appear on the Customize Quick Access
Toolbar pull-down menu. Using command options that appear in the Excel Options
dialog box, you can add buttons for any of the commands that appear on the various
tabs of the Ribbon as well as some Excel commands that remain completely unavailable
until you add them to the Quick Access toolbar.
Exercise 1-6: Adding Commands from the Excel Options Dialog Box
to the Quick Access Toolbar
In Exercise 1-6, you get practice customizing the contents of the Quick Access toolbar
using commands that appear in the Excel Options dialog box. Make sure that Excel 2010
is running and an empty Sheet1 worksheet is active on your computer monitor (see
Chapter 2 for information on launching Excel).
05_489604-ch01.indd 1705_489604-ch01.indd 17 7/29/10 11:25 PM7/29/10 11:25 PM