Part IV: Using Advanced Excel Features
542
About the Quick Access toolbar
By default, the Quick Access toolbar is located on the left side of Excel title bar, above the Ribbon
(see Figure 23.1). It includes three tools:l Save: Saves the active workbookl (^) Undo: Reverses the effect of the last action
l Redo: Reverses the effect of the last undo
If you prefer, you can move the Quick Access toolbar below the Ribbon. To do so, right-click the
Quick Access toolbar and choose Show Quick Access Toolbar below the Ribbon. Moving the
Quick Access toolbar below the Ribbon uses additional vertical space on your screen. In other
words, you’ll be able to see one less row of your worksheet if you move the Quick Access Toolbar
from its default location. Unlike traditional toolbars, the Quick Access Toolbar cannot be made
free-floating so you can move it to a convenient location. It always appears either above or below
the Ribbon.
FIGURE 23.1
The default location for the Quick Access toolbar is on the left side of the Excel title bar.
Commands on the Quick Access toolbar always appear as a small icon, with no text. When you
hover your mouse pointer over an icon, you see the name of the command and a brief description.
Customizing the Quick Access toolbar consists of adding new commands to it. If you find that you
use some Excel commands frequently, you can make these commands easily accessible by adding
them to your Quick Access toolbar. You can also rearrange the order of the icons.
As far as I can tell, there is no limit to the number of commands that you can add. The Quick
Access toolbar always displays only 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.