Resetting Toolbars to Their Default

Summary: Once you've edited your toolbars, you may want to change them back to their default appearance and behavior. This tip explains how you can quickly revert to those defaults. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel is very flexible. You can customize your working environment to your heart's content. You can change menus, the toolbar, viewing and printing options, and many more variables. There may come a day, however, when you want to reset the Excel toolbars structure their default condition. When you do this, all the toolbar buttons and their order will be set to the same condition they were when you first installed Excel. If you want to reset the Excel toolbars, perform these steps:

Choose Customize from the Tools menu. You will see the Customize dialog box.
Make sure the Toolbars tab is selected. (Click here to see a related figure.)
In the list of available toolbars, select the one you want to reset.
Click on the Reset button. You are asked to confirm resetting of the toolbar.
Click on OK to reset the toolbar.
Repeat steps 3 through 5 for each toolbar you want to reset.
Click on Close to dismiss the Customize dialog box.

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

Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.

Check out Timesheet Templates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Resetting Toolbars to Their Default