How to Freeze Selected Rows in Excel Without Freezing All

To freeze selected rows in Excel, select the cell in column A immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to keep rows 1 through 3 on screen while you scroll. Excel freezes consecutive rows from the top of the worksheet, so this works for a header block, not for isolated rows farther down.

Frozen rows remain visible as you move through the rest of the worksheet. This is useful when column labels, report headings, or brief instructions need to stay in view while you compare data. The key is selecting the correct cell before using Freeze Panes: the rows above it are the ones that stay fixed.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The instructions also apply to current desktop versions of Excel for Mac; menu placement may look slightly different.
A worksheet with the rows you want to keep visible at the top. Decide how many rows to freeze before opening the Freeze Panes command.
Access to the View tab. Excel for the web also has freeze-pane controls, though the ribbon layout can vary slightly.

Step-by-Step

Open the right worksheet. If the workbook has several sheets, click the sheet tab containing the data you plan to scroll. Freeze Panes applies to the active worksheet, so check the tab name before changing the view. It does not freeze rows on every sheet in the workbook at once.
Identify the last row that should remain visible. Count from the top of the sheet, not from the first row containing data. If rows 1 and 2 contain a report title and row 3 contains column headings, decide whether you want all three to stay fixed. Excel keeps a continuous block of rows starting with row 1; it cannot freeze row 3 by itself while rows 1 and 2 scroll away.
Click in column A on the first row below the block. For one frozen row, click A2. For two frozen rows, click A3. For three frozen rows, click A4. Choosing column A is important: the Freeze Panes command fixes rows above the selection and columns to its left. Since there are no worksheet columns to the left of column A, this avoids freezing a column too.
Open the View tab. On Excel for Microsoft 365 for Windows, use the ribbon path View > Freeze Panes. The Freeze Panes control is usually in the Window group. If the Excel window is narrow, the ribbon may compress the group or show commands in a smaller menu, but the control remains on the View tab.
Choose Freeze Panes from the menu. Select the main Freeze Panes command in the drop-down, rather than Freeze Top Row. Freeze Top Row fixes only row 1. The main command uses your selected cell to determine how many rows (and, if applicable, columns) to lock in place.
Check that the rows are frozen. Scroll down with the mouse wheel, scroll bar, or trackpad. The selected top rows should remain visible while the worksheet moves below them. Excel usually shows a thin line beneath the frozen area. If the sheet also moves sideways, check whether you selected a cell to the right of column A; columns to the left of that cell may have been frozen too.
Unfreeze or change the number of rows if needed. Return to View > Freeze Panes and choose Unfreeze Panes. Then select the correct cell in column A and apply Freeze Panes again. Excel does not add another frozen row simply because you select a lower cell after panes are already frozen; unfreeze first to reset the arrangement.

Example: Suppose a worksheet has a title in row 1, column headings in row 2, and hundreds of records beneath them. Click A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 stay visible while you scroll through the records. If you only need the column headings and the title can scroll away, select A2 instead. If you select B3, Excel freezes rows 1 and 2 and column A, which may not be what you intended.

On Excel for Mac, select the corresponding cell and use View > Freeze Panes, then choose the Freeze Panes command. In Excel for the web, select the cell first and look under the View tab for Freeze Panes. The command labels and grouping can differ slightly between versions, but the selection rule is the same: rows above the selected cell are frozen, and columns to its left are frozen. If the web ribbon does not offer the control in your current view, open the workbook in the desktop app.

Common Mistakes

Choosing Freeze Top Row for several rows. This option always freezes just row 1, regardless of the active cell. To keep two or more top rows visible, select the cell in column A immediately below them and use the main Freeze Panes command.
Selecting the row you want frozen instead of the row below it. Excel bases the freeze boundary on the selected cell. To freeze rows 1 through 4, click A5. Clicking A4 freezes only rows 1 through 3.
Selecting a cell outside column A by accident. If you select C4, Excel freezes rows above row 4 and columns to the left of column C. This can make the sheet appear to freeze the wrong things. Use A4 when the goal is rows only.
Expecting to freeze separated or lower rows. Freeze Panes cannot pin, for example, rows 1 and 5 while allowing rows 2 through 4 to scroll. It also cannot keep row 20 fixed at the top while the rows above it disappear. Only a contiguous block beginning at the top can be frozen.
Trying to change an existing freeze without clearing it. A worksheet can have only one freeze-pane arrangement at a time. Use Unfreeze Panes first, then select a new cell and set the desired boundary.
Confusing freezing with hiding. Frozen rows remain visible but can still be edited. Hiding a row removes it from view; it does not keep it displayed while scrolling.

Tips

Freeze only what readers need for context. A single header row is usually easier to work with than a large frozen block. If a title and two heading rows take up much of a laptop screen, consider freezing only the actual column labels.
Use Freeze Top Row when row 1 is the only requirement. It is a quick choice under View > Freeze Panes and avoids selecting a cell first. For multiple rows, use the cell-selection method instead.
Freeze rows and a left-hand identifier column together when useful. For instance, selecting B3 freezes rows 1 and 2 plus column A. That can keep both headings and employee names visible as you scroll down and sideways. If you need rows only, stay in column A.
Test the result in both directions. Scroll down to confirm the top rows stay put, then scroll horizontally if the worksheet is wide. Checking both directions helps reveal an accidental frozen column.
Use clear, compact headings. Frozen rows occupy screen space on every view of the sheet. Short labels and a modest number of frozen rows leave more room for the records below.
Remember freezing affects the view, not the data. It does not change formulas, sort order, filters, print settings, or cell contents. You can still edit cells in frozen rows, and other worksheet features can be used normally.

Troubleshooting

The wrong number of rows stays visible. First choose View > Freeze Panes > Unfreeze Panes. Count the desired rows from row 1, click column A on the next row, and apply the main Freeze Panes command again. For example, to freeze rows 1 through 5, select A6. Verify by scrolling down rather than judging only from the boundary line.

A column is frozen as well. This usually means the selected cell was not in column A. Unfreeze the panes, select a cell in column A below the intended row block, and freeze again. For example, A4 freezes rows 1 through 3 only; B4 freezes those rows and column A.

Freeze Panes is unavailable or appears to do nothing. Make sure you are on the worksheet you want to change and that you are looking under View. If the workbook is open in a browser, try the desktop version if the command is missing in that interface. If the command is visible but the sheet seems unchanged, scroll vertically: frozen rows are easiest to confirm once the worksheet has moved. Also check whether panes are already frozen; unfreeze them before setting a new boundary.

The frozen area takes up too much of the screen. Unfreeze the panes and set a smaller block. For example, replace a four-row freeze with a one-row freeze by selecting A2 and applying Freeze Panes. If the worksheet has multiple title lines, you can leave decorative rows unfrozen and keep only the headings that help identify the data.

The rows are fixed, but they are not the rows you wanted. Excel freezes from the top of the worksheet, not from the current scroll position. If you need to refer to a section lower down, consider using a separate window, a nearby repeated heading, or a different worksheet layout. Freeze Panes itself cannot pin an arbitrary middle section while the rows above it scroll.

Frequently Asked Questions

Can I freeze just rows 1 and 3, but not row 2?
No. Frozen rows must be a continuous block starting with row 1. You can freeze row 1, rows 1 and 2, rows 1 through 3, and so on, but you cannot skip a row within the frozen block.

How do I freeze the first three rows in Excel?
Click A4, then choose View > Freeze Panes > Freeze Panes. Rows 1, 2, and 3 will remain visible as you scroll down. Use the main Freeze Panes command, not Freeze Top Row.

Can I freeze rows without freezing any columns?
Yes. Select a cell in column A below the rows you want frozen. For example, select A3 to freeze the first two rows and no columns. A selection in column B or farther right also freezes the columns to its left.

Can I freeze a row that is not at the top?
Not while allowing the rows above it to scroll away. Excel’s Freeze Panes feature locks rows starting at row 1. You can keep a lower row visible only by changing the worksheet layout or using another viewing approach; it is not an option in the Freeze Panes menu.

How do I remove frozen rows?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen-row and frozen-column boundaries but does not delete or move any worksheet data.

Does freezing rows stop me from editing them?
No. Frozen cells remain editable. Freezing only keeps the specified rows visible while you scroll through other parts of the worksheet.

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.