XL98: Setting Zoom to 39% or Less Changes Worksheet

ID: Q181482

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel 98 Macintosh Edition, a worksheet appears differently if you click Zoom on the Standard toolbar and select a value that is less than or equal to 39 percent.

MORE INFORMATION

In Microsoft Excel 98, you can click Zoom on the Standard toolbar to reduce or enlarge the appearance of the active worksheet. 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).

NOTE: If you select or type a zoom value that is 39 percent or less, the following changes in the graphical appearance of the worksheet are noticeable.

Gridlines Are Not Displayed

In Microsoft Excel 98, it is not possible to display gridlines when the zoom value is 39 percent or less. When you select a zoom value of 40 percent or greater, gridlines reappear. Note that cell borders are displayed at all zoom settings.

In earlier versions of Microsoft Excel, gridlines are displayed at all zoom settings unless you manually disable them.

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 that contains the word "Range1" appears over the cell range. The values of the cells in the named range appear in the rectangle.

NOTE: When you click Zoom on the Standard toolbar and type a value of 40 percent or greater, rectangles that identify named ranges automatically disappear.

This feature is not available in earlier versions of Microsoft Excel.

REFERENCES

For more information about how to zoom the display of a worksheet, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

zooming

and then click Show Topics. Select the "Magnify or reduce the display" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: contiguous XL98

Keywords : kbdta xlui
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto