Saturday, May 9, 2015

Customizing the Quick Access Toolbar

Customizing the Quick Access Toolbar

About the Quick Access toolbar
By default, the Quick Access toolbar is located on the left side of the Excel title bar, and it includes
three tools:

Save: Saves the active workbook.
       ➤ Undo: Reverses the effect of the last action.
       ➤ Redo: Reverses the effect of the last undo

Commands on the Quick Access toolbar always appear as small icons, with no text. When you hover your mouse pointer over an icon, you see the name of the command and a brief description.
As far as I can tell, the number of icons that you can add to your Quick Access toolbar is limitless. But
regardless of the number of icons, the Quick Access toolbar always displays a single line of icons. If
the number of icons exceeds the Excel window width, it displays an additional icon at the end: More
Controls. Click the More Controls icon, and the hidden Quick Access toolbar icons appear in a pop-up
window.

Adding new commands to the Quick Access toolbar
You can add a new command to the Quick Access toolbar in three ways:

Click the Quick Access toolbar drop-down control, which displays a down-pointing arrow
and is located on the right side of the Quick Access toolbar (see Figure 2-1). The list contains several commonly used commands. Select a command from the list, and Excel adds it to your Quick Access toolbar.
Right-click any control on the Ribbon and choose Add to Quick Access Toolbar. The control is
    
added to your Quick Access toolbar, positioned after the last control.
Use the Quick Access Toolbar tab of the Excel Options dialog box. A quick way to access this
    
dialog box is to right-click any Quick Access toolbar or Ribbon control and choose Customize
     Quick Access Toolbar. 

Figure 2-1: The Quick Access toolbar drop-down menu is one way to add a new command to the Quick Access
toolbar


Figure 2-2 shows the Quick Access Toolbar tab of the Excel Options dialog box. The left side of the dialog box displays a list of Excel commands, and the right side shows the commands that are now on the Quick Access toolbar. Above the command list on the left is a drop-down control that lets you filter the list. Select an item from the drop-down list, and the list displays only the commands for that item.

Figure 2-2: Use the Quick Access Toolbar tab in the Excel Options dialog box to customize the Quick Access
toolbar.


Some of the items in the drop-down list are described here:

Popular Commands: Displays commands that Excel users commonly use.
Commands Not in the Ribbon: Displays a list of commands that you cannot access from the
     Ribbon.
All Commands: Displays a complete list of Excel commands. Macros: Displays a list of all available macros.
File Tab: Displays the commands available in the back stage window.
Home Tab: Displays all commands that are available when the Home tab is active. In addition, the drop-down list contains an item for every other tab.
Sometimes, you need to do some guessing to find a particular command. For example, if you want to
add the command that displays the Excel Options dialog box, you can find it listed as Options, not
Excel Options.