Quite often, the Quick Access Toolbar is more convenient when performing calculations and formatting workbooks in Microsoft Office Excel 2010.
By default, it contains the following standard buttons: Save, Undo, Redo, and Customize Quick Access Toolbar.
If you frequently use certain commands more than others, you can add the required button to the Quick Access Toolbar by clicking the Customize Quick Access Toolbar button and selecting either a command from the available list or the More Commands option.
In the latter case, the Excel Options window opens in the Quick Access Toolbar category, where you can choose the necessary buttons and add them to the toolbar using the options available in that window.
Another way to open the Excel Options window is as follows: click the File tab in Microsoft Office Excel 2010 and select the Options command. In the opened Excel Options window, go to the navigation pane and choose the Quick Access Toolbar category.
Note
Another method to open the Excel Options window in the Quick Access Toolbar category is to open the context menu of the Quick Access Toolbar and select Customize Quick Access Toolbar.
Now you can add other buttons to the Quick Access Toolbar using the list boxes and control buttons: select a command from the left list and add it to the right list by clicking the Add button located between the two lists.
To remove a button from the Quick Access Toolbar, select it in the right column and use the Remove button (also located between the lists). The arrow buttons to the right of the right column allow you to adjust the order of the buttons on the Quick Access Toolbar.
By default, only frequently used commands are displayed in the left pane. To change the list of commands, use the drop-down menu in the Choose commands from field and select the desired category: all commands, all commands on the ribbon, macros, commands from the Office menu (the menu that opens when you click the Microsoft Office button), or any ribbon tab.
When selecting a command from the Customize Quick Access Toolbar list, you can also specify where the added buttons will be used: only in the current workbook or in all Excel workbooks.
In addition to adding commands, in the Excel Options window under the Quick Access Toolbar category, you can also set the option to place the toolbar below the ribbon by checking the corresponding box at the bottom of the window.
The Settings group allows you to reset all Quick Access Toolbar settings or perform the appropriate import/export of settings.
Tip
To add any command from the ribbon to the Quick Access Toolbar, use the context menu: right-click the required ribbon button and select Add to Quick Access Toolbar.
The Customize Quick Access Toolbar option in the context menu also allows you to open the Quick Access Toolbar category of the Excel Options window.
To remove a button from the Quick Access Toolbar, open its context menu and choose Remove from Quick Access Toolbar.