Excel 2016 Managing Worksheets

Lesson 3 – Using Large Worksheets

Excel 2016

Frozen row and column headings

NOTE You can also select Freeze Top Row and Freeze First Column from the Freeze Panes button..

P ROCEDURES

1. To freeze both row and column headings, place the active cell in the cell directly below the column headings you want to freeze and to the right of the row headings you want to freeze. 2. Select the View tab.

3. Select the Freeze Panes button

in the Window group.

4. Select Freeze Panes .

S TEP - BY -S TEP Freeze the panes in a worksheet.

Scroll to view cell A1.

Page 42

OFFICEPRO, Inc.

Made with FlippingBook Annual report