To freeze the header row in Excel for Microsoft 365 on Windows, press Alt, then W, F, and R in sequence. This opens View’s Freeze Panes command and applies Freeze Top Row, so the headings stay visible as you scroll down. If your header is below row 1, select the row immediately beneath it and use Alt, W, F, F instead.
Freezing a header is useful in long lists because you can keep column names in view while reading records farther down the worksheet. It changes how the sheet appears on screen; it does not change the data, sort order, or printed pages. Before you begin, identify which row contains the headings and make sure you are in the worksheet where you want the change.
What You’ll Need
- A workbook open in the Excel desktop app for Microsoft 365 on Windows, or an equivalent Excel version with the Freeze Panes command.
- A clear idea of which row contains your column headings. The built-in Freeze Top Row command applies to row 1; a header farther down requires selecting the row beneath it first.
- For the keyboard method, an English-language Windows Excel ribbon where the key tips shown in this guide apply. Key-tip letters can differ in localized versions or change between releases, so check the letters displayed on screen if the sequence does not match.
Step-by-Step
- Open the correct worksheet. If the workbook has several sheet tabs, select the one whose header you want to keep visible. Freeze settings are applied to the current worksheet, not automatically to every sheet in the workbook. If you need the same behavior on multiple sheets, repeat the process on each one.
- Check where the header is located. If your headings are in row 1, the direct shortcut is simplest. If the headings are in row 3, for example, you will need to freeze the rows above the selection by choosing a cell in row 4. This distinction matters: Excel freezes rows above the selected cell, not the row containing the selected cell itself.
- Use the shortcut for a header in row 1. Click anywhere in the worksheet, then press
Alt,W,F, andRone key at a time. Do not hold all four keys down together. In Excel for Windows, Alt displays ribbon key tips; W opens the View tab, F opens the Freeze Panes menu, and R selects Freeze Top Row. The top row should now remain visible when you scroll down. - Confirm the change by scrolling. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down several rows. Row 1 should stay at the top of the worksheet while the data below it moves. If the sheet is too short to scroll, try temporarily zooming out or use the vertical scroll bar to check the result.
- Freeze a header below row 1 with the keyboard. Click the first cell in the row immediately below the headings. For instance, if the header is in row 3, select A4. Then press
Alt,W,F, andFin sequence to choose Freeze Panes. Excel freezes every row above the selected cell. Selecting A4 freezes rows 1 through 3, including any blank rows above the headings; it does not freeze row 4. - Use the ribbon if you prefer to see the command. Select the View tab, open Freeze Panes, and choose Freeze Top Row for headings in row 1. For a header below row 1, select the cell in the row immediately below the header first, then choose View > Freeze Panes > Freeze Panes. The first Freeze Panes item in that menu applies to the current selection; it is different from the separate Freeze Top Row option.
- Check that the correct rows are frozen. Scroll down and look at the horizontal line separating the frozen area from the scrolling area. If the line is directly below your header, the setup is likely right. If extra rows are fixed, or the header scrolls away, unfreeze and apply the correct command or selection again.
- Unfreeze or change the setting when needed. Choose View > Freeze Panes > Unfreeze Panes to remove the current freeze. Then select the proper cell and apply the desired option. On Windows, the ribbon key-tip sequence for Unfreeze Panes is commonly
Alt,W,F,Fwhen a freeze is active; using the visible menu is a reliable way to verify the command before selecting it.
On a Mac, the Windows Alt key-tip sequence is not the same. Use View > Freeze Panes > Freeze Top Row for a header in row 1. For headings farther down, select the cell below the header and choose View > Freeze Panes > Freeze Panes. Excel for the web also provides Freeze Panes options on the View tab; use the ribbon there if a browser or operating system intercepts a keyboard sequence.
Common Mistakes
Using Freeze Top Row when the headings are lower down. This command always freezes worksheet row 1, even if your actual column names are in row 4. For a header in a different row, select a cell directly beneath it and choose the general Freeze Panes command.
Selecting the header row instead of the row below it. Freeze Panes uses the selected cell as a boundary. Selecting A3 freezes rows above row 3, not row 3 itself. To keep a header in row 3 visible, select A4 before applying Freeze Panes.
Choosing the wrong item from the menu. Freeze Top Row and Freeze Panes are separate commands. Freeze Top Row is a quick preset for row 1. Freeze Panes uses the active cell to determine which rows above it—and, when applicable, columns to its left—remain fixed.
Expecting the freeze to apply throughout the workbook. Each worksheet has its own view settings. A freeze on one tab does not necessarily carry over to another tab. Select each sheet and set its freeze as needed.
Expecting the header to repeat when printing. Freeze Panes keeps rows visible while you work on screen. It does not set print titles. To repeat a heading on printed pages, use Page Layout > Print Titles and set the rows to repeat at the top.
Tips
- Keep the selection as simple as possible. If you only need to keep rows 1 through 3 visible, select A4 before using Freeze Panes. A cell in column A avoids freezing columns to the left, which can happen if you select a cell farther across the sheet.
- Freeze both a header and an identifying column when useful. For example, if row 1 contains headings and column A contains names, select B2 and choose View > Freeze Panes > Freeze Panes. Excel freezes rows above and columns to the left of that cell. Check the result by scrolling both down and to the right.
- Use the on-screen key tips if the shortcut letters differ. Press Alt and read the letters Excel displays over the ribbon commands. Follow the prompts in order rather than guessing. Key tips are menu-navigation shortcuts, so they are entered one after another rather than held as a single chord.
- Unfreeze before changing to a different arrangement. If you have already frozen a row or column and want to freeze a different area, first choose Unfreeze Panes. Then make the new selection and apply Freeze Panes again. This helps avoid interpreting an existing divider as a failed new setting.
- Use descriptive headings and keep them in one row where practical. A single, clearly labeled header row is easier to freeze and scan. If you have a title row plus a separate column-heading row, select the first cell in the row below both rows and use Freeze Panes to keep both visible.
Troubleshooting
The shortcut opens something else or does nothing. Make sure you are using Excel for Windows and pressing the keys in sequence: Alt, W, F, then R for Freeze Top Row. If the letters shown on your ribbon differ, follow those on-screen key tips. You can also apply the setting through View > Freeze Panes > Freeze Top Row, which avoids relying on a particular key-tip sequence.
The header still scrolls off the screen. Check whether the header is actually in row 1. If it is lower, use the custom method: select a cell in the row beneath the headings, then choose View > Freeze Panes > Freeze Panes. If you previously froze a different area, select Unfreeze Panes first, then repeat the steps.
More rows are frozen than you intended. Excel freezes all rows above the active cell when you use Freeze Panes. Choose View > Freeze Panes > Unfreeze Panes, select the first cell below only the rows you want to keep fixed, and apply Freeze Panes again. For example, choose A2 to freeze just row 1.
A column is frozen as well as the header. With the general Freeze Panes command, Excel also freezes columns to the left of your selected cell. Unfreeze, select a cell in column A below the header, and apply the command again if you only want rows fixed. Freeze Top Row is another option when the header is in row 1.
You cannot see whether it worked. Scroll farther down or right; a frozen area stays in place while the rest of the grid moves. Look for a divider line below the frozen rows or to the right of frozen columns. If there is no room to scroll, the sheet may be too short or too narrow to make the effect obvious.
The command is unavailable or the sheet behaves unexpectedly. Check whether you are in a worksheet rather than a chart sheet, and whether workbook protection or the current view is restricting changes. If the menu is available but the display seems stuck, switch to the normal worksheet view and try again. In a shared or browser-based workbook, confirm that you are editing the intended file and sheet.
Frequently Asked Questions
What is the shortcut key to freeze the top row in Excel?
In Excel for Microsoft 365 on Windows, press Alt, W, F, and R one at a time. This selects View > Freeze Panes > Freeze Top Row. If key tips differ in your installation, use the letters Excel displays or choose the command from the View tab.
Can I freeze a header that is not in the first row?
Yes. Select a cell in the row immediately below the header, then choose View > Freeze Panes > Freeze Panes. Excel keeps all rows above the selected cell visible. For example, select A5 to keep rows 1 through 4 fixed.
Does Freeze Top Row freeze the row I have selected?
No. Freeze Top Row targets worksheet row 1 regardless of the selected cell. To freeze a different header row, use the general Freeze Panes command with a cell below the row you want to keep visible.
Is there a Freeze Header shortcut on Excel for Mac?
The Windows Alt-based sequence does not apply in the same way on Mac. Use View > Freeze Panes > Freeze Top Row for row 1, or select a cell below another header and choose Freeze Panes from the View menu.
How do I remove a frozen header?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current freeze from that worksheet. You can then apply a different freeze setting if required.
Will a frozen header appear at the top of every printed page?
No. Freeze Panes affects the on-screen worksheet view, not print layout. To repeat a heading on printed pages, go to Page Layout > Print Titles and set the appropriate rows to repeat at the top.
Related
- How to Find a Word in Excel with Find and Replace Tool
- How to Find a Table in Excel: Search and Navigation
- Amortization Schedule in Excel: Build One Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Heat Map Conditional Formatting: Setup and TipsIn Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional Formatting >…
- Google Sheets Filter Blanks: How to Find Empty CellsYes. In Google Sheets, select your data, choose Data > Create a filter, open the filter icon in…
- Can You Insert an Image Into an Excel Cell?Yes. In Excel for Microsoft 365 on Windows, select a cell and choose Insert > Pictures > Place…
- How to Add a Watermark to Every Page in Microsoft WordTo add a watermark to every page in Word, open the document and choose Design > Watermark, then…
- How to Change PowerPoint Slide Size to Widescreen (16:9)To change a presentation to widescreen in PowerPoint for Microsoft 365 on Windows, open the deck, select Design…
- How to Export Contacts in Outlook 2010To export contacts in Outlook 2010 on Windows, choose File > Open > Import, select Export to a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.