Microsoft Office Tutorials and References
In Depth Information
Customizing the Quick Access Toolbar
Figure 11-2: Use the Quick Access Toolbar tab in the Excel Options dialog box to customize the Quick
Sometimes, you need to do some guessing to find a particular command. For example, if you’d
like to add the command that displays the Excel Options dialog box, you’ll find it listed as
Options, not Excel Options.
Some commands simply aren’t available. For example, I’d like the Quick Access toolbar to display
the command to toggle the “dashed line” page break display on a worksheet. The only way to
issue that command is to display the Advanced tab of the Excel Options dialog box and then
scroll down until you find the Show Page Breaks check box. There is no command that can be
added to the Quick Access toolbar. To add an item to your Quick Access toolbar, select it from
the list on the left and click Add. If you add a macro to your Quick Access toolbar, you can click
the Modify button to change the text and choose a different icon for the macro.
Notice the drop-down control above the list on the right. This lets you create a Quick Access
toolbar that’s specific to a particular workbook. This is most useful when you add macro
commands to the Quick Access toolbar. Most of the time, you’ll use the setting labeled For All
The only time you ever need to use the Quick Access Toolbar tab of the Excel Options dialog box
is when you want to add a command that’s not on the Ribbon or add a command that executes a
macro. In all other situations, it’s much easier to locate the command on the Ribbon, right-click
the command, and choose Add To Quick Access Toolbar.
Only you can decide which commands to put on your Quick Access toolbar. In general, if you find
that you use a particular command frequently, it should probably be on your Quick Access
toolbar. For example, when I work on a chart, I like to use the Chart Elements control to make it easy