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