To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes …

Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and 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 …

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

To freeze multiple columns (starting with column A), select the column to the right of the last column you want to freeze, and then tap View > Freeze Panes > Freeze Panes.

Freeze columns and rows to keep them in view while you scroll through your data. Select the cell below the rows, and to the right of the columns you want to freeze.

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.

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.

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.