Microsoft Office Tutorials and References
In Depth Information
Excel’s User Interface
Figure 2-7: This small dialog launcher icon, when clicked, displays a dialog box that has additional options.
In Excel 2007, end users couldn’t modify the Ribbon. In Excel 2010, users can easily
add or remove commands. See Chapter 22 for information about customizing the
The Quick Access toolbar
The Quick Access toolbar is a place to store commonly used commands. The Quick Access
toolbar is always visible, regardless of which Ribbon tab you select. Normally, the Quick Access
toolbar appears on the left side of the title bar. Alternatively, you can display the Quick Access
toolbar below the Ribbon by right-clicking the Quick Access toolbar and selecting Show Quick
Access Toolbar Below the Ribbon.
By default, the Quick Access toolbar contains three tools: Save, Undo, and Redo. You can, of
course, customize the Quick Access toolbar by adding other commands that you use often. To
add a command from the Ribbon to your Quick Access toolbar, right-click the command and
choose Add To Quick Access toolbar.
Excel has quite a few commands that aren’t available in the Ribbon. In most cases, the only way
to access these commands is to add them to your Ribbon or Quick Access toolbar. Figure 2-8
shows the Quick Access toolbar section of the Excel Options dialog box. This area is your
onestop shop for Quick Access toolbar customization. A quick way to display this dialog box is to
right-click the Quick Access toolbar and choose Customize Quick Access toolbar.
Accessing the Ribbon by using your keyboard
At first glance, you may think that the Ribbon is completely mouse-centric. After all, none of the
commands has the traditional underlined letter to indicate the Alt+keystrokes. But, in fact, the
Ribbon is very keyboard friendly. The trick is to press the Alt key to display the pop-up keytips.
Each Ribbon control has a letter (or series of letters) that you type to issue the command.