Excel: Window Reverts to 100 Percent View

Last reviewed: November 29, 1994
Article ID: Q90398
The information in this article applies to:
  • Microsoft Excel for the Macintosh, version 4.0
  • Microsoft Excel for Windows, version 4.0

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.


KBCategory: kbprb
KBSubcategory:

Additional reference words: 4.0 4.00 large small size headers


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.