Customizing a Toolbar

Summary: Toolbars make it easy to quickly access your most common commands. Excel allows you to customize your toolbars so that they contain any or all of the commands you need. This tip explains how you can add new commands to the toolbars. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

You can completely change Excel to reflect how you want to do your work. One of the elements of the program you can change is the toolbars. You can add, remove, or edit buttons that appear on any toolbar. To customize a toolbar, follow these steps:

Choose Customize from the Tools menu. Excel displays the Customize dialog box.
Make sure the Toolbars tab is selected. (Click here to see a related figure.)
In the list of toolbars, make sure the toolbars you want to edit are selected.
Click on the Commands tab. (Click here to see a related figure.)
In the list of Categories, select the major category which contains the command you want to add to the toolbar.
In the list of Commands, select the command you want to add to the toolbar.
Use the mouse to drag the command from the Commands list to its new location on the toolbar. When you release the mouse button, the icon or wording for the command appears.
Repeat steps 5 through 7 to add new toolbar commands.
Click on Close to dismiss the Customize dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2724) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Customizing a Toolbar