Wednesday, February 02, 2005

Double uses for buttons on Excel Toolbar

From Excel Tips

Some of the icons on the Standard and Formatting toolbars perform two different (but related) tasks. To toggle between the two tasks, press Shift while clicking the icon. The icons that perform different tasks are:

In the Standard toolbar:

*Print Print Preview
*Sort Ascending Sort Descending
*Open Save
*In the Formatting toolbar:
*Increase Indent Decrease Indent
*Underline Double Underline
*Center Merge and Center
*Increase Decimal Decrease Decimal

Example: The Open icon changed to Save when pressing the Shift key.

To remove the double-task icons:
Drag the icon off the toolbar while holding the Alt key.