Creating a Toolbar

If none of the existing Excel toolbars fits your needs or if you just want a toolbar to call your own, you can create a new toolbar. You might use the Page Break command very often. Wouldn't it be easier if you had that button on your own toolbar? Perhaps your workbooks require a lot of formatting. Wouldn't it be more convenient if you had a special toolbar containing a variety of formatting buttons? Creating a toolbar that contains the buttons necessary for your most common tasks can dramatically increase your efficiency. Besides creating toolbars, you can change toolbar and menu options to best meet your working habits.

Create a Toolbar

Click the View menu, point to Toolbars, and then click Customize.

Click the Toolbars tab, and then click New.

Type a name for the new toolbar.

Click OK.

The new toolbar appears on your screen. The toolbar name may not fit in the title bar until the toolbar is long enough.

Click the Commands tab.

Click a category that contains the command(s) you want to add.

Click a command you want to add to the toolbar.

Drag the button to the new toolbar.

Repeat steps 6 through 8 until all buttons you want are added.

Click Close.

Change Toolbars and Menus Options

Click the View menu, point to Toolbars, and then click Customize.

Click the Options tab.

Select Personalized Menus and Toolbars options as needed.

Select Other options as needed.

To animate your menus, click the Menu Animations list arrow, and then select an animation.

Click Close.

Did You Know?

You can use the Close button to hide a toolbar . Click the Close button on a floating toolbar's title bar to hide it.

You can restore a toolbar to its original buttons . In the Customize dialog box, click the toolbar you want to restore, and then click Reset.

See Also

See " Changing Your Worksheet View " on page 292 for information on customizing the way your worksheet appears.