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 …

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.

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 …

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 …

If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.

Select the cell below the rows, and to the right of the columns you want to freeze. For example, select cell B3 if you want to freeze the first two rows and the first column.

In the table, right-click in the row that you want to repeat, and then select Table Properties. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of …

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 …

Select View, Select Freeze Panes, then select Freeze Top Row. For more information, such as freezing selected rows and columns in your workbook, see Freeze panes.