How to Freeze the Top Row in Excel While Scrolling

How-to basics · Updated November 20, 2026

To keep the first row visible while you scroll in Excel for Microsoft 365 on Windows, open the worksheet, select View > Freeze Panes > Freeze Top Row. Row 1 will stay at the top of the window as you move through the rest of the sheet. You do not need to select the row first; check that your headings are actually in row 1 before you begin.

What You’ll Need

  • An Excel workbook with the worksheet you want to change.
  • A heading or other information in row 1 that you want to keep visible. Freezing does not add headings; it only keeps existing cells in view.

The setting applies to the active worksheet, not every sheet in the workbook. If you want the top row to remain visible on several sheets, repeat the steps on each one.

Step-by-Step

  1. Open the correct worksheet. Select the sheet tab at the bottom of the Excel window. If you have multiple worksheets, confirm that you are on the one whose top row you want to keep visible. Freezing a row on one tab does not change the other tabs.
  2. Check where your headings are. Look at the row numbers along the left side of the grid. The Freeze Top Row command always freezes worksheet row 1, even if your actual headings are in row 3 or another row. If the headings are not in row 1, see the section below on freezing a different row instead.
  3. Open the View tab. On the Excel ribbon, select View. Find the Freeze Panes control, usually in the Window group. If the Excel window is narrow, the ribbon may compress the group or show controls in a smaller layout; maximize the window or expand the ribbon if needed.
  4. Choose Freeze Top Row. Open the Freeze Panes menu and select Freeze Top Row. Excel immediately freezes row 1. There is no confirmation dialog, and the command does not change the contents or formatting of your cells.
  5. Check the result by scrolling. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down several rows. Row 1 should remain visible at the top while the rows below it move. The dividing line below row 1 may appear darker than the other gridlines; that is a visual indicator that the pane is frozen.
  6. Return to the top if needed. Scroll back to the top to check that the visible row is the one you expected. If the first row contains several lines of text or is very tall, it will still occupy the same height while frozen, leaving less room to view the rest of the sheet.
  7. Save the workbook. Save as usual with Ctrl+S on Windows. The freeze setting is saved with the workbook, so it normally remains in place when you close and reopen the file. If the file is read-only or you do not have permission to save it, the setting may not persist.

In Excel for Mac, select View > Freeze Panes > Freeze Top Row; the wording and placement can vary slightly by release. In Excel for the web, use the View tab and its Freeze Panes menu. If you cannot find the command, check that you are using the worksheet view and not a dialog or another application.

Common Mistakes

Freezing the wrong row. Freeze Top Row means row 1 of the worksheet, not the first row currently showing on your screen. For example, if you scrolled down to row 20 before choosing the command, Excel still freezes row 1; it does not pin row 20. If your table headings start in row 4, use the Freeze Panes method for a different row rather than assuming Freeze Top Row will locate them.

Selecting a cell and expecting Freeze Top Row to use it. This particular command freezes row 1 regardless of the active cell. Cell selection matters when you choose the general Freeze Panes command, which freezes rows above and columns to the left of the selected cell. Do not confuse that command with the separate Freeze Top Row option.

Thinking the setting applies to every worksheet. Freeze settings belong to the active sheet. If the workbook has separate tabs for different months or departments, freezing one tab does not freeze all of them. Select each sheet and apply the command where needed.

Expecting a table header to freeze automatically. Excel tables can have their own header behavior as you scroll within a table, but the worksheet command still targets row 1. A table beginning lower down the sheet does not make that lower header become the top worksheet row. Check what remains visible in your own layout, especially if the table starts below title rows or blank rows.

Trying to freeze a row while panes are already frozen. A sheet can have an existing freeze configuration. Choosing another freeze option may not produce the arrangement you intend. Clear the current setting first, then apply the desired one from a clean state.

Tips

Freeze multiple heading rows when the layout needs them. If rows 1 through 3 contain a title and multi-row column headings, click cell A4, then choose View > Freeze Panes > Freeze Panes. The general Freeze Panes command keeps rows above the selected cell visible. In this example, rows 1 through 3 stay in place. It also freezes columns to the left of the selected cell, if there are any, so selecting A4 avoids freezing an extra column.

Freeze a heading row and a key column together. To keep row 1 and column A visible, select cell B2 and choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above B2 and the columns to its left. The selected cell itself is not frozen as a cell; it marks the boundary. This is useful for a wide list where names are in column A and headings are in row 1.

Plan around title rows. If a report has a title in row 1 and column labels in row 2, Freeze Top Row will preserve the title, not just the column labels. To preserve both, select A3 and choose Freeze Panes. If you need only row 2, Excel does not have a direct “freeze row 2 only” command: freezing rows above a selected cell keeps all rows above it, including row 1.

Use clear, concise headings. Freezing is most useful when the visible row identifies the meaning of the data below it. Short labels such as Date, Region, and Total are easier to read while scrolling than a row of blank cells or a long, merged title. Consider keeping a report title separate from the field names.

Remember that freezing changes the view, not the data. It does not lock cells against editing, protect the sheet, hide rows, or alter sorting and filtering. Use worksheet protection for editing restrictions, and use the relevant sorting or filtering controls for managing records.

Troubleshooting

The top row moves when you scroll. Reopen View > Freeze Panes and check whether the menu offers Unfreeze Panes. If it does, a freeze setting is active; if the row still moves, first choose Unfreeze Panes, then choose Freeze Top Row again. Confirm you are scrolling the same worksheet where you applied the setting.

The wrong information stays visible. Check the row numbers at the left. Freeze Top Row can only pin row 1. If your headings are lower down, unfreeze the current setting, select the cell immediately below the rows you want to keep, and choose the general Freeze Panes command. For example, select A5 to keep rows 1 through 4 visible, with no columns frozen.

The Freeze Panes menu is unavailable or greyed out. Make sure a worksheet is active and that Excel is not in cell-edit mode. Press Enter or Esc to finish editing a cell, then try the View tab again. Also check whether the workbook is in a special viewing state or whether the sheet is protected; some workbook or application states can limit commands. If necessary, save your work, close and reopen the workbook, and try again.

You see a dark line but it is in the wrong place. The line marks the boundary of the frozen area. If it appears below several rows, the sheet may have a multi-row freeze rather than just the top row. Choose View > Freeze Panes > Unfreeze Panes, then select Freeze Top Row to reset it.

The setting disappears after reopening the file. Confirm that the workbook was saved after freezing the row and that you have permission to save changes. If you are working in a shared or read-only file, save a copy to a location where you can edit it. In a browser, wait for the save or sync indicator to finish before closing the workbook.

Scrolling seems not to work. If the worksheet has a split window, multiple panes, or a very tall frozen row, scrolling can feel different than expected. Unfreeze panes first and test ordinary vertical scrolling. Then apply Freeze Top Row again. You can also use the vertical scroll bar to confirm that the lower rows are moving behind the pinned row.

Frequently Asked Questions

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

Yes. First choose View > Freeze Panes > Unfreeze Panes if any panes are already frozen. Select cell B2, then choose View > Freeze Panes > Freeze Panes. This keeps row 1 and column A visible while you scroll down or across.

How do I freeze more than one row?

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, 2, and 3 in view. The general command freezes all rows above the selected cell, not just one chosen row.

Can I freeze a row other than row 1?

You can keep rows above a chosen point visible, but Excel does not offer a command to freeze only row 5 while letting rows 1 through 4 scroll away. To keep row 5 at the top, you would need to reorganize the worksheet or use a different layout. Freeze Panes preserves a continuous block of rows starting at row 1.

Does freezing the top row lock it from changes?

No. Freezing affects what remains visible during scrolling, not whether the cells can be edited. You can still change row 1 unless the worksheet is separately protected. Likewise, freezing a row does not prevent other people from editing it in a shared workbook.

Will the frozen row remain when I share the workbook?

The freeze setting is stored with the worksheet in the workbook, so it generally travels with the file. A recipient can change the view, however, and different people may have separate views in some shared-workbook setups. Ask the recipient to use Freeze Top Row if the row is not frozen in their view.

Related

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.