To freeze rows in Excel with keys on Windows, press Alt, W, F, R to keep the top row visible while scrolling. To freeze several top rows, select the cell directly below them—such as A4 to freeze rows 1 through 3—then press Alt, W, F, F. These are sequential key presses, not keys to hold down together. Freezing keeps headings or other reference rows on screen; it does not change or protect the worksheet data.
What You’ll Need
- Excel for Microsoft 365 on Windows for the keyboard sequences in this guide. The ribbon menus are also available if the key tips differ in your setup.
- A worksheet with the rows you want to keep visible at the top. Save the workbook first if you want a restore point; freezing panes does not edit cell values.
- For several rows, know how many to keep visible. You will select the first cell below those rows before using Freeze Panes.
Step-by-Step
- Open the worksheet and identify the rows. Click the sheet tab containing the data. Decide whether you need only the first row, which often contains column headings, or several rows, such as a title row plus headings. Excel freezes rows starting at the top of the sheet; it cannot freeze an isolated row in the middle while leaving the rows above it scrolling.
- Use the top-row shortcut if you only need row 1. Press and release Alt, then W, then F, then R. The letters are key-tip commands for the View tab, Freeze Panes menu, and Freeze Top Row option. Row 1 should remain in view when you scroll down. If the sequence does not work in your Excel setup, use the ribbon path: View > Freeze Panes > Freeze Top Row.
- Select the right cell to freeze multiple rows. Click the cell in column A immediately below the last row you want to keep visible. For example, select A4 to freeze rows 1, 2, and 3. The selected cell matters: Freeze Panes freezes every row above it, not the row containing the selected cell. Selecting A3 would freeze only rows 1 and 2.
- Run the Freeze Panes keyboard sequence. With the target cell selected, press and release Alt, W, F, F. Excel freezes the rows above the selected cell. The last F chooses Freeze Panes itself, rather than one of the preset options. You can also click View > Freeze Panes > Freeze Panes on the ribbon.
- Freeze rows and columns together if needed. Select the cell that is both below the rows and to the right of the columns you want fixed. For example, select C4 to freeze rows 1–3 and columns A–B, then use Alt, W, F, F or the ribbon command. Selecting A4 freezes the rows but no columns; selecting C1 freezes columns A–B but no rows.
- Check the result by scrolling. Use the mouse wheel, scroll bar, or keyboard to move down the sheet. The frozen rows should stay at the top while the rest of the sheet moves. If you froze columns too, scroll horizontally to check that they remain visible on the left. Look for a thin line marking the edge of the frozen area.
- Change or remove the frozen area when necessary. To replace the current arrangement, first choose View > Freeze Panes > Unfreeze Panes. Then select a new cell and apply Freeze Panes again, or choose Freeze Top Row for the single top row. The keyboard sequence for the Freeze Panes menu’s Unfreeze Panes command may vary by Excel build, so the ribbon path is the dependable option.
- Use the menu on Mac or Excel for the web. On Excel for Mac, use View > Freeze Panes and choose the appropriate command; the Windows Alt key-tip sequence is not the equivalent Mac shortcut. Excel for the web also provides Freeze Panes commands on the View tab. If browser shortcuts interfere, use the menus rather than trying to reproduce the Windows sequence.
Common Mistakes
Selecting the row you want frozen instead of the row below it. For a custom freeze, Excel uses the active cell as a boundary. Select A4 to hold rows 1–3, not A3. This is the most common reason the frozen area contains one fewer row than expected.
Choosing Freeze Top Row when several rows are needed. That preset freezes row 1 only, even if you have selected a different cell. For multiple rows, select the cell below the full set and choose the general Freeze Panes command.
Forgetting that columns can freeze at the same time. Excel freezes rows above and columns left of the active cell. If you select C4, columns A and B will also stay fixed. If that is not intended, select a cell in column A, such as A4.
Expecting a middle row to stay visible by itself. Freeze Panes anchors rows from the top of the worksheet, not a chosen row elsewhere in the data. To keep a heading from a lower section visible, consider reorganizing the sheet or using a separate view; freezing cannot pin that row independently.
Using Split instead of Freeze Panes. Split divides the worksheet into panes that can scroll separately. It is a different feature and may make the sheet appear to have extra scroll areas. Use Freeze Panes when the goal is to keep headings fixed as you scroll through one continuous list.
Tips
- Count rows before selecting. If you want four top rows fixed, choose A5. A quick count prevents an off-by-one mistake, especially when the sheet has a title above its column labels.
- Freeze only what readers need. Several frozen rows reduce the space available for scrolling data, particularly on a small screen. Keep the frozen block compact and include only useful labels or context.
- Use the visible key tips as a guide. After pressing Alt in desktop Excel for Windows, Excel displays letters for ribbon commands. Follow those displayed letters if your ribbon layout or Excel update does not match the sequence in this guide.
- Remember the setting belongs to the sheet view. A frozen arrangement applies to the active worksheet, not every worksheet in the workbook. Check other sheet tabs separately if readers need the same headings fixed there.
- Save after arranging the view. Save the workbook after setting the panes so the view is available when the file is reopened. Freezing changes how the sheet is displayed; it does not lock cells, stop edits, or alter sorting and filtering.
- Use a shortcut for the preset, menus for clarity. Alt, W, F, R is quick for the top row. For a custom arrangement, selecting the boundary cell and then using the clearly labeled Freeze Panes command makes it easier to verify what Excel will freeze.
Troubleshooting
The key sequence does nothing. Make sure you are using desktop Excel for Windows and pressing the keys in order, releasing each before the next. Click into the worksheet first, then try again. If another app, keyboard layout, or Excel build handles the key tips differently, use View > Freeze Panes and choose the command from the menu. In Excel for the web, a browser may capture some shortcuts, so the View menu is the safer route.
The wrong number of rows stays visible. Choose View > Freeze Panes > Unfreeze Panes, then select the cell one row below the intended frozen block. For three rows, select A4. Apply View > Freeze Panes > Freeze Panes and scroll again to confirm.
The wrong columns are frozen too. Unfreeze the current panes, select a cell in column A below the rows you want fixed, and apply Freeze Panes again. Any columns to the left of the selected cell are included automatically.
Freeze Panes is unavailable or the menu shows Unfreeze Panes. If the current sheet already has frozen panes, unfreeze them before setting a different boundary. If commands are disabled, check whether the workbook or worksheet is protected and whether you are in a mode that prevents changes. Return to the worksheet grid, unprotect it if you have permission, and try again.
The frozen line is hard to see or the result looks unchanged. Scroll down or sideways; a line near the top may be subtle when you are at the starting position. Confirm that you applied the command on the intended sheet and that the frozen rows are at the top. Freeze Panes does not keep a selected row in view when it is below the frozen boundary.
Frequently Asked Questions
What is the keyboard shortcut to freeze the top row in Excel?
In desktop Excel for Windows, press and release Alt, W, F, R in sequence. Or use View > Freeze Panes > Freeze Top Row. The menu method is useful if your key tips differ.
How do I freeze the first two or three rows using keys?
Select A3 to freeze the first two rows, or A4 to freeze the first three. Then press and release Alt, W, F, F. This applies the general Freeze Panes command to the active cell’s boundary.
Can I freeze rows that are not at the top?
No. Freeze Panes keeps rows from the top of the worksheet visible. It cannot pin, for example, row 10 by itself while rows 1–9 scroll away. You can freeze rows 1–9, but that may leave little room to view data.
Does freezing rows protect them from changes?
No. Freezing is a display setting that keeps rows visible during scrolling. It does not prevent typing, deleting, or formatting. Use worksheet protection separately if you need to restrict editing, and remember that protection settings are a different feature.
How do I freeze rows and columns at the same time?
Select the cell below the rows and to the right of the columns you want fixed. For rows 1–3 and columns A–B, select C4, then choose View > Freeze Panes > Freeze Panes or use the Windows key-tip sequence. Excel freezes everything above and to the left of that cell.
Will freezing rows affect printing?
Freezing changes the on-screen scrolling view, not which rows repeat on printed pages. To repeat headings when printing, use Page Layout > Print Titles and set the rows to repeat at the top of each page.
Related
- How to Find Duplicate Values in an Excel Column Fast
- Find Duplicate Words in Excel: A Step-by-Step Guide
- Find Duplicate Numbers in Excel: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Use SUMIF in Google Sheets for Quick TotalsTo total values that match one condition in Google Sheets, enter =SUMIF(A2:A7,"Travel",B2:B7) in an empty cell, assuming categories…
- Clear Excel Cell Formatting: What Changes and What StaysTo clear formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Clear…
- Hanging Indent in Word: Use Ctrl+TTo create a hanging indent in Microsoft Word for Windows, click in the paragraph or select the paragraphs…
- Excel Cell Locked When Scrolling? Causes and FixesIf a cell or row stays visible while you scroll in Excel, the usual cause is Freeze Panes,…
- How to Remove Subtotals From Google Sheets VLOOKUPGoogle Sheets VLOOKUP does not create subtotals, so remove them from its lookup results by excluding subtotal rows…
- Calculate the Number of Months in ExcelTo count complete months between two dates in Excel, enter the earlier date in A2 and the later…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.