Thursday, January 20, 2005

Customise the toolbar in Excel

From Excel Tips

Almost 50% of the menu bar line is empty.

Use this empty space to add useful icons such as Page Setup, Custom Views, Macro, and more.

To add icons to the menu bar:

1. Place the mouse arrow on one of the toolbars, right-click, and select Customize from the shortcut menu.
2. Select the Commands tab.
3. From Categories, select File and drag the Page Setup icon to the menu bar.
4. Repeat step 3 for the Custom Views icon (from View) and for the Macro icon (from Built-in Menus).
5. Click Close.

Note:

These new icons also have keyboard shortcuts, which are used by pressing Alt and the underlined letter.
For example, to open the Page Setup dialog box, press Alt+U.

Screenshot


Posted by: Jethro | 7:34 PM |