Microsoft KB Archive/121824

= Toolbar Button Capable of Alternate Action =

Article ID: 121824

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q121824





SUMMARY
In Microsoft Excel, you can change the behavior of some toolbar buttons by holding down the SHIFT key and then choosing the button. For example, if you hold down the SHIFT key and choose the Open button, the picture on the button changes, and the Save As dialog box appears. Or, if you hold down the SHIFT key and choose the Save button, the Open dialog box appears (the same dialog box you receive when you choose the Open button or when you choose Open from the File menu).

This dual functionality can be helpful if you want to customize a toolbar and you need to remove some of the toolbar buttons.

This behavior is by design.



MORE INFORMATION
Some of the buttons that change when you use them in conjunction with the SHIFT key are listed in the following table.                                               Button is on   SHIFT + this button   Changes to this       this toolbar

Open                 Save as               Standard Save                 Open                  Standard Print                Print Preview         Standard Print Preview        Print                 Standard Sort Ascending       Sort Descending       Standard Sort Descending      Sort Ascending        Standard Underline            Double Underline      Formatting Double Underline     Underline             Formatting

