Customize the Quick Access Toolbar Excel 2010

You can make Excel easier to use by customizing the Quick Access Toolbar to include the Excel commands you use most often. Because you launch Quick Access Toolbar buttons with a single click, adding your favorite commands to the toolbar saves you time.

By default, the Quick Access Toolbar contains three buttons — Save, Undo, and Redo — but you can add any of hundreds of Excel commands. In a default Excel configuration, the Quick Access Toolbar appears above the Ribbon as part of the Excel title bar. However, this position only allows you to add a few buttons, as there is only so much space in the title bar.

To get much more space to add buttons, you should move the Quick Access Toolbar below the Ribbon. You can also export your Quick Access Toolbar customizations to a file so that other people can import the same customizations. For more information, see the section, “Export Ribbon Customizations to a File.”

1. Click the Customize Quick Access Toolbar button.
   
   
   
2. If you see the command you want, you can click it; Excel adds the button for that command to the Quick Access Toolbar, and you can skip the rest of the steps in this section.
3. Click More Commands. The Excel Options dialog 3 box appears.
4. Excel automatically displays the Quick Access Toolbar tab. 3 Click the Choose Commands From drop-down arrow.
5. Click the command category you want to use. 
6. Click the command you want to add.
7. Click Add.
   ● Excel adds the command.
   ● To remove a  command,you can click it and then click Remove.
8. Click OK.
   
   
9. Excel adds a button for the command to the Quick Access Toolbar. 

Categories: Excel 2010