Excel: Window Reverts to 100 Percent View

ID: Q90398


The information in this article applies to:


SUMMARY

Altering the attributes of a line drawing object while zoomed to a view other than 100 percent may cause the spreadsheet to unexpectedly revert to a 100 percent view. In this situation, previously zoomed elements of the document (such as row or column headings) will not be redrawn until an operation forces an update of the entire window.


MORE INFORMATION

Clicking the None option button which appears in the Line section of the Patterns dialog causes this problem, even if another option button (such as, Automatic or Custom) is subsequently clicked. The only workaround is to avoid clicking the None option button while in zoom view, or to reset the view after formatting the line object.

Note: This information does not apply to the formatting of drawing objects other than lines.

To force an update of the entire document, resize the window slightly or double-click the window title bar. A quick method to force an update with the keyboard is to press CTRL+~ (tilde) twice. This toggles the document from displaying formulas to values, and back again (or vice versa, depending on the original state of the document.)

Microsoft is currently researching this problem and will post more information here as it becomes available.

Additional query words: large small size headers


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 29, 1999