Use View > Freeze Panes: choose Freeze Top Row for a header row, Freeze First Column for a left label column, or click the cell below and to the right of the area you want locked, then select Freeze Panes. If you choose the wrong option, the row or column scrolls away, and your labels, IDs, or comparisons become harder to follow. This guide shows the exact command for each case and the common failure states when freeze panes stops working.
What the scrolling problem means
When a row or column moves as you scroll, Excel is behaving normally unless you have applied a freeze command on the active Excel worksheet. The fix depends on what you want to keep visible: a header row, a left-side ID column, or both.
Freeze Panes is the View command that keeps specific rows or columns visible while you scroll. Use it on large tabular reports, and it can freeze rows, columns, or both on the current sheet.
How to tell which fix you need
If your labels run across the top, you usually need Freeze Top Row. If your labels run down the left edge, you usually need Freeze First Column. If you need both at once, use Freeze Panes from a carefully chosen cell.
Picture a 60-column expense sheet with account names in column A and month headers in row 1. If only row 1 stays visible, you still lose the account names while scrolling sideways. If only column A stays visible, you still lose the month labels while scrolling down.
Likely causes
Most often, the wrong freeze option was used, or the active cell was not in the right place before the command ran. Less commonly, the sheet already has frozen panes, or Split Panes is on and creates a different view from freezing.
Wrong cell position before freezing
Freeze Panes works relative to the selected cell. It freezes the rows above and the columns to the left of the active cell. That rule is the part many users miss.
- Select the cell one row below and one column to the right of what you want fixed.
- Go to View > Freeze Panes > Freeze Panes.
- Scroll to confirm the correct header row and left column remain visible.
Split panes are active instead of Freeze Panes
Split Panes creates multiple scrollable areas. That is not the same as freezing a row or column, and it can make the sheet look half-locked in a confusing way. If the view is divided into independent panes, clear the split first.
- Open the View tab.
- If Split is turned on, click it to turn it off.
- Apply the needed freeze command again.
An old freeze setup is still in place
If you already froze a row or column, Excel will not always switch to a new setup until you remove the old one. Use Unfreeze Panes before trying a different layout.
- Go to View > Freeze Panes > Unfreeze Panes.
- Select the correct cell for the layout you want.
- Run Freeze Top Row, Freeze First Column, or Freeze Panes again.
How do you freeze the first column?
Use View > Freeze Panes > Freeze First Column when you need the leftmost column to stay visible while you scroll horizontally. This is the right fix for row labels, record IDs, or any key field that should stay on screen while the rest of the sheet moves.
Steps for the first column
- Open the worksheet that contains the column you want to hold in place.
- Select View > Freeze Panes > Freeze First Column.
- Scroll left and right to verify that column A remains visible.
Suppose column A contains customer numbers and columns B through M contain monthly totals. Freezing the first column keeps the IDs visible while you inspect later months.
What to expect after you apply it
The leftmost column stays fixed while the rest of the sheet scrolls. If the column still seems to move, check whether a hidden column or a narrow window is making the view look different from the actual freeze state.
How do you freeze columns and rows together?
To freeze both a header row and one or more left columns, you must choose the right active cell first. Use Freeze Panes, not Freeze Top Row or Freeze First Column, when you need both directions locked at once.
Steps for multiple frozen areas
- Click the cell that is one row below and one column to the right of the area you want fixed.
- Go to View > Freeze Panes > Freeze Panes.
- Confirm that the rows above and the columns to the left remain visible as you scroll.
How to freeze more than one column without losing the header row
Selecting C2 freezes columns A and B plus row 1. Selecting B2 freezes only column A plus row 1. The selected cell sets the boundary, so move one cell farther right for each extra frozen column you want. (Microsoft Support)
This is the cell-position rule that prevents most misfires. If you select the wrong cell, Excel freezes the wrong edge of the sheet.
How do you freeze the first row?
Use View > Freeze Panes > Freeze Top Row when the top row contains the labels you need while scrolling downward. This is the simplest path when your issue is a missing header, not a missing left column.
Steps for the header row
- Open the worksheet with the header row.
- Select View > Freeze Panes > Freeze Top Row.
- Scroll down to check that row 1 stays visible.
Freeze Top Row is different from Freeze First Column because it keeps a horizontal header in view rather than a vertical label strip. Use the command that matches the direction you lose sight of.
Column scrolling troubleshooting matrix
This table matches the most common symptom to the likely cause and the exact Excel action to take next.
| Symptom | Likely cause | Exact Excel action |
|---|---|---|
| The column still moves when you scroll horizontally. | The active cell was in the wrong place before freezing. | Choose View > Freeze Panes > Unfreeze Panes, click the correct cell, then run Freeze Panes again. |
| Only part of the sheet stays fixed. | Split Panes is on instead of freezing. | Turn off Split on the View tab, then apply the freeze command again. |
| The first column or header is not the one you wanted. | You used the wrong freeze command. | Use Unfreeze Panes, then choose Freeze Top Row, Freeze First Column, or Freeze Panes to match the layout. |
| The sheet looks frozen, but the visible boundary seems off. | Hidden columns or a tight window layout are making the view look misleading. | Unhide columns if needed, widen the window, and recheck the freeze state on the active worksheet. |
| The freeze command does nothing. | You are on a different worksheet than the one you meant to change. | Click the correct Excel worksheet, then repeat the freeze command on that sheet. |
How do you unfreeze panes?
Use View > Freeze Panes > Unfreeze Panes to clear the current setup before you try again. That is the fastest reset step when the wrong rows or columns are locked. (Wikihow)
When to clear the old setup first
- Open the sheet with the bad freeze state.
- Select View > Freeze Panes > Unfreeze Panes.
- Pick the correct cell or the correct freeze command and apply it again.
If you need a new arrangement, do not stack a second freeze on top of the first one. Clear it first, then set the new view.
Still not working?
If the column still appears to move, check whether the worksheet is protected, whether a hidden column is creating the wrong visual cue, and whether you are on the intended sheet. Those checks catch the cases that look like a freeze failure but are really a layout issue.
Version differences matter. Desktop Excel has the full set of freeze commands. Some web and Mac layouts place the same commands in slightly different locations, and a limited command path can make the feature harder to find.
If the sheet is part of a larger workbook with many tabs, confirm the active sheet before changing anything. Freeze settings generally apply per worksheet rather than to the whole workbook.
Prevention
Before freezing, click the exact cell that sits one row below and one column to the right of the area you want fixed. That single step prevents most wrong-freeze mistakes.
Frequently asked questions
How do I fix a column in Excel when scrolling?
Use View > Freeze Panes > Freeze First Column if the leftmost column is the one you want to keep visible. If you need a different column, clear the current setup with Unfreeze Panes, select the correct cell, and apply Freeze Panes again.
How do I freeze a column in Excel when scrolling down?
Use Freeze First Column when you want a left label column to stay visible while you move through rows. If you also need the top row kept in view, use Freeze Panes with the right active cell instead of the first-column command alone.
How do I lock the first column in Excel while scrolling?
Go to View > Freeze Panes > Freeze First Column. The command keeps the leftmost column visible while you scroll horizontally. If the wrong column appears fixed, remove the freeze and use Freeze Panes from the proper starting cell.
How do I freeze columns and rows in Excel?
Select the cell below and to the right of the block you want fixed, then choose View > Freeze Panes > Freeze Panes. This can keep a header row and one or more left columns visible at the same time.
Why does my Excel column move when I scroll?
Most often, the sheet has no freeze setting, the wrong cell was selected, or the view is using Split Panes instead of freezing. Clear any old setup with Unfreeze Panes, then choose the command that matches the row, column, or both.
How do I make the header stay visible when scrolling in Excel?
Use View > Freeze Panes > Freeze Top Row. That keeps row 1 visible while you scroll downward. If the header is not on the first row, select the cell under the header and use Freeze Panes instead.
How do I unfreeze panes if I set them wrong?
Open View > Freeze Panes > Unfreeze Panes, then apply the correct freeze command again. This is the clean reset when the wrong header, column, or split state is active.
How do I freeze more than one column in Excel?
Use Freeze Panes, not Freeze First Column. Click the cell one column to the right of the last column you want fixed, and one row below any header you want to keep visible, then run View > Freeze Panes > Freeze Panes.