To make an Excel row stay visible while you scroll, freeze it: in Excel for Microsoft 365 on Windows, go to View > Freeze Panes > Freeze Top Row to keep row 1 on screen. To keep a different set of top rows visible, select the cell immediately below them, then choose View > Freeze Panes > Freeze Panes.
Keep the top row visible
Freezing the top row is useful when a worksheet has column labels such as Date, Customer, and Amount. Without a frozen row, those labels scroll out of view as you move down a long list, making the values harder to interpret. The Freeze Top Row command keeps the worksheet’s first row at the top of the window while the rest of the sheet scrolls.
In Excel for Microsoft 365 on Windows:
- Open the worksheet you want to work with.
- Select View on the ribbon.
- Choose Freeze Panes, then select Freeze Top Row.
Scroll down to confirm the row stays visible. The command applies to the worksheet you are viewing, not every sheet in the workbook; repeat it on other worksheets as needed. It changes how the sheet is displayed, not the values or formatting in the cells.
Freeze a specific number of rows
Freeze Panes can keep more than one row visible, but the selected cell determines exactly where the boundary falls. Excel freezes the rows above the selected cell. To keep the first three rows visible, select a cell in row 4—typically A4—and choose View > Freeze Panes > Freeze Panes. Rows 1 through 3 remain in place while the rows below them scroll.
The same rule works for any number of top rows. To freeze the first two, select a cell in row 3. To freeze the first five, select a cell in row 6. You do not have to select the entire row; selecting a cell is the clearest way to define the freeze boundary.
There is an important limitation: Excel freezes a continuous block starting at the top of the worksheet. Selecting A6 freezes rows 1 through 5; it cannot keep row 5 visible by itself while rows 1 through 4 scroll away. If a heading appears halfway down a sheet, consider repeating that heading in a new section, restructuring the data, or using another worksheet view rather than expecting Freeze Panes to pin that isolated row.
Keep a row and columns visible together
You can freeze rows and columns at the same time. Excel uses the selected cell as the corner of the scrolling area: rows above it stay visible, and columns to its left stay visible. For example, select B2 and choose View > Freeze Panes > Freeze Panes to keep row 1 and column A on screen. The rest of the worksheet can scroll both down and to the right.
For a larger frozen area, select the cell just below and just to the right of the rows and columns you want to keep. To freeze the first two rows and first three columns, select D3 before choosing Freeze Panes. Excel then holds rows 1 and 2 and columns A through C in place.
The separate presets Freeze Top Row and Freeze First Column are convenient when you need only one of those edges. If you need both, use the cell-selection method and the general Freeze Panes command. Choosing a different freeze command replaces the current frozen arrangement; it does not add a second independent frozen area.
What freezing changes—and what it does not
Freeze Panes controls the worksheet’s on-screen scrolling area. A frozen row remains in view as you scroll through the sheet, while unfrozen cells move normally. It does not lock the row against editing, protect formulas, prevent someone from deleting it, or make it repeat on printed pages. Those are separate tasks: protecting cells or a worksheet controls editing, while print titles control what appears on printed pages.
Freezing also does not move or duplicate data. The frozen rows remain at the top of the worksheet, and the other rows continue in their original order. If a row seems to have vanished, it may simply be outside the visible scrolling area; scroll back to the top or unfreeze the panes to inspect the sheet normally.
In a worksheet with a large used area, frozen headers can make navigation more reliable because you can compare each record with its labels without memorizing column meanings. Freezing is especially helpful for wide lists, where keeping an identifying column—such as an account name or product code—visible can prevent mistakes when reading values farther to the right.
Change or remove frozen panes
To remove the current freeze, select View > Freeze Panes > Unfreeze Panes. The worksheet returns to ordinary scrolling. Then select a new boundary cell and apply Freeze Panes again if you want a different arrangement. For example, if you froze three rows but meant to freeze only row 1, unfreeze first, then use Freeze Top Row.
If the Freeze Panes menu offers Unfreeze Panes, a freeze is already active. Choosing another preset or boundary without clearing the existing arrangement can replace it, so unfreezing first is a useful way to reset the setup and avoid confusion.
Frozen areas are most noticeable when you scroll far enough for the unfrozen cells to move. A thin boundary line marks the edge of the fixed area. If the boundary is not where you expect, unfreeze and repeat the selection carefully: for custom rows, choose a cell directly below the last row to keep; for custom columns, choose a cell directly to the right of the last column to keep.
Common problems and useful distinctions
- The wrong row stays visible: Freeze Top Row always means worksheet row 1, not the row currently selected. To freeze a different number of top rows, select the cell below them and use the general Freeze Panes command.
- More rows are frozen than intended: Excel freezes every row above the selected cell. If you selected A10, rows 1 through 9 are included. Unfreeze, select the correct boundary cell, and apply the command again.
- The header does not stay in view: Check that the freeze was applied on the worksheet you are scrolling, and make sure you are moving within that worksheet rather than viewing a different sheet.
- You want separate areas to scroll independently: Use View > Split instead. A split divides the window into panes that can be scrolled separately; it is not the same as keeping a top row fixed while the rest of the sheet moves.
- You want headings on every printed page: Freeze Panes is an on-screen feature. Set print titles from the Page Layout tab instead; this controls repeated rows or columns in printouts, subject to the available print settings.
Freezing is also different from hiding rows. A hidden row is removed from the visible grid until you unhide it; a frozen row remains visible and stationary while other parts of the grid scroll. Similarly, a worksheet’s scroll position can be changed without affecting its freeze boundary.
Excel on Mac and in a browser
In Excel for Mac, the same basic method applies: use the View tab and choose Freeze Panes, then select the relevant option. For a custom boundary, select the cell below and to the right of the area to keep, then use Freeze Panes. The ribbon layout can differ slightly from Windows, but the selection rule is the same.
Excel for the web also provides Freeze Panes from the View tab. The available choices and layout can vary with the browser window and the current version of the web app, but the core approach remains: choose a preset for the top row or first column, or select a boundary cell before freezing panes. If the command is not visible, check the View tab’s ribbon and any collapsed or overflowed controls.
When a workbook is shared, freezing panes changes the view rather than the underlying cell data. Still, coordinate with collaborators if the visible layout matters to their work, since people may use different worksheet views or scrolling positions.
Frequently Asked Questions
How do I make the first row stay visible in Excel?
Choose View > Freeze Panes > Freeze Top Row. Then scroll down; row 1 remains at the top of the worksheet window.
How do I freeze the second or third row instead?
Excel freezes rows from the top as a continuous block. To keep the first three rows, select A4 and choose View > Freeze Panes > Freeze Panes. You cannot freeze row 3 alone while rows 1 and 2 scroll away.
Can I keep the top row and first column visible at once?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The first row and column A stay visible together.
Why is Freeze Top Row not keeping my selected row visible?
That preset freezes worksheet row 1 regardless of which cell is selected. To keep multiple top rows, select a cell just below them and use the general Freeze Panes command.
How do I stop a row from staying fixed while I scroll?
Choose View > Freeze Panes > Unfreeze Panes. You can then scroll normally or set a different freeze boundary.
Related
- Excel Data Validation Rules: How They Work and When to Use Them
- Excel Data Validation Restrictions and Their Limits
- Data Validation Process: Steps, Checks, and Best Practices
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel MAC Address Format: Display, Clean, and ValidateIn Excel, store a MAC address as text, then display it in a consistent form such as 00:1A:2B:3C:4D:5E.…
- How to Merge Cells in Google SheetsTo merge cells in Google Sheets, select the adjacent cells you want to combine, then choose Format >…
- Excel CSV vs ODS: Which Export Format to ChooseChoose CSV when you need a simple, widely compatible table of data; choose ODS when you want to…
- Track Changes in Word Anonymously Without Exposing NamesTo track changes in Word without showing your personal name, first set Word’s author information to a neutral…
- Excel Remove Duplicates: Steps and Safer OptionsTo remove duplicates in Excel for Microsoft 365 on Windows, select your data, then choose Data > Remove…
- Remove Duplicates in Excel: Keyboard ShortcutIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt, then A,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.