Customize Toolbars & Menus in Excel

Excel has many toolbars and menus that you can turn on and off. You can customize these by removing or adding buttons to fit your needs and preferences.

 

A toolbar is either docked or floating. Docked toolbars are attached to the edge of the Program window, while floating toolbars appear suspended over the worksheet. You can dock and toolbar just like you can make any toolbar floating.

 

As with toolbars, you can also customize menus by adding or deleting commands.

---

---

How To Show or Hide Toolbars:

1. Right click on a Toolbar
2. Observe the shortcut menu
3. Select the toolbar you want to on or off.
   • The ones with a check beside it are turned on.

How To Move toolbars:

1. Observe the toolbar you want to move or make floating.
2. Point to the left side of the docked toolbar.
   • You should see a vertical row of 2 dotted lines.
3. Click, hold and drag the toolbar to it's new location.
4. Release your mouse.

How To Dock toolbars:

1. Observe the floating toolbar you want to dock.
2. Point to the top of the floating toolbar.
3. Click, hold and drag the toolbar to it's new location.
4. Release your mouse.

How To Customize your toolbars:

1. From the Tools menu choose Customize to open the Customize dialog box.
2. Click the Commands tab.
3. From the Categories list, select the category of the command you want to find.
4. From the Commands list, select the desired command.
5. Drag the command onto the desired toolbar.
6. Repeat Steps 3 to 5 for adding additions buttons.
7. Click Close when finished.

How To Reset your toolbars:

1. From the Tools menu choose Customize to open the Customize dialog box.
2. Click the Toolbars tab.
3. Select the Toolbar you want to reset back to default.
4. Click Reset.
5. Click OK to the confirmation dialog box.
6. Repeat Steps 3 to 5 to reset addition toolbars.
7. Click Close when finished.

How To Customize your menus: Windows only

1. Be VERY CAREFUL when following these steps. It is very easy to lose menus.
2. From the Tools menu choose Customize to open the Customize dialog box
3. Click the Commands tab.
4. From the Categories list, select the menu to which you want to add a command.
5. From the Commands list, select the command you want to add.
6. Drag the selected command onto the appropriate menu.
7. Repeat Steps 4 to 6 for additional menu additions.
8. Click Close when finished.

How To Customize your menus: Macintosh only

1. Be VERY CAREFUL when following these steps. It is very easy to loose menus.
2. From the Tools menu choose Customize to open the Customize dialog box
3. Click the Toolbars tab.
4. Check Worksheet Menu Bar.
   • Another menu bar appears under your existing toolbars.
5. Click the Commands tab.
6. From the Categories list, select the menu to which you want to add a command.
7. From the Commands list, select the command you want to add.
8. Drag the selected command onto the appropriate menu using the new menu bar that appears after Step 4.
9. Repeat Steps 5 to 8 for additional menu additions.
10. Click Close when finished.

How To Restore your menus:  

To remove the toolbar command:

1. From the Tools menu choose Customize to open the Customize dialog box
2. Click the Commands tab.
3. Click on the menu that contains a command you want to remove.
4. Select the command and right click on it.
5. Choose Delete from the drop-down list.
6. Repeat Steps 3 to 5 for additional menu removals.
7. Click Close when finished.