bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Customizing Excel > Toolbars > Customizing a Toolbar

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:

  1. Choose Customize from the Tools menu. Excel displays the Customize dialog box.
  2. Make sure the Toolbars tab is selected. (Click here to see a related figure.)
  3. In the list of toolbars, make sure the toolbars you want to edit are selected.
  4. Click on the Commands tab. (Click here to see a related figure.)
  5. In the list of Categories, select the major category which contains the command you want to add to the toolbar.
  6. In the list of Commands, select the command you want to add to the toolbar.
  7. 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.
  8. Repeat steps 5 through 7 to add new toolbar commands.
  9. Click on Close to dismiss the Customize dialog box.

Tip #2724 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


PivotTables Got You Perplexed? Learn the ins and outs of this powerful data-crunching tool. ExcelTips: PivotTables for the Faint of Heart makes it easy.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)