Renaming a Toolbar

Summary: You can easily create custom toolbars in Excel. Each of the toolbars has a name, and you can just as easily change that toolbar's name at a later time. This tip shows how easy it really is. (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 other issues of ExcelTips. Once created, you may want to rename one of your custom toolbars to more accurately reflect its purpose. You cannot rename the built-in toolbars used by Excel. If you want to rename one of your custom toolbars, you should follow these steps:

Choose the Customize option 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, select the one you want to rename. (Remember, you can only rename custom toolbars.)
Click on the Rename button. (The button should be available if you selected a custom toolbar in step 3.) Excel displays the Rename Toolbar dialog box. (Click here to see a related figure.)
In the Toolbar Name box, change the toolbar name to suit your needs.
Click on OK.
Click on Close.

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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Renaming a Toolbar