To keep a row visible while you scroll in Excel for Microsoft 365 on Windows, select the cell in column A immediately below the rows you want to keep, then choose View > Freeze Panes > Freeze Panes. For example, select A5 to keep rows 1 through 4 visible. Excel freezes rows from the top of the sheet; it cannot pin just one arbitrary middle row while allowing the rows above it to scroll away.
What Freeze Panes Does
Freeze Panes divides the worksheet into scrolling and stationary areas. When you scroll down, the frozen rows remain at the top of the window; when you scroll right, frozen columns remain at the left. This is useful when column headings, dates, category labels, or identifying details would otherwise disappear as you move through a large table.
The feature affects how the sheet is viewed, not the underlying data. It does not lock cells against editing, protect a row from deletion, or change what other people see in a printed copy. To restrict changes, use worksheet protection instead. To repeat headings on printed pages, use the print titles settings; freezing panes alone does not set print headings.
The active cell determines the freeze boundary. Excel freezes every complete row above that cell and every complete column to its left. The cell itself is not frozen. This rule is why choosing the right cell matters more than clicking directly on the row you hope to keep visible.
Freeze the Rows Above a Specific Row
Use these steps when you want one or more top rows to remain visible as you scroll downward:
- Open the worksheet and decide which rows should stay on screen. If row 1 contains a title and row 2 contains column names, for instance, you may want both rows frozen.
- Select a cell in column A in the first row that should scroll. To keep rows 1 and 2 visible, select A3. To keep rows 1 through 5 visible, select A6.
- On the ribbon, select View > Freeze Panes > Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row, when freezing a custom number of rows.
- Scroll down to check the result. A boundary line marks the edge of the frozen area. The frozen rows should remain in view while the rows below them move.
If the selection is in a column other than A, Excel may freeze columns too. For example, selecting C5 freezes rows 1 through 4 and columns A and B. That can be useful when a table has identifying fields at the left, but it can be surprising if you intended to freeze rows only. Use a cell in column A when you do not want any columns frozen.
Choose the Right Cell for Your Layout
Think of the selected cell as the top-left corner of the scrolling portion of the worksheet. Everything above it and to its left becomes stationary. This simple rule helps avoid freezing too much or too little.
- Keep only the first row: Select View > Freeze Panes > Freeze Top Row. This command pins worksheet row 1, regardless of which cell is selected.
- Keep the first three rows: Select A4, then choose Freeze Panes.
- Keep the first two rows and the first column: Select B3, then choose Freeze Panes. Rows 1 and 2 and column A remain visible.
- Keep a header row below a title: Freeze all rows from row 1 through that header. Excel cannot freeze the header by itself while letting the title row scroll independently.
Before freezing, check whether you have selected the right worksheet and whether the row numbers match your intended boundary. The freeze line can be subtle, especially on a large monitor or a worksheet with heavy borders. Scrolling a few rows is a quick way to confirm the setup.
Can You Freeze Just One Middle Row?
Not with Freeze Panes alone. The feature always freezes a contiguous block that starts at the top of the worksheet. If row 8 is the row you want to keep visible, freezing at row 9 also freezes rows 1 through 7. Excel does not offer a setting to pin row 8 by itself while rows 1 through 7 continue scrolling normally.
If the row is a table header or a key label, practical options include moving or copying the information to the top of the sheet and freezing the top rows, or using a filterable Excel table so its column headers remain available as you scroll within the table. A table header is not a substitute for pinning any arbitrary data row, but it can solve the common problem of losing column names.
Another possibility is Split, under View > Split. A split creates separate worksheet panes that can be scrolled independently. You can position the desired row in one pane while scrolling another, but this is not the same as freezing a single row: the upper pane still contains a scrolling region, and managing the split can take more effort. For a row that must always stay visible in a straightforward worksheet, placing its information at the top and using Freeze Panes is usually simpler.
Freeze the Top Row or Multiple Rows?
Freeze Top Row is the fastest choice when row 1 is the only row you need to retain. From the ribbon, select View > Freeze Panes > Freeze Top Row. It does not mean “freeze whichever row is currently selected.” If your headings are in row 4, this command still freezes row 1, not row 4.
For a title, notes, and column headings arranged across several opening rows, use the custom Freeze Panes command instead. Select the cell directly below the last row to retain. For example, if rows 1 and 2 are explanatory text and row 3 contains field names, selecting A4 freezes all three rows. Consider whether every frozen row is useful: freezing several tall rows leaves less screen space for the data that needs to scroll.
To keep columns visible as well, select a cell below the rows and to the right of the columns you want retained. For instance, selecting C4 freezes rows 1 through 3 and columns A and B. This can help when names or account identifiers sit at the left of a wide worksheet. It can also make the remaining scrollable area narrow, so freeze only what readers need for context.
Unfreeze or Change the Frozen Area
Excel generally allows one frozen-pane arrangement at a time on a worksheet. To replace it, first select View > Freeze Panes > Unfreeze Panes. Then select the cell for the new boundary and apply Freeze Panes again, or choose Freeze Top Row if that is what you need.
Unfreezing does not delete, move, or alter worksheet values. It only removes the stationary viewing boundary. If the menu offers Unfreeze Panes, a freeze is active; if it offers the regular Freeze Panes options, there may not be a current freeze. A split can also change how the worksheet appears, so check whether Split is enabled if the screen seems divided into independently scrolling sections.
When changing a workbook for someone else, consider whether the current freeze is intentional. A row of headings may be easy to overlook if you unfreeze it, and a freeze applies to the worksheet rather than to a particular user’s personal display setting. Save the workbook after making the intended change.
Excel on Mac and Excel for the Web
In Excel for Microsoft 365 on Mac, the same basic approach applies: select the cell below and to the right of the area to keep visible, then use the Freeze Panes controls on the View tab or View menu, depending on the ribbon layout. Menu wording and placement can vary slightly by release, but the choice is based on the active cell just as it is in Windows Excel.
Excel for the web also provides Freeze Panes options on the View tab. If the workbook is open in a browser and the command is not immediately visible, check the View ribbon and its freeze controls; the available layout can depend on the browser window width. The exact location differs from the desktop ribbon, but the principle remains: select the boundary cell first, then freeze the rows above it and columns to its left.
Some keyboard shortcuts that move around a worksheet differ between Windows and Mac, but there is no need to rely on a shortcut to freeze a row. Using the View menu makes it clear which freeze option is being applied and avoids accidentally selecting the wrong boundary.
Common Problems and Fixes
- The wrong row stayed visible: Check the selected cell before applying the command. Selecting A5 freezes rows 1–4, not row 5. Unfreeze and select the cell one row below the last row you want to keep.
- Extra columns are frozen: The selected cell was likely to the right of column A. Unfreeze, select a cell in column A, and apply Freeze Panes again if you want rows only.
- Only row 1 is frozen: Freeze Top Row was chosen. Unfreeze, select the appropriate boundary cell, and use the general Freeze Panes command for several rows.
- The worksheet seems split: A split pane may be active instead of, or in addition to, the freeze arrangement you expected. Check the View tab’s Split control and remove the split if you do not need independently scrolling panes.
- The freeze line is hard to see: Scroll the sheet and look for the boundary just below the frozen rows or just right of the frozen columns. Zooming in or simplifying nearby cell borders can make the line easier to distinguish.
- The frozen area takes up too much room: Unfreeze and choose a lower boundary. Keeping too many rows stationary reduces the part of the screen available for scrolling through records.
Also distinguish freezing from sorting and filtering. A filter can hide records that do not match a condition, and sorting can rearrange them, but neither action pins a selected record to the top of the window. Freeze Panes controls the view; it does not keep a particular record in a fixed position when the data is sorted.
Frequently Asked Questions
How do I freeze row 2 in Excel? If you mean keeping rows 1 and 2 visible, select A3 and choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell, so row 2 cannot be frozen by itself while row 1 scrolls away.
Can I freeze a row that is not at the top? Not by itself with Freeze Panes. Excel freezes a continuous block starting at row 1. You can move or copy the important row to the top, use a table for column headers, or consider a split pane if independently scrolling sections fit your task.
Why does Excel freeze columns when I only want rows? Freeze Panes uses both the row and column position of the active cell. Selecting a cell in column C freezes columns A and B as well as the rows above it. Select a cell in column A to freeze rows without freezing columns.
How do I keep the first row visible while scrolling? Choose View > Freeze Panes > Freeze Top Row. This pins worksheet row 1. If your headings are on a different row, use the general Freeze Panes command with a cell below the rows you want to retain.
Does freezing a row protect it from changes? No. Freezing only keeps the row visible while you scroll. It does not prevent editing, deletion, sorting, or other changes. Use worksheet protection if you need to limit editing, and configure print titles separately if headings should repeat on printed pages.
Related
- Excel Template for a Budget Plan: Build Your Own
- Excel Meal Planning Template: A Practical Guide
- Excel MAXIFS: Find the Highest Value for Each Date
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Where Is the Data for Your Table?In Excel, the data for a table is the range of worksheet cells containing the records and column…
- How to Create a Mail Merge Template in Microsoft WordCreate a reusable mail merge template in Word by preparing a recipient list, building a document on the…
- How to Add Page Numbers in Word APA Format CorrectlyTo add APA-style page numbers in Microsoft Word, choose Insert > Page Number > Top of Page >…
- Close Research in Excel: Shortcut Key and Full StepsTo close Excel’s Research task pane in Microsoft 365 for Windows, click inside the pane, press Ctrl+Spacebar, then…
- How to Alphabetize in Excel and Google SheetsTo alphabetize a list, select a cell in the column and choose an A-to-Z sort; to keep related…
- How to Check Duplicate Values in ExcelTo check for duplicate values in Excel, select the cells you want to inspect and choose Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.