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 …

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.

Hide columns Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide.

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.

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

Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Lock or unlock specific areas of a protected worksheet Protect a worksheet …