How to Move Freeze Panes in Excel to Different Rows

To move frozen rows or columns in Excel, first choose View > Freeze Panes > Unfreeze Panes. Then select the cell below and to the right of the rows and columns you want to keep visible, and choose View > Freeze Panes > Freeze Panes again. Excel does not let you drag an existing freeze line to a new position; you change it by removing the current freeze and applying a new one.

Freeze Panes keeps selected headings or labels on screen while you scroll through the rest of a worksheet. It changes what remains visible, not the position or contents of your data. The instructions below are for Microsoft Excel for Microsoft 365 on Windows; the same selection logic applies in other desktop versions.

What You’ll Need

An Excel workbook with the worksheet you want to adjust open. If the workbook contains multiple sheets, click the correct sheet tab first.
Permission to edit the workbook. A protected sheet or a read-only file may prevent you from changing its view settings.
A clear idea of which rows and columns should stay visible. You will choose a cell based on those boundaries.

Step-by-Step

Open the worksheet and note the current frozen area. Scroll around the sheet if needed to see which headings or labels stay in place. Freeze lines are usually shown as darker borders separating the fixed area from the scrollable area. If you are unsure what is frozen, click View on the ribbon and inspect the Freeze Panes menu; the option to unfreeze is available when a freeze is active.
Remove the existing freeze. On the Windows ribbon, select View > Freeze Panes > Unfreeze Panes. This clears the current frozen rows and columns for the active worksheet. It does not delete, move, or alter any cell data. You must do this before setting a new freeze, because Excel will not reposition an existing freeze line by dragging it.
Identify the new boundary. Excel freezes every row above the active cell and every column to its left. For example, to keep rows 1 and 2 and columns A through C visible, click cell D3. To freeze only the first two rows, select A3. To freeze only columns A through C, select D1. The cell you choose marks the top-left corner of the area that will scroll.
Select the boundary cell. Click once on the appropriate cell in the worksheet. If the target is far down or across the sheet, use the Name Box to the left of the formula bar: type the cell reference, such as D3, and press Enter. Check that the active cell is the intended one before using the command. Selecting a range is unnecessary; Excel uses the active cell.
Apply the new freeze. Choose View > Freeze Panes > Freeze Panes. Use the main Freeze Panes command, not Freeze Top Row or Freeze First Column, when you need a custom combination or more than one row or column. Excel draws a boundary at the selected cell and keeps the rows above and columns to the left fixed as you scroll.
Test the result and save. Scroll down to check that the selected header rows remain visible, then scroll horizontally to check any frozen label columns. If the wrong rows or columns are fixed, repeat the process: unfreeze, select the corrected boundary cell, and apply Freeze Panes again. Save the workbook to retain your changes.

Example: Suppose row 1 contains a report title, row 2 contains field names, and column A contains employee names. If you want both top rows and column A to remain visible, select B3 and choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 are above B3, and column A is to its left, so all three remain fixed. If you instead select B2, only row 1 and column A are frozen.

On Mac, use the View tab and choose Freeze Panes, then select the appropriate freeze or unfreeze command; the exact menu presentation can vary with the Excel version. In Excel for the web, use the View tab and Freeze Panes menu. If the option names or layout differ, the key rule remains the same: clear the old freeze, select the boundary cell, and apply the new freeze.

Common Mistakes

Trying to drag the freeze border. The line is a visual divider, not a handle for changing the frozen area. Use Unfreeze Panes and set the boundary again instead.
Selecting the row or column you want frozen rather than the cell after it. Excel freezes the rows above and columns left of the active cell. To keep rows 1 through 4, select a cell in row 5. To keep columns A through D, select a cell in column E.
Using Freeze Top Row when you need several rows. That preset freezes only the top row. Use the custom Freeze Panes command with a cell selection to freeze multiple rows or a combination of rows and columns.
Forgetting that the active cell controls the result. If you highlight a range, Excel still uses its active cell. Check the selected cell reference in the Name Box before applying the command.
Expecting the setting to change the worksheet layout. Frozen panes do not rearrange cells or repeat headings on printed pages. For print headings, use the separate print titles settings; freezing is a screen-view feature.
Working on the wrong worksheet. Freeze settings apply to a worksheet, not automatically to every sheet in the workbook. Confirm the sheet tab before changing the panes.

Tips

Use a concrete boundary plan. Write down the last row and last column to keep fixed, then move one cell down and one column right to find the selection. For example, last fixed row 5 and last fixed column B means select C6.
Use the Name Box for precise selection. It is especially helpful in long worksheets where scrolling to the exact boundary is awkward. Enter a reference such as C6, press Enter, and verify the active cell before choosing Freeze Panes.
Test vertical and horizontal scrolling separately. A freeze can be correct vertically but wrong horizontally. Check both directions, especially when your sheet has many columns and a row-heading column.
Keep frozen areas modest. Freezing too many rows or columns leaves less room for the data you are reviewing. Freeze only the headings and identifiers you need to refer to while scrolling.
Distinguish freezing from splitting. Split divides the worksheet window into independently scrollable panes. Freeze Panes keeps a chosen top area and/or left area fixed while the rest scrolls. If panes scroll separately or a divider can be moved, check whether Split is enabled and turn it off from the View tab before setting the freeze.
Remember that each sheet can have its own setup. If several worksheets need similar frozen headings, repeat the process on each sheet and verify each one. Do not assume changing the active sheet changed the others.

Troubleshooting

The freeze line does not move after I select a new cell. The old freeze may still be active. Choose View > Freeze Panes > Unfreeze Panes first, then select the new boundary and apply Freeze Panes. If you used Freeze Top Row or Freeze First Column previously, unfreeze that setting before creating a custom layout.

The wrong rows or columns stay on screen. Unfreeze and check your boundary calculation. Excel keeps rows above the selected cell and columns to its left, not the selected row or column itself. For instance, selecting C5 freezes rows 1 through 4 and columns A through B. If you wanted only rows 1 through 4, choose A5 instead.

I cannot find the Freeze Panes command. Make sure the View tab is open and that you are in a worksheet rather than another workbook view or a chart. On a compact ribbon, the command may be inside the Window group or a collapsed menu. In Excel for the web or Mac, menu placement can differ slightly, so look under View for Freeze Panes.

The worksheet scrolls in separate sections. That behavior usually points to Split rather than the freeze arrangement you intended. On the View tab, turn off Split if it is enabled, then clear any freeze and set the desired boundary again. A freeze keeps the selected top and left areas fixed; it does not create several independently scrolling regions.

The command is unavailable or the change will not stick. Check whether the sheet is protected, the file is read-only, or you have opened a view that does not permit edits. If necessary, ask the workbook owner for edit access or save an editable copy if you are allowed to do so. Also confirm that you are changing the intended sheet and save the workbook after confirming the layout.

Frequently Asked Questions

Can I move a freeze pane by dragging it?
No. Excel does not provide a drag-to-move control for freeze boundaries. Unfreeze the current panes, select a new boundary cell, and apply Freeze Panes.

How do I freeze two rows and one column?
To freeze rows 1 and 2 plus column A, select B3 and choose View > Freeze Panes > Freeze Panes. Excel fixes all rows above and columns to the left of the active cell.

How do I freeze columns without freezing rows?
Select a cell in row 1, immediately to the right of the columns you want fixed. For example, select D1 to freeze columns A through C without freezing any rows, then choose Freeze Panes.

Will changing Freeze Panes delete or change my data?
No. Freezing affects how the worksheet appears while you scroll. Unfreezing or setting another boundary does not remove cells, formulas, formatting, or records.

Can I freeze panes in Excel for Mac or Excel for the web?
Yes. The same boundary-cell rule applies. Look for Freeze Panes under the View tab; menu placement and wording can vary by platform and version, but unfreeze first when changing an existing setup.

Why does the frozen area cover more than I expected?
Excel freezes every row above and every column to the left of the active cell. If you clicked too far down or right, more of the sheet will stay fixed. Unfreeze and select the cell immediately below and to the right of the desired frozen area.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.