O'Reilly logo

Excel® 2007 Bible by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 23. Customizing the Quick Access Toolbar

<feature><title>In This Chapter</title>
</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 Note Workbook Views Note Full Screen. To cancel Full Screen mode, right-click any cell and select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required