How to Freeze Just One Row in Excel

To keep the first row visible while you scroll in Excel, open View > Freeze Panes > Freeze Top Row. This pins worksheet row 1 at the top of the window, so column headings or other key information remain in view as you move down the sheet. Before you start, open the worksheet you want to change; no special setup or add-in is needed.

What You’ll Need

Excel for Microsoft 365 on Windows, or a compatible version of Excel with the View tab and Freeze Panes controls. The steps below use the Windows desktop app.
A worksheet with information in its first row. The command freezes row 1 whether or not it contains headings. If your headings are lower down, see the note about freezing a different row in the steps.
A way to scroll down the sheet. You can use the mouse wheel, the vertical scroll bar, or the arrow and page keys to check that the row stays visible.

Step-by-Step

Open the correct worksheet. Select the sheet tab at the bottom of the Excel window that contains the data you want to work with. Freeze Panes settings apply to the active worksheet, so check the tab name before changing the view. If the workbook has several sheets, setting this on one does not automatically set it on the others.
Check what is in row 1. Look at the row numbers along the left edge of the grid. The Freeze Top Row command always pins worksheet row 1, not whichever row happens to be at the top of your current screen. If you have scrolled down already, row 1 may be out of sight, but the command still targets row 1. Scroll back to the top if you want to confirm its contents.
Open the View tab. On the Excel ribbon, select View. Find the Freeze Panes control in the Window area. In some window sizes or ribbon layouts, you may need to expand a group or open a drop-down to see the full command. Make sure you use the Freeze Panes menu, rather than Split, which creates separate scrolling areas.
Choose Freeze Top Row. Open Freeze Panes, then select Freeze Top Row. Excel adds a thin line below row 1 to indicate the boundary between the fixed row and the scrolling worksheet. You do not need to select a cell first for this particular command.
Scroll down to check the result. Use the mouse wheel or drag the vertical scroll bar downward. The rows below row 1 should move, while row 1 stays visible at the top of the worksheet window. If you have a long list, scroll several screens to make sure the row remains in place. The setting changes what stays visible; it does not change the data or move any cells.
Save the workbook if you want to keep the view setting. Use File > Save, or press Ctrl+S on Windows. The freeze setting is part of the workbook view and normally remains when you save and reopen the file. If you share the workbook, remember that other people can change their own view settings as they work.

To freeze one row that is not row 1: Excel freezes a continuous block of rows starting at the top; it cannot pin an isolated middle row while the rows above it scroll freely. If you want rows 1 through 4 to stay visible, select a cell in row 5, such as A5, then choose View > Freeze Panes > Freeze Panes. That freezes all rows above the selected cell, so rows 1 through 4 remain fixed. If you need only row 4 fixed, move that row to the top of the sheet first, or reorganize the layout so the row you need is at the top.

Common Mistakes

Expecting Freeze Top Row to pin the currently visible row. It means worksheet row 1, even if you have scrolled down and row 20 is currently at the top of the screen. For a lower row, use the general Freeze Panes command and understand that it also pins every row above it.
Selecting a cell and then choosing Freeze Top Row. A selection is not needed for this command, and it does not turn the selected row into the frozen row. When you want a block of rows frozen, select a cell immediately below that block and choose the plain Freeze Panes option instead.
Choosing the wrong menu item. Split divides the worksheet into panes that can scroll separately; it is not the same as freezing a row. Use Freeze Top Row for a single fixed first row, or Freeze Panes for a fixed block of rows.
Forgetting that row 1 may be blank or contain a title. Excel freezes the actual first worksheet row, not a heading it detects automatically. If your column labels are in row 3, Freeze Top Row will pin rows 1 only, not the labels in row 3.
Thinking the freeze line is a border in the data. The thin line is a view indicator. It is not a cell border and will not print as a line across the page. If it appears in an unexpected place, unfreeze the panes and apply the setting again.

Tips

Use a clear first row for column headings. If you regularly need to scroll through a list, putting concise headers in row 1 makes Freeze Top Row useful immediately. Consider moving report titles or blank spacer rows above or below the data so they do not take the place of the headers you want visible.
Freeze both a row and a column when it helps. To keep row 1 and column A visible together, select cell B2 and choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and columns to the left of the selected cell. This is different from Freeze Top Row, which targets only the first row.
Know how to remove the setting. Select View > Freeze Panes > Unfreeze Panes to return to ordinary scrolling. The command appears when panes are frozen. Unfreezing does not remove or alter worksheet data.
Use zoom and window size to make the row easier to read. A frozen row remains fixed, but a very narrow window or high zoom can leave too little room for the data below it. Adjust the zoom control or maximize the Excel window if the worksheet feels cramped.
Keep expectations consistent when sharing. A frozen row can help someone else read a long sheet, but it is a viewing aid rather than a protection feature. It does not lock cells, prevent editing, or stop someone from unfreezing the row.

Troubleshooting

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

The wrong rows stay on screen. You may have used the general Freeze Panes command with a cell selected, which freezes everything above and to the left of that cell. Choose Unfreeze Panes first. To keep only the first row fixed, use Freeze Top Row from the menu. To keep a block fixed, select a cell just below the last row to freeze before using the general command.

The headings you want are in row 2 or lower. Freeze Top Row will not find or recognize headings automatically. If the headings are in row 2, select a cell in row 3, such as A3, and choose View > Freeze Panes > Freeze Panes. This keeps both rows 1 and 2 visible. If you only want the lower heading row fixed, Excel cannot freeze it by itself while rows above scroll; move the headings to row 1 or redesign the sheet layout.

The Freeze Panes options are unavailable or behave unexpectedly. Confirm that you are in the worksheet you intend to change, rather than a chart sheet or another workbook window. If the workbook is in a restricted or shared editing state, some commands may be limited; check whether you have permission to edit the file. You can also save the workbook, close and reopen it, and try the command again. Avoid changing the worksheet structure just to fix a display setting unless you have checked how that will affect the workbook.

You are using Excel for Mac or Excel for the web. The menu wording and ribbon layout can vary slightly by platform and release, but look under the View tab for Freeze Panes and choose Freeze Top Row. On a Mac, use the same View menu path where available; the Windows Ctrl+S save shortcut is Command+S on Mac. In Excel for the web, use the View tab and its Freeze Panes control. If you do not see the option, widen the browser window or expand the ribbon.

Frequently Asked Questions

Can I freeze just one row in Excel?
Yes. To freeze just the first worksheet row, choose View > Freeze Panes > Freeze Top Row. It stays visible while the rows below it scroll.

Can I freeze row 2 without freezing row 1?
Not with Excel’s standard Freeze Panes feature. It freezes rows continuously from the top of the sheet, so freezing row 2 also freezes row 1. Move the row you need to the top, or freeze the block that includes it.

Why does Excel freeze the wrong row?
The Freeze Top Row command always targets worksheet row 1, not the row currently at the top of your screen. To freeze several rows, select a cell directly below the last row you want fixed and use the general Freeze Panes command.

Does freezing a row affect printing?
No. Freeze Panes controls what stays visible on screen while you scroll; it does not repeat a row on printed pages. To repeat headings when printing, use the separate print-title settings under Page Layout.

How do I unfreeze a row?
Go to View > Freeze Panes > Unfreeze Panes. This removes the frozen view boundary but leaves the worksheet contents and formatting unchanged.

Will the frozen row stay when I reopen the workbook?
Usually, yes, if you save the workbook after applying the setting. If it does not appear frozen later, check that you opened the same saved workbook and the same worksheet; each sheet can have its own view setting.

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.