Freeze a Group of Rows in Excel: Step-by-Step Guide

To keep several rows visible while you scroll in Excel for Microsoft 365 on Windows, select the first cell in the row immediately below the rows you want to keep, then choose View > Freeze Panes > Freeze Panes. For example, to keep rows 1 through 3 visible, select cell A4 before freezing. Save the workbook first if you want a simple way to revert other changes, and decide how many top rows need to stay in view.

What You’ll Need

An Excel workbook with the rows you want to keep visible at the top of the worksheet.
The number of top rows to freeze. Freeze Panes works from the top down, so the rows you keep visible must be consecutive rows beginning at row 1.
Access to the View tab. These instructions use Excel for Microsoft 365 on Windows; Excel for Mac and Excel for the web have similar commands, with small interface differences noted below.

Step-by-Step

Open the right worksheet. Open the workbook and click the sheet tab containing the data. Freeze Panes applies to the current worksheet, not every worksheet in the workbook, so repeat the process on each sheet where you need it. If you are working in a shared or important file, confirm that you are on the intended sheet before changing the view.
Choose which rows should remain visible. Identify the consecutive rows at the top that contain titles, column headings, dates, or other context you need while scrolling. For instance, if rows 1 and 2 contain a report title and date range and row 3 contains column labels, decide whether all three rows need to stay visible. Excel freezes rows above your selected cell; it does not freeze the row containing that cell.
Check for an existing freeze or split. Open the View tab and look at Freeze Panes. If the menu offers Unfreeze Panes, a freeze is already active. If the worksheet is divided by a visible horizontal or vertical bar, it may be using Split instead. Clear the existing view arrangement before setting a new one; otherwise, Excel may not create the boundary you expect. The troubleshooting section explains how to reset it.
Select the cell just below the rows to keep. Click the first cell in the row immediately beneath your intended frozen rows. To freeze rows 1 through 3, select A4. To freeze only row 1, select A2. You can select a cell in another column, but that may freeze columns as well: Excel freezes the rows above the selected cell and the columns to its left. Selecting a cell in column A avoids freezing any columns.
Open the Freeze Panes menu. On the Windows ribbon, choose View > Freeze Panes. In the menu, select the first command, also called Freeze Panes. Do not choose Freeze Top Row if you need multiple rows; that command is specifically for row 1 only. Similarly, Freeze First Column keeps column A visible, not a group of rows.
Check the result by scrolling. Scroll down several rows using the mouse wheel, scroll bar, or keyboard. The rows you chose should remain at the top of the worksheet while the data below them moves. Look for a thin line marking the freeze boundary, usually just below the frozen rows. If the wrong rows remain visible, unfreeze and repeat the selection carefully.
Save the workbook if appropriate. The freeze is a view setting for that worksheet and is saved with the workbook when you save your changes. If the file is shared, let collaborators know that the rows are frozen if it might affect their view. They can change or remove the setting themselves, and their changes may be saved to the shared workbook depending on how it is shared.

Example: Suppose a worksheet has a two-line title in rows 1 and 2, field names in row 3, and hundreds of records starting in row 4. To keep the title and field names visible together, select A4 and choose View > Freeze Panes > Freeze Panes. If only the field names in row 3 need to remain visible, this command cannot freeze row 3 by itself while leaving rows 1 and 2 scrolling away. Freeze Panes keeps a continuous block from the top, so you would freeze rows 1 through 3 or use another layout approach.

Common Mistakes

Selecting a cell in the row you want to freeze. Excel freezes rows above the selected cell, not the selected row. To freeze through row 5, select a cell in row 6, such as A6.
Choosing Freeze Top Row for a multirow heading. That command freezes only row 1. Use the general Freeze Panes command after selecting the cell below the full group.
Selecting a cell too far to the right. If you select D4, Excel freezes rows 1 through 3 and columns A through C. That may create an unexpected vertical boundary. Select A4 when you want rows only.
Trying to freeze a block in the middle of the sheet. Freeze Panes cannot keep, for example, rows 10 through 12 visible while rows above them scroll. Its frozen rows must start at row 1 and continue without gaps.
Using Split and Freeze Panes as if they were the same thing. Split divides the worksheet into independently scrollable areas; Freeze Panes pins rows or columns in place. A split line can make the sheet behave differently from what you intended.

Tips

Keep the frozen area compact. Every frozen row takes up screen space. Freeze only the rows that provide useful context, especially if you use a laptop or a small window. A large frozen block can leave little room to see the records below it.
Use a clear heading layout. Put the headings you need together at the top of the sheet where practical. Because freezing applies to a continuous block, a title or blank row above the column names will be frozen too if you freeze through the column-name row.
Consider a table for data with one header row. Excel tables can show their column headers in the worksheet while you scroll within the table, once the table header is out of view. This can be useful if you only need field names and do not want to freeze several report-title rows. Table behavior is separate from the Freeze Panes setting.
Remember that freezing affects the view, not the data. It does not lock cells, protect headings from edits, or change the order of rows. Use worksheet protection if your goal is to prevent edits, and use Freeze Panes only to keep content visible during scrolling.
Use the matching selection when freezing both rows and columns. For example, selecting D4 and choosing Freeze Panes keeps rows 1 through 3 and columns A through C fixed. This is helpful when both a multirow heading and identifying fields at the left edge need to stay visible.

Troubleshooting

The wrong number of rows is frozen. Choose View > Freeze Panes > Unfreeze Panes, then select the cell one row below the last row you want fixed. If you want rows 1 through 4, select a cell in row 5, such as A5, and apply Freeze Panes again. Verify the result by scrolling rather than relying only on the boundary line.

Columns are frozen too. This usually means the selected cell was not in column A. Unfreeze the current setting, select a cell in column A at the correct row, and apply Freeze Panes again. For example, A4 freezes rows 1 through 3 without freezing columns. A selection such as C4 freezes both the first three rows and the first two columns.

The Freeze Panes command is unavailable or the view behaves strangely. First check whether the worksheet is in a special view or whether the workbook or sheet has restrictions that affect available commands. Also look for a split pane. On Windows, use View > Split to turn off an active split, then use View > Freeze Panes > Unfreeze Panes if that option is available. Select the target cell and apply the freeze again. If the workbook is opened in a browser or shared editing session, try opening it in the desktop app if the ribbon options are limited.

The headings disappear when you scroll. Confirm that you used the general Freeze Panes command and not a command for a different row or column. If you froze the right area but still cannot see the headings, check whether the rows are hidden, whether the worksheet is scrolled horizontally or vertically in another pane, and whether the freeze boundary is below the rows you intended. Unfreeze and redo the steps if needed.

You need to freeze nonadjacent or lower rows. Freeze Panes cannot pin separate row groups or a section in the middle of the worksheet. Reorganize the layout so the required headings are at the top, freeze the continuous top rows, or create a separate summary view. If the need is to compare distant sections, Split or opening a second window of the workbook may be more suitable than freezing a non-top row group.

On Mac or Excel for the web: The labels and ribbon arrangement can differ slightly, but look on the View tab for Freeze Panes, then use the command that freezes based on the selected cell. In Excel for the web, the command may appear in a compact ribbon menu. The same selection rule applies: select the first cell below the rows you want fixed. If your version does not offer the needed controls, open the workbook in Excel for Microsoft 365 desktop.

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. Selecting A4 freezes rows 1 through 3. The rows must be consecutive and begin at the top of the worksheet.

Can I freeze rows without freezing columns?

Yes. Select a cell in column A at the correct position. For example, select A6 to freeze rows 1 through 5 without freezing any columns. A cell farther right freezes the columns to its left as well as the rows above it.

Can I freeze a group of rows that does not start at row 1?

No. Freeze Panes can keep a continuous block at the top of the sheet visible, but it cannot pin a lower block such as rows 8 through 10 while rows 1 through 7 scroll. Move the needed headings to the top or choose another way to arrange or view the data.

How do I unfreeze rows?

Go to View > Freeze Panes > Unfreeze Panes. The frozen rows and columns will then scroll normally. You can select a new cell and apply a different freeze afterward.

Does freezing rows change or protect worksheet data?

No. Freezing is a display setting that keeps rows or columns visible as you scroll. It does not prevent editing, lock cells, or alter values. Use worksheet protection for editing restrictions, and save the workbook if you want the freeze setting to persist.

Why does Freeze Top Row not keep all my headings visible?

Freeze Top Row pins only row 1. If your headings occupy several rows, select a cell just below the entire heading block and use the general Freeze Panes command instead. For headings in rows 1 through 3, select A4.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.