Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Removing Borders

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

 

Creating a New Toolbar

Summary: Excel's interface can be easily modified to reflect the way you want to do your work. This tip explains how you can create a custom toolbar with just the tools you regularly use. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

As you are customizing Excel to reflect your working habits, there may be times when you want to create your own custom toolbar. You can create a toolbar by following these steps:

  1. Choose Customize from the Tools menu. This displays the Customize dialog box.
  2. Make sure the Toolbars tab is selected. (Click here to see a related figure.)
  3. Click on New. This displays the New Toolbar dialog box. (Click here to see a related figure.)
  4. Provide a name for your toolbar in the Toolbar Name box.
  5. Click on OK to close the New Toolbar dialog box. The toolbar appears at the bottom of the list of toolbars on the Toolbars tab of the Customize dialog box. The empty toolbar should also be visible on your screen.
  6. Click on the Commands tab in the Customize dialog box. (Click here to see a related figure.)
  7. In the list of Categories, select the major category which contains the command you want to add to the new toolbar.
  8. In the list of Commands, select the command you want to add to the toolbar.
  9. Use the mouse to drag the command from the Commands list to its new location on your toolbar. When you release the mouse button, the icon or wording for the command appears.
  10. Repeat steps 7 through 9 to add more toolbar commands.
  11. Click on Close to dismiss the Customize dialog box.

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

Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!
 
Check out ExcelTips Archives today!