Working with Built-In and Custom Toolbars
You can add, delete, or move buttons on Excel’s built-in toolbars.
E.g. adding and rearranging buttons on the standard toolbar. Procedure: choose Tools, Customize. (The customize dialog will display. The standard and Formatting toolbars will display in the background when the Customize dialog box is open). Select the Commands tab. (This tab lists all command in all of Excel’s menus).
E.g. adding one of these commands as a button on the standard toolbar. From the Categories list, select Edit. On the vertical scrollbar, click three times below the button. Select the Clear Formatting button. (You can always get additional information about a command once it is selected). Click on the Description button. When you’re ready, click in the indicated area to close the description.
E.g.2. placing the Clear Formatting command on the Standard toolbar. Procedure: drag and drop the Clear Formatting button on the standard toolbar where indicated. To remove, Point to the AutoSum button and drag it off the toolbar.
In addition to adding and deleting buttons on toolbars, you can rearrange button positions. E.g. on the Standard toolbar, drag the Spelling button to the left of the Undo button. Close the Customize dialog box.
In the worksheet, cell A1 is selected. Click on the Clear Formatting button. (The formatting in cell A1 has been cleared). Reapplying the original formatting. Click on the Undo button.
You can restore any of the built-in toolbars to their original state at anytime. Right click on the Standard toolbar in the indicated area. On the Toolbar shortcut menu, choose Customize. (The Customize dialog will display and the Toolbars tab will be selected). In the Toolbars list, the Standard toolbar is selected. Click on Reset. (A dialog box prompts you to verify that you want to reset the toolbar). Click on Ok. click on Close.
How to create custom toolbars. From the Toolbars shortcut menu, choose Customize. Uncheck Standard to hide the Standard toolbar. Click on New. (A New Toolbar dialog box will display). Type My Toolbar and click on Ok. adding some buttons to it. On the commands tab, select File from the Categories list. Drag the Open button to the new toolbar. The toolbar width automatically adjusts to accommodate the button that you added. Toolbars can also be docked at the edge of the application window.
You can change a toolbar’s position by either dragging it or by double-clicking on the toolbar’s background. You can also move a toolbar out of a docked position by pointing to the handle on the left side, pressing the mouse button, and dragging. When you’re finished with a custom toolbar, you can delete it. Procedure: Select the Toolbars tab. Scroll the Toolbars list and select My Toolbar. Click on Delete. Click on Ok.
Redisplaying the Standard toolbar. Scroll the Toolbars list and check Standard. Close the Customize dialog box.
Regards,
BEM T.
Social Plugin