Microsoft Office Tutorials and References
In Depth Information
Customizing the Quick Access Toolbar
Customizing the Quick Access Toolbar
If you find that you continually need to switch Ribbon tabs because a frequently used command
never seems to be on the Ribbon that’s displayed, this tip is for you. The Quick Access toolbar is
always visible, regardless of which Ribbon tab is selected. After you customize the Quick Access
toolbar, your frequently used commands will always be one click away.
The only situation in which the Quick Access toolbar is not visible is in Full Screen
mode, which is enabled by choosing View
Full Screen. To cancel
Full Screen mode, right-click any cell and choose Close Full Screen or press Escape.
Workbook Views
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 the following three tools:
h Save: Saves the active workbook.
h Undo: Reverses the effect of the last action.
h Redo: Reverses the effect of the last undo.
If you prefer, you can move the Quick Access toolbar below the Ribbon: Right-click the Quick
Access toolbar and choose Show Quick Access Toolbar Below The Ribbon. Moving the Quick
Access toolbar below the Ribbon eats up additional vertical space on your screen. In other words,
you see one or two fewer rows of your worksheet if you move the Quick Access toolbar from its
default location.
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 commands 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:
h Click the Quick Access toolbar drop-down control, which is located on the right side of
the Quick Access toolbar (see Figure 11-1). The list contains several commonly used
commands. Select a command from the list, and Excel adds it to your Quick Access toolbar.
 
Search JabSto ::




Custom Search