Chapter 23. Customizing the Excel User Interface


About the Quick Access toolbar

Adding frequently used commands to the Quick Access toolbar

Adding commands that are otherwise not available

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

  • Keyboard shortcuts

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

23.1. 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.


The only situation in which the Quick Access toolbar 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 choose Close Full Screen, or just press Esc(ape).

23.1.1. 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 ...

Get Excel® 2010 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.