XL98: Setting Zoom to 39% or Less Changes Worksheet

Last reviewed: February 20, 1998
Article 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 : xlui kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto


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: February 20, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.