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 …

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 …

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.

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 …

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.

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

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.

These steps 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 workbook.

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 …

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …