Excel 2016 Managing Worksheets

Lesson 3 – Using Large Worksheets

Excel 2016

I NCREASING THE M AGNIFICATION  D ISCUSSION

You can increase the magnification of the worksheet. Magnifying a worksheet is similar to using a magnifying glass; it makes the cells and their contents appear larger. This option is useful when you want to view a small portion of the worksheet in greater detail. For example, with a worksheet containing annual sales, you may want to view only sales for the current quarter.

The default magnification is 100%. The larger the percentage, the larger the cells appear. For example, with a magnification of 200%, the cells appear twice as large as with a magnification of 100%.

A worksheet at 200% magnification

NOTE Changing the magnification affects the screen display only. It does not affect the appearance of the printed worksheet. You can also use the Zoom Slider on the Status bar to change the magnification.

Page 32

OFFICEPRO, Inc.