To keep several rows visible while you scroll in Excel for Microsoft 365 on Windows, click the cell in the first column directly below the rows you want to keep, then choose View > Freeze Panes > Freeze Panes. For example, to keep rows 1 through 3 visible, select A4 first. The rows above the selected cell stay on screen as you move down the worksheet.
This is useful when a long sheet has multiple title, instruction, or header rows that you need to refer to while reading records farther down. Before starting, decide exactly which rows should remain visible and check that they are at the top of the sheet: Freeze Panes locks a continuous block starting at row 1, not a selection of separate rows.
What You’ll Need
- A workbook open in Excel. These steps use Excel for Microsoft 365 on Windows; Excel 2021 has the same core Freeze Panes command.
- The worksheet you want to work with, and a clear idea of the last row to keep visible. For example, if you want to retain three rows, the last row to freeze is row 3.
- Optional: if you also want to keep one or more columns visible, identify the last column to freeze as well. You can freeze rows and columns together by selecting the cell at their intersection boundary.
Step-by-Step
- Open the correct worksheet. If the workbook has several sheet tabs, click the tab containing the data you want to scroll through. Freeze Panes applies to the active worksheet, so check the sheet name before changing the view. It does not change the workbook’s data or remove any rows; it only changes what stays visible while you scroll.
- Decide how many top rows to keep on screen. Count from row 1 downward. To keep rows 1 and 2 visible, you will select a cell in row 3. To keep rows 1 through 5 visible, you will select a cell in row 6. The selected cell itself is not what gets frozen: Excel freezes the rows above it and, if applicable, the columns to its left.
- Clear any existing freeze setting if needed. If the worksheet is already frozen and you want to replace that arrangement, go to View > Freeze Panes > Unfreeze Panes. Existing frozen panes can affect what a new selection does, so unfreezing first is a reliable way to start fresh. If Unfreeze Panes is unavailable, there may not be a freeze setting to clear.
- Select a cell immediately below the rows to freeze. For rows 1 through 3, click A4. For rows 1 through 5, click A6. Using column A means you are freezing rows only, with no columns to the left of the selection. You may click the cell in the worksheet or enter its address in the Name Box to the left of the formula bar and press Enter.
- Choose the Freeze Panes command, not Freeze Top Row. On the ribbon, open the View tab, select Freeze Panes, and choose Freeze Panes from the dropdown. Excel then keeps all rows above the selected cell visible as you scroll down. Freeze Top Row is a different command: it keeps only row 1 visible, regardless of how many rows you want to retain.
- Check the result by scrolling. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down the worksheet. The frozen rows should remain at the top while the rows below them move. A thin dividing line typically marks the boundary between the frozen area and the scrollable area. Scroll back to the top if you need to inspect the setup.
- Adjust the frozen range if it is wrong. Choose View > Freeze Panes > Unfreeze Panes, click the correct cell below the intended rows, and choose View > Freeze Panes > Freeze Panes again. For instance, if you froze only rows 1 and 2 but meant to retain rows 1 through 3, unfreeze, select A4, and apply Freeze Panes again.
To freeze rows and columns at the same time: first unfreeze any current panes. Select the cell that is one row below the last row to freeze and one column to the right of the last column to freeze. To freeze rows 1 through 3 and column A, select B4, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and columns to the left of that cell. If you want rows only, select a cell in column A; if you want columns only, select a cell in row 1.
In Excel for Mac, open the View tab and use Freeze Panes, then choose Freeze Panes. The same selection rule applies: select the cell below and to the right of the areas to keep visible. In Excel for the web, use the View tab and the Freeze Panes menu; the command names and layout can vary slightly with the current web interface, but choose the option for freezing panes based on the selected cell when available. If the selection-based command is not shown, use the desktop app for that setup.
Common Mistakes
- Selecting the row you want to freeze instead of the row below it. To retain rows 1 through 3, select A4, not A3. Excel freezes the rows above the active cell, so selecting a cell on row 3 freezes only rows 1 and 2.
- Using Freeze Top Row for a multirow heading. That command locks only row 1. Use the general Freeze Panes option after selecting the right cell when you need two or more rows.
- Selecting a cell too far down. If you select A10, Excel freezes rows 1 through 9. That may leave little room to see the scrolling data. Unfreeze and select the cell immediately after the last row you actually need.
- Expecting to freeze nonadjacent rows. Freeze Panes retains a continuous area from the top of the worksheet. It cannot keep row 1 and row 4 visible while allowing rows 2 and 3 to scroll independently. Rearrange or copy the information into consecutive top rows if you need it all in the frozen area.
- Freezing the wrong sheet or misunderstanding the line. The setting belongs to the active worksheet, not every sheet in the workbook. Also, the divider can be subtle; test by scrolling rather than relying only on the line’s appearance.
- Confusing freezing with printing options. Frozen rows stay visible on screen while you scroll. They do not automatically repeat on printed pages. If you need headings repeated in print, use Page Layout > Print Titles and set the rows to repeat at the top.
Tips
- Keep the frozen area compact. Freeze only the rows needed to explain the data, such as a title and column labels. Freezing many rows reduces the space available for the worksheet area that scrolls, especially on a laptop screen.
- Use a cell selection for predictable results. The key rule is that Excel freezes everything above and to the left of the active cell. If you only need rows, choose column A so you do not accidentally freeze columns as well.
- Combine rows and columns when useful. For a list with labels across the top and names down the left, freeze both areas together. For example, to retain the first two rows and column A, select B3 before applying Freeze Panes.
- Use the Name Box for exact placement. Click the Name Box, type a reference such as A4, and press Enter. This is helpful in a large worksheet where scrolling to the desired row might be awkward. Then use the Freeze Panes menu.
- Remember that scrolling direction matters. Frozen top rows stay visible as you scroll vertically. They do not follow you to another worksheet, and they do not lock cells against editing. To protect data from changes, use worksheet protection instead.
- Save the workbook after arranging the view. Saving preserves your workbook changes and view setup. If coworkers open the same file, the exact view they see may depend on how they open it and the Excel version, so tell them which rows are intended to remain visible.
Troubleshooting
The wrong number of rows stays visible. Count the rows from the top and check which cell was active when you applied the command. To freeze exactly three rows, the selection must be in row 4. Choose Unfreeze Panes, select A4, and apply Freeze Panes again.
The Freeze Panes option is greyed out or missing. First press Enter or Esc to finish editing a cell, then check that you are on the intended worksheet and open the View tab. Switch to View > Normal if the worksheet is in a different view, and check whether the workbook is protected or opened with limited editing permissions. In Excel for the web, some view commands may be presented differently; try opening the workbook in the desktop app if the selection-based option is unavailable.
Rows do not remain visible when scrolling. Confirm that you chose the general Freeze Panes command and not a different view option, then scroll vertically within the worksheet. If you clicked Freeze Top Row, only row 1 should stay visible. If you clicked Split, you created separate scrollable panes rather than a frozen area; turn off Split from the View tab, then set Freeze Panes using the correct cell.
The frozen line seems to be in the wrong place. The line marks the edge of the frozen region, not necessarily the row you clicked. Unfreeze and reapply the setting from the cell just below the last row you want to retain. Hidden rows can make the boundary confusing, so unhide the relevant rows temporarily if needed, then check the result by scrolling.
You need the headers to appear on printed pages. Freeze Panes affects the on-screen view only. Open Page Layout > Print Titles, and in the Page Setup dialog specify the rows to repeat at the top of each printed page. Check Print Preview to confirm the headings repeat as intended.
Frequently Asked Questions
Can I freeze more than one row in Excel?
Yes. Select a cell in the row immediately below the last row to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to freeze rows 1 through 3.
Can I freeze rows that are not next to each other?
No. Freeze Panes locks a continuous block starting at row 1. It cannot pin isolated rows while letting rows between them scroll. Put the information you need together in consecutive top rows if possible.
Can I freeze rows and columns at the same time?
Yes. Select the cell below the last row and to the right of the last column you want frozen. Selecting B4 freezes rows 1 through 3 and column A. Apply the general Freeze Panes command to that selection.
How do I unfreeze multiple rows?
Go to View > Freeze Panes > Unfreeze Panes. This removes the current frozen rows and columns from that worksheet. You can then select a new cell and set a different arrangement.
Will frozen rows appear on every printed page?
No. Freezing is for the on-screen worksheet view. To repeat headings on paper or in a PDF, set repeating rows through Page Layout > Print Titles and review Print Preview.
Does Freeze Panes prevent someone from changing the frozen cells?
No. It affects scrolling and visibility, not editing permissions. To restrict changes, use Review > Protect Sheet and configure the allowed actions as appropriate.
Related
- How to Filter in Google Sheets: Step-by-Step Guide
- Fill Color in Excel Using Keyboard Shortcuts on Windows
- How to Flip Data in Excel From Bottom to Top Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Budget vs Actual Excel Template: Build and Use OneA budget vs actual Excel template compares planned amounts with recorded results by category and period. In Excel…
- Excel Row at Top of Each Page: Repeat Header Rows in PrintTo print the same row at the top of every page in Excel, go to Page Layout >…
- Excel Cell Highlight Color: How to Change ItTo change a cell’s highlight color in Excel for Microsoft 365 on Windows, select the cell or range,…
- Highlight Duplicates in Excel Lists: Step-by-StepTo highlight repeated values in an Excel list, select the cells you want to check, then choose Home…
- How to Highlight in Microsoft ExcelTo highlight cells in Microsoft Excel, select the cell or range, then choose Home > Fill Color and…
- Excel Data Validation Restrictions and Their LimitsExcel data validation can restrict what users enter in selected cells—for example, to a number range, a date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.