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.
↑ Back to the top
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.
↑ Back to the top
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.
↑ Back to the top