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.

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 Sheet tab, in …

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.

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 – …

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.

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.

Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Select OK.

To keep an area of the Data Model visible while you scroll to another area in the Power Pivot window, you can lock specific columns in one area by freezing them.