Microsoft Office Tutorials and References
In Depth Information
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 topic.
Adding Buttons to the Quick Access Toolbar
As you continue to work with Excel 2010, you might discover that you use certain
commands much more frequently than others. If your workbooks draw data from external
sources, for example, you might find yourself displaying the Data tab and then, in the
Connections group, clicking the Refresh All button much more 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, located just above the ribbon in the
upper-left corner of the Excel program window.
To add a button to the Quick Access Toolbar, click the File tab, and then click Options. In
the Excel Options dialog box, display the Customize The Quick Access Toolbar page. This
Options 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. To add a command to the Quick Access Toolbar,
display the Customize The Quick Access Toolbar page of the Options dialog box. Then,
in the Choose Commands From list, click the category that contains the control you
Search JabSto ::

Custom Search