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 …

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.

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.

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 …

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.

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.

Select one or more columns to freeze. Click Design > Columns > Freeze. A frozen column moves to the front of the table. Additional columns that you freeze are positioned next to the first column that you …

You can set options to print a sheet's headings (A, B, C...1, 2, 3) or column or row titles on every page.

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.