Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands.

To display the Quick Access toolbar beneath the Ribbon, click the Customize Quick Access Toolbar button (on the right end of the toolbar) and choose Show Below the Ribbon on the drop-down menu.

Add buttons to the Quick Access toolbar

You can click the Customize Quick Access Toolbar button to easily add other common Excel 2007 commands to this toolbar. The resulting drop-down menu contains the following commands: New, Open, E-mail, Quick Print, Print Preview, Spelling, Sort Ascending, and Sort Descending.

Use this menu to add common commands to the Quick Access toolbar.
Use this menu to add common commands to the Quick Access toolbar.

To add any of these commands to the toolbar, simply click the option on the drop-down menu. Excel adds a button for that command to the end of the Quick Access toolbar (and a check mark to its option on the drop-down menu).

To add any Ribbon command to the Quick Access toolbar, right-click the command button on the Ribbon and then choose Add to Quick Access Toolbar on the shortcut menu.

Add non-Ribbon commands to the Quick Access toolbar

To add a non-Ribbon command to the Quick Access toolbar, follow these steps:

  1. Click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of the drop-down menu.

    Excel displays the Excel Options dialog box with the Customize tab selected. On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.

    Use the Customize settings to add any Excel 2007 command to the Quick Access toolbar.
    Use the Customize settings to add any Excel 2007 command to the Quick Access toolbar.
  2. Select the type of command you want to add from the Choose Commands From drop-down list.

    For example, if you want to display only the commands that do not appear on the Ribbon, select Commands Not in the Ribbon.

  3. Click the command you want to add to the Quick Access toolbar in the list on the left.

  4. Click the Add button.

    The command button appears at the bottom of the list on the right.

  5. Use the Move Up and Move Down buttons to reposition the newly added command button.

  6. Click OK.

    The Excel Options dialog box closes, and the button appears in the Quick Access toolbar.

To quickly remove a button from the Quick Access toolbar, right-click it and then select Remove from Quick Access Toolbar on the shortcut menu. You can reset the Quick Access toolbar to its original configuration by clicking the Reset button on the Customize tab of the Excel Options dialog box.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: