244 Chapter 8 Set Up a Workbook
Arranging windows vertically.
Troubleshooting The appearance of buttons and groups on the ribbon changes depending on
the width of the program window. For information about changing the appearance of the ribbon
to match our images, see “Modifying the Display of the Ribbon” at the beginning of this book.Adding Buttons to the Quick Access Toolbar.
As you continue to work with Excel 2010, you might discover that you use certain com-
mands much more frequently than others. If your workbooks draw data from external
sources, for example, you might find yourself using the Refresh All button on the Data
tab quite often than the program’s designers might have expected. You can make any
button accessible with one click by adding the button to the Quick Access Toolbar, lo-
cated just above the ribbon.
To add a button to the Quick Access Toolbar, display the Customize The Quick Access
Toolbar page of the Excel Options dialog box. This page contains two panes. The pane
on the left lists all of the controls that are available within a given category, and the
pane on the right lists the controls currently displayed on the Quick Access Toolbar.
In the Choose Commands From list, click the category that contains the control you
want to add. Excel 2010 displays the available commands in the box below the Choose
Commands From field. Click the control you want, and then click the Add button.