Home / Computers / Microsoft Excel

Toolbars (Continued)

Other toolbars available in Excel are:

• Chart - Create and work with charts.
• Clipboard - View and select the contents of the clipboard.
• Control Toolbox - Insert ActiveX controls into a form.
• Drawing - Insert and format drawing objects.
• External Data - Work with data imported from external sources.
• Forms - Insert form objects.
• Picture - Insert and format pictures.
• Pivot Table - Create and work with pivot tables, interactive tables for large amounts of data.
• Reviewing - Insert, edit, and delete comments for or by reviewers.
• Visual Basic - Record and run macros, and work with Microsoft Word Visual Basic code.
• Web - Navigate a Web document.
• WordArt - Insert and format WordArt.

You can customize any of these toolbars by adding and removing buttons, or you can create your own toolbars to group your favorite commands: Just right-click one of the visible toolbars, select Customize from the menu that appears, and, in the Customize dialog, select the Commands tab to add or remove commands.

Each of Excel's toolbars can be moved simply by clicking and dragging the title bar (if the toolbar is floating) or the move handle (if the toolbar is docked).

The move handle is located at the left edge of the toolbar. When you move the mouse over it, the pointer changes to horizontal and vertical arrows, indicating you can drag the toolbar.

1. Drag the toolbar off the row. The toolbar changes from docked to floating.

2. Click the title bar and drag the toolbar back into place.

If you drag a toolbar to a full row, the surrounding toolbars will shrink to make room for it. To access a button that's no longer visible, click the chevrons at the right edge of the toolbar.

Tip:

To quickly remove buttons you don't use, or add new buttons, select Add or Remove Buttons. In the menu, uncheck the buttons you don't need, or select new buttons to add. Select Customize to choose from all the available commands.