XL2000: Zooming 39% or Less Changes the Worksheet Appearance (211456)



The information in this article applies to:

  • Microsoft Excel 2000

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.

Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kbprb KB211456