Excel® 2007 Bible

Chapter 23. Customizing the Quick Access Toolbar

<feature><title>In This Chapter</title>

• About the Quick Access Toolbar

• Adding frequently used commands to the QAT

• Adding commands that are otherwise not available

</feature>

In previous versions of Excel, it was relatively easy for end users to make changes to the user interface. They could create custom toolbars that contained frequently used commands, and they could even remove menu items that they never used. Users could display any number of toolbars and move them wherever they liked. Those days are over.

With the introduction of the new Ribbon-based user interface in Office 2007, end-user customization is severely curtailed. Although you can modify the Ribbon, it’s a rather complicated process, and it’s not something a casual user would do. In Office 2007, user-interface customization is limited to the Quick Access Toolbar, or QAT, which is the topic of this chapter.

About the QAT

The QAT is always visible, regardless of which Ribbon tab is selected. After you customize the QAT, your frequently used commands will always be one click away.

Note

The only situation in which the QAT is not visible is in Full Screen mode, which is enabled by choosing View Workbook Views Full Screen. To cancel Full Screen mode, right-click any cell and ...