How to Freeze the First Row in Excel on Any Device

To keep the first row visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row. The row stays at the top of the worksheet as you move down. This is useful for keeping column headings, labels, or other reference information in view. The instructions below also explain the Mac and Excel for the web paths, and how to undo or troubleshoot the setting.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
Access to the worksheet in Excel for Microsoft 365 on Windows, Excel for Mac, or Excel for the web.
If you want to freeze something other than row 1, decide which rows or columns should stay visible before you start.

You do not need to select the first row before using Freeze Top Row, and you do not need to change a worksheet setting or save a special copy. If the workbook is read-only or the worksheet is protected, you may need permission to change its view or layout. Freezing panes changes what remains visible as you scroll; it does not edit, move, or lock the row’s contents.

Step-by-Step

Open the correct worksheet. Open your workbook and click the sheet tab that contains the row you want to keep in view. Freeze settings apply to the current worksheet, not automatically to every sheet in the workbook. If your workbook has several sheets, you will need to set the option separately on each one where it is needed.
Check that the row you want to keep visible is at the top. Freeze Top Row always freezes worksheet row 1. If your headings are in row 3, for example, this command will still keep row 1 visible, not row 3. You can use Freeze Panes to keep rows 1 through 3 visible instead; the steps for that are described below.
Open the View tab. On Excel for Microsoft 365 for Windows, choose View on the ribbon. Find the Freeze Panes command in the Window group. Depending on the size of the Excel window, the command may appear as a button or within a compact group, but it is on the View tab.
Choose Freeze Top Row. Open the Freeze Panes menu and click Freeze Top Row. Excel immediately keeps row 1 visible when you scroll down the worksheet. You do not have to confirm the choice in a separate dialog box.
Check that it worked. Scroll down using the mouse wheel, the vertical scroll bar, or the keyboard. Row 1 should remain at the top of the worksheet while the rows beneath it move. A thin horizontal line just below the frozen area is another visual clue. Scroll back to the top if you want to see the whole sheet in its usual position.
Use the corresponding command on Mac or the web. In Excel for Mac, open View, choose Freeze Panes, then choose Freeze Top Row. In Excel for the web, open the View tab, choose Freeze Panes, and select Freeze Top Row. The wording and location can vary slightly with the app layout, but use the command that specifically says Freeze Top Row.
Freeze multiple top rows if row 1 is not enough. First remove the existing freeze by going to View > Freeze Panes > Unfreeze Panes. Then click the row number immediately below the last row you want frozen. For example, to keep rows 1, 2, and 3 visible, click row 4. Choose View > Freeze Panes > Freeze Panes (the first item in the menu). Excel freezes the rows above the selected row. If you also need to freeze columns, select the cell below the rows and to the right of the columns you want to keep visible, then choose Freeze Panes.
Save the workbook if you want to keep the change. Save with Ctrl+S on Windows or Command+S on Mac. The freeze is a worksheet view setting, and saving preserves the workbook state for future use. In the web app, changes are generally saved automatically, though you can check the save status before closing the file.

There is no need to use the general Freeze Panes command when you only want row 1. That command uses the selected cell to decide what to freeze and can produce a different result. Freeze Top Row is the most direct choice for a single top row.

Common Mistakes

Expecting Freeze Top Row to freeze the heading row wherever it is. It targets row 1, not the row containing text that looks like a heading. If your labels start lower down, use Freeze Panes with a selection below the rows you want to retain. Alternatively, if the worksheet layout permits, move the headings to row 1 before freezing.
Choosing Freeze Panes with the wrong cell selected. The general command freezes rows above and columns to the left of the active cell. If you select B2, for instance, Excel can freeze row 1 and column A. If you only want the first row, choose Freeze Top Row instead of relying on the selected cell.
Confusing a frozen row with a protected or locked row. Freezing affects the on-screen view while scrolling. It does not prevent editing, deletion, or formatting. To restrict edits, use worksheet protection, which is a separate feature and may require a password or workbook permissions.
Assuming the setting applies to all tabs. Each worksheet has its own freeze-panes setting. After setting it on one tab, switch to another tab and check whether you need to repeat the steps there. Do not assume the whole workbook now has a frozen first row.
Using Freeze Top Row when the row is hidden. A hidden first row cannot appear as a useful heading while scrolling. Unhide row 1 first if it should be visible, then apply the freeze. Also check for a very short row height that might make the frozen area look missing.
Expecting the freeze to affect printed pages. Freeze Panes changes the on-screen scrolling view; it does not repeat the header when printing. To repeat headings on printed pages, use the separate print-title settings on the Page Layout tab.

Tips

Keep the frozen row compact. A very tall first row takes up a large portion of the screen, leaving less room to inspect the data. Adjust row 1’s height if appropriate, or wrap and shorten headings so they remain readable without using excessive vertical space.
Use consistent labels. Frozen headings are most helpful when they describe the columns clearly. If the first row contains a title rather than column names, consider whether the actual column-heading row should be frozen instead by using the multirow method.
Freeze a row and a column together when useful. For a wide list, it can help to keep both the header row and an identifying column, such as a name or ID, visible. Select the cell one row below and one column to the right of the area to preserve, then choose Freeze Panes. For example, to freeze row 1 and column A, select B2 first.
Know the difference between freezing and splitting. Freeze Panes anchors rows or columns so they remain visible in one worksheet view. Split divides the worksheet into separate panes that can scroll independently. If the sheet appears divided by a thick movable bar or has multiple scroll areas, check whether Split was enabled rather than Freeze Panes.
Use the same view on shared workbooks thoughtfully. A frozen top row can make a shared data sheet easier to navigate, but it changes the viewing experience for people opening that worksheet. Explain the layout if colleagues may mistake the fixed row for a separate header area. The underlying cells and data remain in place.
Remove the freeze before setting a different one. Excel generally allows one frozen-pane arrangement per worksheet. Choose Unfreeze Panes before changing from a top-row freeze to a custom combination of rows and columns, then configure the new arrangement from the correct active cell.

Troubleshooting

The first row scrolls away. Return to the View tab and open Freeze Panes. If the menu offers Unfreeze Panes, a freeze is already active, but it may be a different arrangement than the one you intended. Choose Unfreeze Panes, then select Freeze Top Row. Scroll down again to check the result.

The wrong rows or columns stay fixed. Unfreeze the current panes, then decide exactly what should remain visible. For row 1 only, use Freeze Top Row. For several rows, click the row immediately beneath the last row to keep and use the general Freeze Panes command. For a row-and-column combination, select the cell at the intersection just below and to the right of the area you want fixed.

The command is unavailable or does not respond. Confirm that you are in a worksheet rather than a chart sheet, and check whether the workbook or sheet is protected or opened with view-only access. If you are using Excel in a browser, make sure the workbook has finished loading and that you have editing access if the file requires it. Try switching to another worksheet and back, or close and reopen the workbook if the ribbon appears unresponsive.

You cannot see a line or tell whether the row is frozen. Scroll down several rows; the frozen row should stay in place while other rows move. A subtle divider can be hard to notice, especially at high zoom or with a short row. If the first row remains fixed, the freeze is working regardless of whether the divider is obvious. If it does not, unfreeze and apply Freeze Top Row again.

The top row seems blank. Check whether row 1 is hidden, filtered out of view, or simply contains no text. Freeze Top Row cannot substitute a lower row’s headings for row 1. Unhide row 1 if needed, or use the custom Freeze Panes method to anchor the rows above your actual headings.

Frequently Asked Questions

Can I freeze the first row and still scroll through the rest of the sheet?

Yes. That is the purpose of Freeze Top Row: row 1 remains visible while the other rows scroll. You can still select and edit cells as usual, subject to any worksheet protection or access restrictions.

How do I freeze a heading row that is not row 1?

Unfreeze any existing panes. Click the row number immediately beneath the heading row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. This keeps all rows above the selected row in view. If your heading is row 4, select row 5 to freeze rows 1 through 4.

Can I freeze the first row and the first column at the same time?

Yes. First unfreeze any current arrangement, select cell B2, and choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible. For different numbers of rows or columns, select the cell below and to the right of the area to preserve.

Does freezing the first row change the data or formulas?

No. Freezing changes only how the worksheet is displayed as you scroll. It does not alter cell values, formulas, sorting, or the worksheet’s actual row order. You can remove the freeze at any time without changing the data.

Why does the freeze not appear on every worksheet tab?

Freeze panes are set separately for each worksheet. Apply the option on each tab where you want it. Also note that Freeze Top Row affects on-screen scrolling, not printed page headers; set print titles separately if you need headings repeated on paper or in a PDF.

How do I unfreeze the first row?

Choose View > Freeze Panes > Unfreeze Panes. The fixed row will scroll normally afterward. The same command is available in the Mac and web versions through their View and Freeze Panes menus.

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.