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 First Column. When you do this, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.

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 figure below—because D5 was chosen—columns to its left (A-C) and rows above it (1-4) are frozen by the split. Then, by selecting a row below row 4 and scrolling up, you no longer see rows 5 …

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.

You're scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > …

Print column headings on each page of your worksheet so your readers won’t have to go back to the first page to see the headers.

How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.

If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.