How to Freeze Top Row in Excel: 6 Easy Tips to Stop Losing Headers
Learning how to freeze top row in excel takes less than a minute. You click one menu on the View tab, and row 1 stays put. This guide shows the Windows, Mac and web paths, plus six tips.
Microsoft Excel is the spreadsheet app from Microsoft. Excel first appeared for the Apple Macintosh on September 30, 1985. The Windows version followed on November 19, 1987. Today it sits inside Microsoft 365, and Microsoft reported 80.8 million Microsoft 365 Consumer subscribers in April 2024.
To freeze the top row in Excel, open the View tab, click Freeze Panes, and choose Freeze Top Row. Row 1 then stays visible while you scroll down through the rest of the sheet.
ANSWER BOX 1
To freeze the top row in Excel, open your worksheet and click the View tab. Click Freeze Panes in the Window group, then choose Freeze Top Row. Row 1 stays on screen while you scroll down, and a thin line appears under it.
ANSWER BOX 2
Freeze Top Row locks only row 1, so it works best when labels sit in row 1. If your labels sit in row 2 or row 3, use the general Freeze Panes command instead. Select the row just below your labels, then choose View, Freeze Panes, and Freeze Panes.
KEY TAKEAWAYS
- How to freeze top row in excel starts on the View tab, with Freeze Panes and then Freeze Top Row.
- Freeze Top Row locks only row 1, no matter which cell is active when you click it.
- Press Ctrl plus Home first so row 1 is the top row in view before you freeze it.
- A frozen top row helps with filters, but it does not print on every page.
- Use Print Titles when you want headers on each printed page.
Contents
- What does freeze top row mean in Excel?
- How to freeze top row in Excel on Windows
- How to freeze top row in Excel on Mac
- How to freeze top row in Excel for the web
- 6 easy tips to stop losing headers
- How to freeze the top row in a table with filters on
- How to repeat the top row on every printed page
- Freeze Top Row vs Freeze Panes vs Freeze First Column
- Why freeze top row stops working
- How to unfreeze the top row
- FAQ
What Does Freeze Top Row Mean in Excel?
Freeze Top Row means row 1 stays on screen while the rows below scroll. Your labels, such as Name, Date and Amount, stay visible at the top. You always know which column you are reading, even on row 500.
This setting changes only the view, not your data. It does not move cells, hide rows, or change values. It applies to one sheet at a time. One Excel worksheet can hold up to 1,048,576 rows by 16,384 columns, according to Microsoft Support. A frozen header row is the simplest help of all. Spot an active freeze from the thin line under row 1.
How to Freeze Top Row in Excel on Windows
The Windows path uses the ribbon, and it takes four clicks. No cell selection is needed. Freeze Top Row always locks row 1.
- Open the worksheet you want to change. Freezing is set per sheet, so use the right tab first.
- Press Ctrl plus Home to jump to cell A1. This puts row 1 at the top of your view.
- Click the View tab on the ribbon. The View tab sits near the top of the Excel window.
- Click Freeze Panes in the Window group. A small menu opens with three choices.
- Choose Freeze Top Row from the menu. Row 1 locks in place, and a thin line appears under it.
- Scroll down to test it. Move down through your data and watch row 1 stay at the top.
If your headers sit in row 2, use a different command. Freeze Top Row locks only row 1. Click cell A3, then choose View, Freeze Panes, and Freeze Panes. Our pillar guide on how to freeze panes in excel explains that command in full.
How to Freeze Top Row in Excel on Mac
Excel for Mac follows the same idea, but the buttons look a little different. Microsoft Support lists Freeze Top Row as a direct button on the View tab. No drop down menu is needed.
- Open the worksheet and click cell A1.
- Click the View tab on the ribbon.
- Click Freeze Top Row on the View tab. The button freezes row 1 at once.
- Scroll down to check the result. Row 1 should stay visible.
If the freeze buttons look greyed out on your Mac, check your view mode first. Microsoft Support says to select Normal on the View tab. The commands are not available in Page Layout view.
How to Freeze Top Row in Excel for the Web
Excel for the web uses the same View tab idea, with shorter menu names. The steps work in any modern browser. The workbook must be saved in OneDrive or SharePoint.
- Open the workbook in Excel for the web, on the sheet you want to change.
- Click the View tab at the top of the page.
- Click Freeze Panes to open the menu. It lists Top Row, First Column and Freeze at selection.
- Choose Top Row. Row 1 locks in place, and a thin line appears under it.
Excel for the web saves your freeze with the workbook. It stays on when a colleague opens the same file. If the menu is missing, check your edit access.
6 Easy Tips to Stop Losing Headers
These six tips are the heart of this guide. Work through them in order, then keep them as a checklist.
- Put your headers in row 1 before you freeze anything. Freeze Top Row locks only row 1.
- Press Ctrl plus Home before you click Freeze Top Row. This jumps to cell A1 and puts row 1 at the top of your view.
- Check for the thin line under row 1 after you freeze it. The line proves the freeze is active, and it takes one second to spot.
- Freeze each sheet on its own. The setting does not copy across tabs.
- Keep your header text short and clear. Long labels get cut off when columns are narrow.
- Pair the freeze with Print Titles when you print. A frozen row helps on screen only.
Use all six tips together, and you will stop losing headers for good. Keep this list handy until the steps feel natural to you.
How to Freeze the Top Row in a Table with Filters On
This section covers a case most guides skip. Many sheets use filters, and the arrows sit in the header row. Start by turning your data into a proper Excel table. Click any cell inside your data, then press Ctrl plus T. Tick My table has headers, click OK, and Excel adds filter arrows in row 1.
Now freeze the top row with the same one click path. Click the View tab, click Freeze Panes, and choose Freeze Top Row. The filter arrows stay in row 1 while you scroll. You can filter from any row without scrolling back up.
Watch for one trap in a filtered table. A filter that hides rows stays on after you freeze. Clear it first with Data, then Clear. If your headers span two rows, use Freeze Panes with cell A3 selected.
How to Repeat the Top Row on Every Printed Page
A frozen row helps on screen, but it does nothing on paper. Excel prints row 1 on the first page only. Print Titles fix this gap in less than a minute.
- Open the Page Layout tab on the ribbon.
- Click Print Titles to open the Page Setup box. The box opens on the Sheet tab.
- Click in the Rows to repeat at top field. Then click row 1, or type $1:$1.
- Click OK to save the setting. The setting stays with the workbook for every print.
- Check Print Preview before you print. Press Ctrl plus P, and row 1 should appear on each page.
Print Titles and Freeze Top Row solve two different problems, so use them together. The freeze helps on screen. Print Titles helps on paper.
Freeze Top Row vs Freeze Panes vs Freeze First Column
Excel offers three freeze commands, and each one suits a different need. The table shows what each command locks and what to select first.
| Command | What it locks | Select first | Best for |
|---|---|---|---|
| Freeze Top Row | Row 1 only | Nothing | A simple sheet with headers in row 1 |
| Freeze First Column | Column A only | Nothing | A wide sheet with names in column A |
| Freeze Panes | Rows above and columns left of the cell | The cell below and right of what to keep | Headers plus a name column together |
| Freeze Panes on B2 | Row 1 and column A | Cell B2 | A table with a header row and a name column |
| Freeze Panes on A3 | Rows 1 and 2 | Cell A3 | A sheet with a two row header |
Freeze Top Row is the fastest choice for simple sheets. It needs no cell selection. Use it when your headers sit in row 1 and you only scroll down.
Freeze Panes is the flexible choice. It locks rows above the selected cell and columns to its left. Select B2 to lock row 1 and column A. The pillar guide on how to freeze panes in excel explains this command. Our guide on how to freeze first column in excel covers the column command.
Why Freeze Top Row Stops Working
A freeze can fail in a few common ways. The most common cause is the view mode, because freeze commands are not available in Page Layout view. Switch to Normal view on the View tab. A second cause is a protected sheet, because protection can block view changes. Ask the workbook owner to unprotect the sheet, or check the Review tab.
A third cause is an old freeze already set, because Excel allows only one freeze per sheet. Unfreeze first, then freeze again. A fourth cause is the wrong row frozen while scrolled down. Press Ctrl plus Home, unfreeze, and freeze again. Our guide on freeze panes in excel not working covers these fixes.
How to Unfreeze the Top Row
You may want to remove the freeze when the sheet changes. The removal takes two clicks, and it works on Windows, Mac and the web. No cell selection is needed.
- Click the View tab on the ribbon. The View tab is where you set the freeze, so it is also where you clear it.
- Click Freeze Panes to open the menu. When a freeze is active, click Unfreeze Panes at the top.
- Scroll down to confirm the change. Row 1 should now scroll away with the rest of the sheet.
On Excel for Mac, Unfreeze Panes is a direct button on the View tab. On Excel for the web, open the View tab, click Freeze Panes, and choose Unfreeze Panes. Our guide on how to unfreeze panes in excel covers this removal.
How to Freeze Top Row in Excel FAQ
How do I freeze the top row in Excel?
Open the View tab, click Freeze Panes, and choose Freeze Top Row. Row 1 stays visible while you scroll down.
How do I freeze the top row in Excel on a Mac?
Click the View tab, then click Freeze Top Row on the Mac ribbon. Row 1 locks at once. If the button is greyed out, switch to Normal view.
How do I freeze the top row in Excel for the web?
Open the workbook in Excel for the web, click the View tab, and click Freeze Panes. Choose Top Row, and row 1 stays visible.
What is the keyboard shortcut to freeze the top row in Excel?
Press Alt, then W, then F, then R, one key at a time, on Windows. Alt opens the ribbon shortcuts, and W opens the View tab.
Why is my top row not freezing in Excel?
The most common cause is Page Layout view. Switch to Normal view on the View tab and try again. A protected sheet can also block it.
How do I freeze the top row and the first column at the same time?
Select cell B2, then click View, Freeze Panes, and Freeze Panes. This locks row 1 and column A together.
How do I freeze two rows in Excel?
Click a cell in the row just below the rows you want to keep. Then click View, Freeze Panes, and Freeze Panes. To freeze rows 1 and 2, click cell A3.
Does Freeze Top Row work with filters in Excel?
Yes, it works well with filters, and the arrows stay in row 1 while you scroll. Turn your data into a table first with Ctrl plus T.
How do I unfreeze the top row in Excel?
Click the View tab, click Freeze Panes, and choose Unfreeze Panes. Row 1 then scrolls away like a normal row.
Does freezing the top row print on every page?
No, a frozen row helps on screen only. Use Print Titles on the Page Layout tab to repeat row 1 on each page.
Will freezing the top row change my data in Excel?
No, freezing changes only the view. It does not move, hide or change any values. You can unfreeze the row at any time.
What is the difference between Freeze Top Row and Freeze Panes in Excel?
Freeze Top Row locks only row 1, with no cell selection. Freeze Panes locks the rows above and the columns left of the selected cell.
Final Word
Learning how to freeze top row in excel is a one minute skill. It pays off every time you open a long sheet. Click View, then Freeze Panes, then Freeze Top Row. Your headers stay visible while you scroll.
Start with a clean row 1. Press Ctrl plus Home before you freeze. Check for the thin line under the header. Set Print Titles when you print. When you need more than one row, see the full system. Our pillar guide on how to freeze panes in excel explains it.
Read more about Microsoft Excel on Wikipedia: https://en.wikipedia.org/wiki/Microsoft_Excel


