Excel 2016 Managing Worksheets

Excel 2016

Lesson 3 – Using Large Worksheets

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

S WITCHING TO F ULL S CREEN V IEW  D ISCUSSION

You can view a worksheet without viewing screen elements such as the toolbar and ribbon using Full Screen view. This option allows you to display a large portion of a large worksheet. For example, you can use Full Screen view to display as much of an annual worksheet as possible, without changing the magnification.

Full Screen view



P ROCEDURES

1. In the upper right corner of the Excel window, click the Ribbon Display Options button . 2. Select Auto Hide Ribbon . 3. To return to Normal view, hover the mouse pointer over the top of the Excel screen until a colored band appears. 4. On the far right of the colored band, click to display the ribbon.



S TEP - BY -S TEP Switch to Full Screen view to view more of a worksheet.

OFFICEPRO, Inc.

Page 37