Excel 2016 Managing Worksheets

Excel 2016

Lesson 3 – Using Large Worksheets



P ROCEDURES

1. Select the View tab.

2. Select the Zoom button in the Zoom group. 3. Under Magnification , select the desired option. 4. Select .



S TEP - BY -S TEP From the Student Data directory, open COMM09.XLSX . Increase 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

200%

4. Select OK .

Click

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

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

D ECREASING THE M AGNIFICATION  D ISCUSSION

You can decrease the magnification of the worksheet. Decreasing the magnification makes the cells appear smaller and allows more cells to appear in the window. This option is useful when you want to view a larger portion of the worksheet. For example, with a worksheet containing annual sales, you may want to view the sales for the entire year, or you may want to review the formatting or layout of the entire worksheet.

OFFICEPRO, Inc.

Page 33