Datasheet

Adapting the Quick Access toolbar

When you first start using Excel 2007, the Quick Access toolbar contains only

the following few buttons:

 Save to save any changes made to the current workbook using the same

filename, file format, and location

 Undo to undo the last editing, formatting, or layout change you made

 Redo to reapply the previous editing, formatting, or layout change that

you just removed with the Undo button

The Quick Access toolbar is very customizable as Excel makes it really easy

to add any Ribbon command to it. Moreover, you’re not restricted to adding

buttons for just the commands on the Ribbon: you can add any Excel com-

mand you want to the toolbar, even the obscure ones that don’t rate an

appearance on any of its tabs.

By default, the Quick Access toolbar appears above the Ribbon tabs immedi-

ately to the right of the Office Button. To display the toolbar beneath the

Ribbon immediately above the Formula bar, click the Customize Quick

Access Toolbar button (the drop-down button to the right of the toolbar

with a horizontal bar above a down-pointing triangle) and then click Show

Below the Ribbon on its drop-down menu. You will definitely want to make

this change if you start adding more buttons to the toolbar so that the grow-

ing Quick Access toolbar doesn’t start crowding out the name of the current

workbook that appears to the toolbar’s right.

Adding command buttons on the Customize

Quick Access Toolbar’s drop-down menu

When you click the Customize Quick Access Toolbar button, a drop-down

menu appears containing the following commands:

 New to open a new workbook

 Open to display the Open dialog box for opening an existing workbook

 Save to save changes to your current workbook

 E-mail to open your mail

 Quick Print to send the current worksheet to your default printer

 Print Preview to open the current worksheet in the Print Preview window

 Spelling to check the current worksheet for spelling errors

 Undo to undo your latest worksheet edit

Part I: Getting In on the Ground Floor

05_037377 ch01.qxp 11/16/06 9:23 AM Page 18