Freeze Just the Top Two Rows in Excel: A Quick Guide

To keep only the top two rows visible while you scroll in Excel for Microsoft 365 on Windows, click cell A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes every row above the selected cell, so selecting A3 freezes rows 1 and 2 without freezing any columns. This is useful when those rows contain headings, dates, or instructions you need to see as you work farther down a sheet.

What You’ll Need

A workbook open in Excel for Microsoft 365. The method also works in many recent desktop versions of Excel.
A worksheet with the two rows you want to keep visible at the top. If the sheet already has frozen panes, you will need to unfreeze them before setting the new position.

Step-by-Step

Open the worksheet you want to change. Select the sheet tab at the bottom of the Excel window. Freeze Panes applies to the active worksheet, not to every sheet in the workbook. If you have several worksheets, repeat these steps on each one where you want the top two rows to remain visible.
Check whether panes are already frozen. Go to the View tab on the ribbon and look in the Window group for Freeze Panes. If the menu offers Unfreeze Panes, a freeze is already active. Choose Unfreeze Panes before continuing. Excel generally allows one freeze-pane arrangement on a worksheet at a time, so an existing freeze may keep a different number of rows or columns visible.
Select cell A3. Click the Name Box, the small box to the left of the formula bar that usually shows the address of the active cell. Type A3 and press Enter, or click cell A3 directly in the grid. The important detail is that the selected cell must be in row 3. Using A3 also ensures there are no columns to its left to freeze.
Open the Freeze Panes menu. Select View > Freeze Panes in the ribbon. In the menu, choose the command named Freeze Panes. Do not choose Freeze Top Row: that separate command freezes only row 1. The general Freeze Panes command uses the active cell as the boundary for what stays visible.
Confirm that the freeze is in place. Excel adds a thin line below row 2 to show the boundary between the frozen and scrolling areas. The line can be subtle, so also check the menu: when a freeze is active, the command to remove it is Unfreeze Panes. Your current selection may move or remain where it was; that does not change which rows are frozen.
Test it by scrolling down. Use the mouse wheel, trackpad, or vertical scroll bar to move several rows down the worksheet. Rows 1 and 2 should stay at the top of the window while row 3 and the rows below it move. Scroll back to the top if you want to confirm the boundary more easily.
Save the workbook if you want to keep the view setting. Use Ctrl+S on Windows or Command+S on Mac. The freeze setting is stored with the worksheet view in the workbook, so saving preserves it for a later session. If the workbook is shared, other people may also see the frozen rows when they open that sheet.

The selection determines the boundary in both directions. Excel freezes all rows above the selected cell and all columns to its left. A3 is therefore the precise choice for rows 1 and 2 only: it sits below those rows and in the first column. Selecting C3 instead would freeze rows 1 and 2 as well as columns A and B.

Common Mistakes

Choosing Freeze Top Row. This command freezes row 1 only, even if you want two heading rows. To freeze two rows, select A3 and use the general Freeze Panes command.
Selecting the wrong row. If A2 is active when you choose Freeze Panes, Excel freezes only row 1. If A4 is active, it freezes rows 1 through 3. The rule is that all rows above the selected cell are frozen, not the selected row itself.
Selecting a cell too far right. Choosing B3 or another cell in row 3 freezes the two top rows and the columns to the left of that cell. For rows alone, use column A—most simply, A3.
Leaving an old freeze in place. If the sheet has a different frozen area, choosing Freeze Panes may not create the layout you expect. Use Unfreeze Panes first, then select A3 and set the freeze again.
Confusing a split with a freeze. A split divides the worksheet into independently scrollable areas; it is not the same as keeping the top rows fixed while the rest of the sheet scrolls. If you see extra divider lines or separate scroll behavior, check View for Split and turn it off if it is not needed.

Tips

Use the Name Box for accuracy. If the sheet is large, hidden rows are present, or A3 is difficult to click, enter A3 in the Name Box to make the intended selection directly. You can use the same technique for any boundary cell.
Keep the heading information together. If row 1 contains a report title and row 2 contains column labels, freezing both preserves the context for the data below. If the title takes up too much screen space, consider whether it needs a full row before freezing it.
Remember the scroll area begins below the frozen rows. After freezing rows 1 and 2, row 3 is the first row that scrolls. If you want a different number of rows fixed, select a cell in the row immediately below the desired frozen area, in column A.
Use a clear boundary as a visual check. The divider between frozen and scrolling rows can be faint, especially on a busy sheet. Look for the line below row 2, or check whether Unfreeze Panes appears in the View menu.
Apply the setting to each relevant sheet. If a workbook has monthly or regional tabs with the same layout, the freeze may need to be set separately on each tab. Click the sheet tab, select A3, and apply Freeze Panes on each one.

Troubleshooting

The wrong number of rows stays visible. Choose View > Freeze Panes > Unfreeze Panes. Then select A3 and choose View > Freeze Panes > Freeze Panes again. Count the rows above the active cell before applying the command: A3 means two rows above it, while A4 means three.
Columns are frozen too. The active cell was probably in a column after A. Unfreeze the panes, select A3, and apply Freeze Panes again. Because column A is the first column, there are no columns to its left to lock.
The rows seem to disappear when scrolling. Check that the worksheet is actually scrolled downward and that the thin boundary appears below row 2. If there is no boundary, set the freeze again. Also make sure you are scrolling the worksheet itself rather than switching to a different sheet tab or window.
You cannot find the command. Make sure the View tab is selected and look for Freeze Panes in the Window group. If the ribbon is simplified or the Excel window is narrow, some commands may be grouped or hidden; maximize the window or expand the ribbon. In Excel for the web, the corresponding control is also on the View tab, though the ribbon layout can differ slightly.
The worksheet is protected or the workbook is in a restricted state. Protection and shared editing settings can limit available actions. If Freeze Panes is unavailable, check whether the sheet is protected or whether you have permission to edit the workbook. Ask the owner for access or have them change the setting if needed.
The result differs on a Mac or in a browser. In Excel for Mac, select A3 and use View > Freeze Panes > Freeze Panes; the exact placement can vary by ribbon layout. In Excel for the web, select A3 and use View > Freeze Panes, then choose the option to freeze panes at the current selection if shown. If the command labels differ, look for the general Freeze Panes option rather than Freeze Top Row.

Frequently Asked Questions

Can I freeze exactly two rows in Excel?
Yes. Select A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible and lets the rows below them scroll.

Why does Freeze Top Row keep only one row visible?
Freeze Top Row is a preset command that locks row 1 only. For two rows, use the general Freeze Panes command with A3 selected.

Can I freeze the top two rows and the first column?
Yes. Select B3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above B3 and the columns to its left, so rows 1 and 2 and column A stay visible.

How do I remove the frozen rows?
Choose View > Freeze Panes > Unfreeze Panes. This removes the freeze from the active worksheet; it does not delete or alter any cell contents.

Do frozen rows print at the top of every page?
No. Freeze Panes changes the on-screen scrolling view, not print layout. To repeat headings on printed pages, use the separate Print Titles setting on the Page Layout tab.

Does freezing rows change the workbook data?
No. It changes how the worksheet is displayed while you scroll. It does not move, hide, or edit the rows, and you can undo the view arrangement at any time with Unfreeze Panes.

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.