Microsoft KB Archive/211456

= XL2000: Zooming 39% or Less Changes the Worksheet Appearance =

Article ID: 211456

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211456





SYMPTOMS
If you click Zoom on the View menu to reduce or enlarge the appearance of the active worksheet, and you select a zoom value of 39 percent or less, gridlines are no longer visible.



CAUSE
In Microsoft Excel 2000, gridlines are not displayed when the zoom value is 39 percent or less. When you select a zoom value of 40 percent or greater, gridlines reappear.

NOTE: Cell borders are displayed at all zoom settings.



MORE INFORMATION
In Microsoft Excel, you can specify a zoom value that is between 10 percent (text appears one-tenth the normal size) and 400 percent (text appears four times the normal size).

Named Range Identification
When you set the zoom setting for a worksheet to 39 percent or less, a defined name that consists of a cell range of two or more adjacent cells appears in a rectangle on the screen.

For example, if the defined name "Range1" refers to the range D1:E20, a rectangle containing the word "Range1" appears over the cell range, and the values of the cells in the named range appear in the rectangle.

NOTE: When you click Zoom on the View menu and select a value of 40 percent or greater, rectangles that identify named ranges disappear.

Additional query words: contiguous XL2000

Keywords: kbprb KB211456

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.