O'Reilly logo

Excel 2013 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 24: Customizing the Excel User Interface

In This Chapter

Customizing the Quick Access toolbar

Customizing the Ribbon

A software program's user interface consists of all the ways that the user interacts with the software. In Excel, the user interface consists of

• The Ribbon

• The Quick Access toolbar

• Right-click shortcut menus

• Dialog boxes

• Task panes

• Keyboard shortcuts

This chapter describes how to make changes to two Excel user interface components: the Quick Access toolbar and the Ribbon. You might want to customize these elements to make Excel more suited to the way you use it.

Customizing the Quick Access Toolbar

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.

Note

The only situation in which the Quick Access toolbar is not visible is in full-screen mode, which is enabled by clicking the Ribbon Display Options button in the Excel title bar, and choosing Auto-hide Ribbon. Full-screen mode works differently in Excel 2013 than it did in previous versions. To temporarily display the Quick Access toolbar (and Ribbon) in full-screen mode, click the title bar. To cancel full-screen mode, click the Ribbon Display Options button in the Excel title bar, and choose Show Tabs or Show Tabs and Commands.

About the Quick Access toolbar

By default, the Quick Access toolbar is located on the left side of Excel title bar, above ...

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