Part I: Getting Started with Excel
About the Quick Access toolbar
By default, the Quick Access toolbar is located on the left side of the Excel title bar, above
the Ribbon (see Figure 8.1). Unless you customize it, this toolbar includes four tools:
AutoSave Periodically saves workbooks that have already been saved to OneDrive or
SharePoint
Save Saves the active workbook
Undo Reverses the effect of the last action
Redo Reverses the effect of the last undo
FIGURE 8.1
The default location for the Quick Access toolbar is on the left side of the Excel title bar.
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 or two fewer rows 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’t move it to a convenient location.
It always appears either above or below the Ribbon.
Commands on the Quick Access toolbar always appear as small icons with no text. An
exception to this rule is drop-down controls that display text. For example, if you add the
Font control from the Home ➪ Font group, it appears as a drop-down control in the Quick
Access toolbar. When you hover your mouse pointer over an icon, you see a ScreenTip show-
ing the name of the command and a brief description.
You can customize the Quick Access toolbar by adding or removing commands. If you
find that you use some Excel commands frequently, you can make these commands easily
