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

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

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Deleting a Toolbar

Summary: After a time you may not need one of the custom toolbars you've created. This tip explains how to free up resources in Excel by getting rid of those unnecessary toolbars. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel allows you to create your own custom toolbars, as described in the previous tip. After your toolbar has outlived its usefulness, you may want to delete it. You cannot delete the built-in toolbars used by Excel. Follow 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. From the list of available toolbars, select the toolbar you want to delete.
  4. Click on the Delete button.
  5. You are asked to confirm your request to delete the toolbar. Click on OK to continue. The toolbar is removed.
  6. Repeat steps 3 through 5 for any other toolbars you want to delete.
  7. Click on Close.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2723) 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!