Excel 2016 Managing Worksheets

Excel 2016

Lesson 3 – Using Large Worksheets



S TEP - BY -S TEP Decrease the magnification of a worksheet.

Steps

Practice Data

1. Select the View tab.

Click View

The View tab is displayed.

2. Select the Zoom button in the Zoom group. The Zoom dialog box opens. 3. Under Magnification , select the desired option. The option is selected.

Click

Click

75%

4. Select OK .

Click

The Zoom dialog box closes, and the magnification of the worksheet decreases accordingly.

Practice the Concept: Use the 100% button on the View tab to change the magnification back to 100% .

C HANGING THE M AGNIFICATION OF A R ANGE  D ISCUSSION

You can magnify a selected range so that its size adjusts as needed to fit the worksheet window. It is useful to zoom selections when you want to view all the cells in a range at the same time. For example, with a worksheet containing annual sales, you may want to zoom in on the numbers that make up the annual sales.

OFFICEPRO, Inc.

Page 35