How to Freeze Different Rows in Excel Without Guesswork

To keep one or more rows visible while you scroll in Excel, select a cell in column A immediately below the rows you want to keep, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above your selection. You can change the number of frozen rows whenever you need, but Excel freezes a continuous block starting at row 1—not separate, nonadjacent rows.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows.
To know which rows should stay visible. Frozen rows must be consecutive rows at the top of the worksheet.
If you want to freeze rows and columns together, identify the first cell that should remain scrollable. Excel uses your selected cell to determine which rows above and columns to the left to freeze.

You do not need to convert your data into a table or change the worksheet. Freezing panes changes how the sheet is displayed; it does not edit, move, or protect the underlying data. People who open the workbook may see the frozen view, but they can change it in their own Excel session.

Step-by-Step

Decide how many top rows to keep visible. For example, if row 1 contains column headings and you want those headings to stay visible as you scroll through a long list, freeze one row. If rows 1 through 3 contain a report title, a date range, and column headings, freeze all three. Excel cannot keep row 1 and row 3 visible while allowing row 2 to scroll away; the frozen rows always form one uninterrupted block from the top.
Check whether panes are already frozen. Open the View tab and look at the Freeze Panes menu. If you see Unfreeze Panes as an available command, a freeze is already active. It is usually best to unfreeze it before choosing a different layout, so your new selection is easy to understand and does not build on the old one.
Unfreeze the current layout if necessary. Choose View > Freeze Panes > Unfreeze Panes. The worksheet returns to normal scrolling. Unfreezing does not delete rows, change their order, or clear any cell contents. If no panes are frozen, this reset is not needed.
Select a cell in column A below the rows you want to freeze. To freeze the first row, select A2. To freeze rows 1 through 3, select A4. To freeze rows 1 through 10, select A11. The selected cell itself is not frozen by this selection; the rows above it are. Choosing column A avoids freezing any columns as well.
Apply Freeze Panes. On the Windows ribbon, choose View > Freeze Panes > Freeze Panes. Do not choose Freeze Top Row if you need two or more rows: that shortcut freezes only row 1. The Freeze Panes command uses the active cell as its boundary and is the option to use for a custom number of rows.
Confirm the result by scrolling down. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down the worksheet. The rows above your selected cell should remain at the top while the rest of the sheet moves. A thin line below the frozen area marks the boundary. Scroll back to the top if you want to check that the intended headings are included.
Adjust the layout if you need a different set of top rows. Choose View > Freeze Panes > Unfreeze Panes, select a new cell in column A below the desired block, and choose Freeze Panes again. For instance, change from one frozen row to four by unfreezing, selecting A5, and applying Freeze Panes. You can repeat this whenever the worksheet’s purpose changes.
Save the workbook if the view should be part of the file. Use Ctrl+S on Windows. Saving is particularly useful when colleagues will open the workbook and you want them to start with the relevant headings in view. Freezing is a display setting, not a lock: users can still edit cells and can unfreeze panes.

To freeze rows and columns at the same time: first decide the boundary for each. Select the cell below the rows and to the right of the columns you want frozen. For example, select C4 to freeze rows 1 through 3 and columns A and B, then choose View > Freeze Panes > Freeze Panes. The rows above and columns left of the selection stay visible. To freeze three rows but no columns, select A4 instead.

To freeze only the top row: choose View > Freeze Panes > Freeze Top Row. This is a quick choice when row 1 alone contains the labels you need. If the heading is actually on row 2 or you need several rows, use the custom Freeze Panes method instead.

On Excel for Mac, select the cell below the rows you want to keep, then use View > Freeze Panes > Freeze Panes. The exact menu presentation can differ slightly by Excel version, but the selection rule is the same. In Excel for the web, use the View tab’s Freeze Panes menu; the available commands and placement may vary with the web interface. If a command is missing or behaves differently, check that you are editing the workbook in Excel rather than a third-party spreadsheet viewer.

Common Mistakes

Selecting the row you want frozen instead of the row below it. Freeze Panes keeps rows above the active cell. To freeze rows 1–4, select a cell on row 5, such as A5—not A4.
Choosing Freeze Top Row for a multirow heading. That command freezes only row 1, even if your worksheet has several title or header rows. Select a cell below the whole block and use Freeze Panes.
Selecting a cell too far to the right by accident. When you select C4, Excel freezes rows above row 4 and columns to the left of column C. If you wanted to freeze rows only, select A4.
Expecting separate rows to stay visible. Excel’s frozen area is contiguous from the top. It cannot freeze row 1 and row 3 while row 2 scrolls. Consider moving the useful labels together at the top, or use a different view or a duplicate summary sheet.
Trying to freeze rows in the middle of the sheet. The command does not pin an arbitrary row, such as row 20, while rows 1–19 scroll. It freezes a top block, plus optionally a left block of columns.
Forgetting there is an existing freeze. A previous pane boundary can make a new selection appear to have no effect or produce a different result than expected. Unfreeze first, then apply the new boundary.

Tips

Keep the frozen area compact. A large frozen block leaves less room to view changing data. Freeze only the title, filters, or column labels that are genuinely useful while scrolling.
Use a cell in column A when freezing rows alone. The column portion of the rule is easy to overlook: everything left of the selected cell is frozen too. Column A is the simplest choice if you do not want frozen columns.
Freeze before you begin reviewing a long list. A visible header row helps you interpret values in far-down records and reduces the chance of confusing similar columns. For a report with a title and a two-row header, freeze the complete block rather than just the labels.
Remember that freezing is not filtering or sorting. Frozen headings remain in view, but the data is not rearranged and rows are not hidden. Use the relevant sort or filter controls separately if you need to narrow or reorder the data.
Check the view at a practical zoom level. If frozen rows take up most of the visible window, reduce the number of frozen rows or adjust the zoom. The point is to keep useful context visible without obscuring the records you are working on.
Use Split only when you need independent scrolling areas. Freeze Panes is generally the simpler choice for keeping headers fixed. Split divides the worksheet into panes that can be scrolled separately; it does not make arbitrary, nonadjacent rows behave like a frozen top block.

Troubleshooting

The wrong number of rows stays visible: unfreeze the panes, count the rows you want to keep, and select the first cell beneath them in column A. For example, select A6 to freeze rows 1 through 5. Apply View > Freeze Panes > Freeze Panes, then scroll down to verify the boundary.

Columns are frozen when you wanted rows only: unfreeze, select a cell in column A, and apply the command again. Selecting a cell in column B or farther right also freezes the columns to its left. This is expected behavior, not a separate row-freezing setting.

The heading still scrolls out of view: check which row contains the heading. If the labels are in row 2, selecting A2 freezes only row 1; select A3 to freeze both rows 1 and 2. Also check that you chose Freeze Panes rather than Freeze Top Row when several rows need to stay visible.

The menu shows Unfreeze Panes instead of Freeze Panes: panes are already frozen. Choose Unfreeze Panes first, select the intended boundary cell, and apply Freeze Panes again. If you cannot see the command, maximize the Excel window or expand the View tab menu; a narrow window can compress ribbon controls.

You cannot see a clear boundary line: scroll down a little and look immediately below the frozen rows. The separator may be subtle, especially at some zoom levels. If you are unsure, unfreeze and set the panes again using a known cell such as A2 or A4.

The worksheet seems locked or will not scroll as expected: check whether the workbook or sheet is protected, whether you are in a cell-editing mode, and whether Split is active. Press Esc to leave cell editing, review the View tab for a split layout, and ask the workbook owner about protection if commands are unavailable. Protection and frozen panes are different settings.

The setting does not appear in another app: confirm the file has been saved and reopened in Excel. Some spreadsheet viewers do not reproduce every Excel view setting exactly. If the workbook is shared, ask the recipient to open it in Excel for Microsoft 365 or Excel for the web and verify the result there.

Frequently Asked Questions

Can I freeze a row other than the first row?
Not by itself. Excel freezes rows from row 1 down to a boundary. To keep row 5 visible, for example, you would also have to freeze rows 1 through 4. If only row 5 matters, consider copying its key information to the top of the sheet.

Can I freeze two or more rows in Excel?
Yes. Select a cell in column A immediately below the last row you want fixed, then choose View > Freeze Panes > Freeze Panes. Selecting A4 freezes rows 1, 2, and 3.

How do I freeze the top two rows?
Select A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 remain visible as you scroll vertically. Use Unfreeze Panes first if another freeze is already active.

Can I freeze rows and columns together?
Yes. Select the cell below and to the right of the area to keep visible. Selecting C4 freezes rows 1–3 and columns A–B. Choose Freeze Panes from the View tab to apply both boundaries at once.

Can I freeze a row in the middle without freezing the rows above it?
No. Freeze Panes does not pin an isolated middle row. Move the important information into a top header block, or create a separate summary area if you need that information available while scrolling.

How do I remove frozen rows?
Choose View > Freeze Panes > Unfreeze Panes. This restores ordinary scrolling without changing the worksheet’s contents. You can then select a different boundary cell and freeze a new set of rows.

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.