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 …

On the View tab, select Freeze Panes. Any time you freeze rows and columns, the border below the last frozen row and to the right of the last frozen column appears a little thicker (here, …

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.

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

Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the 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.

When you split a sheet into separate panes, you can scroll in both panes independently. Select below the row where you want the split, or the column to the right of where you want the split.

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.

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 …

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.