Excel 2003: Customizing Toolbars

Excel 2003: Customizing Toolbars

In all of your experience with Excel, you’ve no doubt found a command or two that you find yourself plowing through the Menu bar to access. Instead of digging through the Menu bar, you can add common commands to your existing Standard and Formatting toolbars so you can just click one button.

Adding a Button to a Toolbar

Right-click any toolbar

Choose Customize…

Figure 23. Customize Toolbars Dialog Box

3.Find the menu command you want to add and drag it onto either the Standard or Advanced toolbar

4.When finished, click Close

Removing a Button from a Toolbar

You can remove a button from a toolbar by either opening the Customize Dialog box or simply holding down [Alt] and dragging a button off.