How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.
You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.
On the View tab, select Freeze Top Row. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.
By splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12. Then, click View > Window > Split.
If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows. On the Sheet tab, in the Rows to repeat at top box, type "$1:$1" (as shown in the figure).
If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets.
Once you are done with your changes, you can lock these cells. Follow these steps to lock cells in a worksheet: Select the cells you want to lock. On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK to close the ...
In the Columns to repeat at left box, enter the reference of the columns that contain the row labels. For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.
