To freeze the top row in Excel for Microsoft 365 on Windows, press Alt, then W, F, and R—one key at a time, not all together. The row stays visible as you scroll down. To freeze a different number of rows, select the cell immediately below them and use Alt, W, F, F. Save your workbook first if you are making other changes, and make sure you are working on the worksheet where you want the frozen row.
What You’ll Need
- Excel for Microsoft 365 on a Windows computer for the keyboard sequences below. The exact KeyTips may vary slightly with Excel language or ribbon configuration.
- A workbook with the worksheet you want to change open. Freeze settings apply to the current worksheet, not every sheet in the workbook.
- For the Mac or web version, use the View tab menu described below if the Windows shortcut sequence is unavailable or does not match your screen.
Step-by-Step
- Open the correct worksheet. Click the sheet tab containing the list or table you plan to scroll. Freezing a row changes the view of that sheet; it does not alter the cell values or the workbook’s printed pages. If the workbook has several sheets, repeat the process separately on each one that needs a fixed header.
- Choose whether you need the first row or a different row. If your headings are in row 1, the Freeze Top Row command is the quickest option. It freezes row 1 regardless of which cell is selected. If the headings are lower down, or you need more than one row to stay visible, use Freeze Panes instead and select a cell based on the instructions in step 4.
- Use the shortcut for the top row. Press and release Alt, then press W, F, and R in order. This opens the View ribbon’s Freeze Panes controls and chooses Freeze Top Row in English-language Excel for Microsoft 365 on Windows. Do not hold all four keys down together. You can also use the ribbon: choose View > Freeze Panes > Freeze Top Row.
- Confirm that row 1 is frozen. Scroll down with the mouse wheel, trackpad, or vertical scroll bar. The first row should remain at the top of the worksheet while the rows below it move. Excel usually marks the boundary with a thin line beneath the frozen area. Scroll back to the top if you want to check the row contents or continue editing the headings.
- Freeze two or more rows instead. Click cell A3 to keep rows 1 and 2 visible, then press Alt, W, F, F in sequence. For three rows, select A4; for four, select A5. The Freeze Panes command locks every row above the selected cell. The choice of column matters too: selecting A3 freezes rows 1 and 2 without freezing any columns to their left.
- Freeze a row that is not at the top. Freeze Panes works from the top of the sheet down to your selected cell; it cannot keep only an isolated middle row visible while allowing rows above it to scroll independently. For example, to keep rows 1 through 5 visible, select A6 and choose View > Freeze Panes > Freeze Panes. If you use a cell below and to the right of A1, Excel freezes both the rows above and the columns to the left of that cell.
- Remove or replace an existing freeze. If the wrong rows or columns are locked, choose View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply the desired command again. Excel normally allows one frozen-pane arrangement per worksheet, so unfreeze the current arrangement before setting a different one.
- Use the menu on Mac or Excel for the web. In Excel for Mac, go to View > Freeze Panes and choose Freeze Top Row or Freeze Panes; use the same cell-selection rule for custom rows. A Windows Alt-key sequence is not the Mac shortcut, and the exact available key combinations depend on your Mac and Excel settings. In Excel for the web, open the View tab and choose Freeze Panes, then select the appropriate freeze option. If a menu label or placement differs, use the visible View controls rather than relying on Windows KeyTips.
Common Mistakes
Selecting a row header instead of the right cell: For a custom freeze, click a cell below the rows you want to retain. Selecting the row number is not the same as selecting the boundary cell that tells Excel where to divide the worksheet. To freeze the first two rows only, choose A3, not row 3.
Choosing a cell too far to the right: Excel freezes all columns to the left of your selection as well as all rows above it. Selecting B3 freezes rows 1 and 2 and column A. That can make the sheet look as if it has locked more than the headings. Choose a cell in column A when you only intend to freeze rows.
Expecting Freeze Top Row to work on a lower header: Freeze Top Row always means worksheet row 1. If your actual headings are in row 4, use a cell in row 5, such as A5, and choose Freeze Panes. It will keep rows 1 through 4 visible, not just row 4.
Pressing the shortcut keys simultaneously: The Alt sequence uses ribbon KeyTips, which appear as you press the keys. Press each key in turn. If the letters do not match your Excel language, check the on-screen KeyTips or use the View ribbon menu.
Confusing a frozen view with a changed worksheet: Freeze Panes does not move, duplicate, or protect data, and it does not make a header repeat on printed pages. It only controls what remains visible in the current worksheet window while you scroll.
Tips
- Use Freeze Top Row for ordinary column headings. For a list whose labels are in row 1, it avoids having to calculate a selection cell. This is especially useful when reviewing long records, inventory lists, or survey responses because you can keep the field names in view while reading lower rows.
- Freeze both headings and an identifying column when helpful. If you want the first two rows and column A to stay visible, select B3 and choose Freeze Panes. Excel freezes all rows above B3 and all columns to its left. This is practical when column A contains names or IDs and the remaining columns extend far to the right. Check that you really want column A fixed before applying it.
- Inspect the boundary after freezing. Scroll vertically and horizontally a little. A horizontal line indicates the row boundary; a vertical line indicates a frozen column boundary. This quick check catches an accidental selection such as B3, which can freeze a column as well as rows.
- Remember that freeze settings are sheet-specific. If a workbook has separate monthly tabs, freezing the header on January does not freeze it on February. Apply the view setting to each worksheet where it is useful. You do not need to repeat the command every time you open the same saved workbook, though a different worksheet can have a different view.
- Keep the frozen area modest. Freezing many rows can leave little room to see the scrolling portion of a worksheet, especially on a laptop display. Freeze only the headings or context you need. If a large block appears stuck, unfreeze it and set the boundary again with a cell closer to the top-left corner.
- Use the ribbon if the shortcut is intercepted. Some keyboard layouts, remote desktop tools, or customized ribbon settings can affect KeyTips. The menu path View > Freeze Panes performs the same action and makes the available options visible before you choose one.
Troubleshooting
The shortcut does nothing: Confirm that Excel is the active window and that you are pressing the keys in sequence. In English-language Windows Excel, start with Alt, then W, F, and R for Freeze Top Row. If a different KeyTip appears, follow the letters displayed on screen or open View and use the Freeze Panes menu. The sequence can differ in localized editions or after interface changes.
The wrong row stays fixed: First use View > Freeze Panes > Unfreeze Panes. For row 1, choose Freeze Top Row. For the first two rows, select A3 and choose Freeze Panes. For the first three rows, select A4. Remember that the selected cell itself is not frozen by this rule; rows above it and columns to its left are.
A column is frozen unexpectedly: Unfreeze the panes, then make sure your selection is in column A before using Freeze Panes. A selection in C4, for example, freezes rows 1 through 3 and columns A and B. For a row-only arrangement, select a cell in column A below the last row you want fixed.
Nothing seems to move when you scroll: Check that the worksheet contains enough rows or columns to scroll, and use the worksheet’s scroll bars rather than moving only the active cell. Try scrolling a longer distance. If the boundary is in an unexpected place, unfreeze and reapply the setting. Also check whether the window is split; a split view is separate from frozen panes and can make scrolling behave differently. Use View > Split to turn off an active split if needed.
The freeze option is unavailable or behaves unexpectedly: If the workbook is in a restricted editing state, try enabling editing where appropriate, then check the View tab again. In a browser, confirm you are using Excel for the web and not a preview-only view. If the worksheet is shared or opened by multiple people, coordinate before changing its view, since the experience can depend on the workbook and sharing setup. When in doubt, try the visible View menu and verify the result by scrolling.
Frequently Asked Questions
What is the shortcut to freeze the top row in Excel?
In English-language Excel for Microsoft 365 on Windows, press Alt, W, F, R in order. The equivalent ribbon route is View > Freeze Panes > Freeze Top Row.
What shortcut freezes the first two rows?
Select A3, then press Alt, W, F, F in sequence. The Freeze Panes command keeps rows above the selected cell visible, so A3 freezes rows 1 and 2.
Can I freeze only row 2 and let row 1 scroll?
No. Freeze Panes locks a continuous block starting at the top of the worksheet. It cannot keep row 2 fixed by itself while row 1 scrolls. You can freeze rows 1 and 2 together by selecting A3.
Does freezing a row affect other worksheets or printing?
No. The freeze setting controls scrolling on the current worksheet and does not automatically apply to other sheets. It also does not repeat headings on printed pages; set print titles separately if you need that result.
How do I unfreeze a row in Excel?
Choose View > Freeze Panes > Unfreeze Panes. Then scroll to confirm the rows move normally, or select a new boundary cell and apply a different freeze arrangement.
Is there the same keyboard shortcut on Mac?
The Windows Alt sequence is not the Mac equivalent. In Excel for Mac, use View > Freeze Panes and choose the required option. Keyboard shortcuts can vary by Mac setup, so the menu is the most dependable route.
Related
- How to Flip an Excel Sheet Upside Down by Reversing Rows
- How to Flip a List in Excel Upside Down: 3 Simple Ways
- How to Find Rank in Excel with RANK.EQ
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Custom Print Area: Set, Adjust, and TroubleshootTo set a custom print area in Excel for Microsoft 365 on Windows, select the cells you want,…
- Excel Text on Multiple Lines in One Cell: How to Do ItTo put text on multiple lines in one Excel cell, select the cell, start editing it, and press…
- How to Get Out of Replace Mode in Excel and Restore TypingTo get out of Overtype (replace) mode in Excel for Microsoft 365 on Windows, click inside the cell…
- How to Archive Outlook Emails to OneDriveTo archive Outlook emails in OneDrive, export the folders you want from classic Outlook for Windows to an…
- Excel Shortcut to Expand All Columns to Fit ContentsIn Excel for Microsoft 365 on Windows, select the whole worksheet and press Alt, H, O, I in…
- Excel Time Difference in Seconds: How to CalculateWith a start time in A2 and an end time in B2, enter =(B2-A2)*86400 to calculate the difference…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.