Related Tutorial: Excel Autoformat.The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel . It is also where you can add the shortcuts to Excel features that are not available on the ribbon.
One of these features is Autoformat.
Autoformat is a quick and easy way to give your spreadsheet a professional look by applying several formatting options, such as background color, font style, and number formatting at one time.
For some reason, however, Microsoft chose not to add Autoformat to one of the tabs of the ribbon in Excel 2007 or Excel 2010.Below are steps that will show you how to add the Autoformat button to the Quick Access Toolbar.
This is a onetime operation. Once added, the Autoformat button remains available on the Quick Access Toolbar.
Add the Autoformat Button to the Quick Access Toolbar
For help with these steps, see the image above.
- Click on down arrow at the end of the Quick Access Toolbar to open the drop down menu.
- Choose More Commands from the list to open the Customize the Quick Access Toolbar dialog box.
- Click on down arrow at the end of the Choose commands from line to open the drop down menu.
- Choose All Commands from the list to see all the commands available in Excel in the left hand pane.
- Scroll through this alphabetical list to find the Autoformat command.
- Click on Add button between the command panes to add the Autoformat button to the Quick Access Toolbar.
- Click OK.
- The Autoformat button should now be added to the Quick Access Toolbar.
More Formatting Tutorials