How to Freeze Multiple Rows in Excel While Scrolling

To freeze more than one row in Excel for Microsoft 365 on Windows, select the cell in column A immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A3 to keep rows 1 and 2 on screen while you scroll. The rows must be consecutive from the top of the worksheet.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows. The same basic method is available in current Excel for Mac and Excel for the web, though the ribbon layout can vary slightly.
A worksheet with the rows you want to keep visible at the top. Decide which consecutive rows are headers or other reference information before freezing them.
The row number immediately after the last row you want to freeze. This tells you which cell to select before using Freeze Panes.

Step-by-Step

Open the correct worksheet. Click the sheet tab that contains the data you will be working with. Freeze settings apply to the current worksheet, not to every sheet in the workbook. If the workbook has several sheets, you will need to set up each one separately.
Identify the rows to keep visible. Count down from row 1 and decide where the header or reference area ends. If your table has a title in row 1, column headings in row 2, and data beginning in row 3, you may want to freeze both rows 1 and 2. Excel freezes rows from the top down as one block; it cannot freeze row 1 and a separate, non-adjacent row while leaving the row between them scrolling.
Select a cell below those rows in column A. Click the cell in column A on the first row that should scroll. To freeze rows 1 and 2 only, click A3. To freeze rows 1 through 4, click A5. Using column A matters: selecting a cell farther to the right can also freeze columns to its left.
Apply Freeze Panes. On the ribbon, select View > Freeze Panes > Freeze Panes. In the menu, choose the option named Freeze Panes, not Freeze Top Row. Freeze Top Row locks only row 1, regardless of the cell you selected. Freeze Panes uses the selected cell as the boundary for both rows and columns.
Check the result by scrolling down. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move to lower rows. The frozen rows should remain at the top while the rest of the worksheet moves. Excel often shows a thin line at the edge of the frozen area. Scroll back to the top if you need to check the boundary or readjust the setup.
Freeze columns at the same time, if needed. Select a cell that is both below the rows and to the right of the columns you want to keep visible. For example, select C3 and use View > Freeze Panes > Freeze Panes to freeze rows 1 and 2 and columns A and B. If you want to freeze rows only, select a cell in column A, such as A3.
Remove or change the freeze when necessary. Choose View > Freeze Panes > Unfreeze Panes. Excel removes the current freeze from that worksheet. Then select the new boundary cell and apply Freeze Panes again. You cannot add another independent frozen area on the same sheet; setting a new boundary replaces the existing freeze.

On Excel for Mac, select the same boundary cell and use View > Freeze Panes > Freeze Panes; the exact placement or appearance of the ribbon can differ from Windows. In Excel for the web, look under the View tab for Freeze Panes. If the command is not visible, widen the browser window or check the tab’s overflow menus.

Common Mistakes

Choosing Freeze Top Row when you need several rows. This command is a shortcut for locking only the first worksheet row. It does not use your selected cell to decide how many rows to freeze. Use the main Freeze Panes option instead, after selecting the correct boundary cell.

Selecting a cell on the row you want frozen. Excel freezes the rows above the selected cell, not the selected row itself. If row 3 is the first row you want to scroll, select a cell in row 3; the frozen rows will be rows 1 and 2. Selecting A2 freezes only row 1.

Clicking in the wrong column. Freeze Panes locks everything above and to the left of the active cell. Selecting D3 to freeze rows 1 and 2 also freezes columns A through C. To freeze rows only, choose column A. To freeze rows and columns intentionally, count both boundaries before selecting the cell.

Expecting non-adjacent rows to stay in place. Freeze Panes always locks a continuous block starting at the top of the sheet. If your useful headings are separated by scrolling rows, consider rearranging the worksheet so the headings are together, or use another way to keep the information accessible.

Tips

Use the worksheet row numbers to calculate the boundary rather than guessing. If the last row to remain visible is row 6, the first row that should scroll is row 7, so select a cell in row 7. For a rows-only freeze, select A7. This simple rule works for any number of consecutive top rows.

Keep the frozen area compact. Locking a title, several instruction rows, and a large block of notes can leave little room to view the scrolling data, especially on a laptop display. Freeze only the labels or reference information you need while navigating. You can always unfreeze and set a different boundary later.

If your headings occupy multiple rows, make sure all of them are included. For example, a report may have a report name in row 1, a date in row 2, and column headings in row 3. Selecting A4 freezes all three. Freezing only row 1 would allow the column headings to disappear as you scroll, which may make the data harder to interpret.

Freeze settings belong to individual worksheets, so check each sheet where you need the same behavior. Also, freezing is a viewing aid; it does not change the order of rows, alter formulas, or prevent someone from editing the frozen cells. Save the workbook after making layout changes if you want to preserve your work.

Troubleshooting

The wrong number of rows stays visible. First choose View > Freeze Panes > Unfreeze Panes. Then identify the last row that should remain fixed, select a cell in the next row in column A, and apply Freeze Panes. For example, if rows 1 through 5 should stay visible, select A6. Remember that Excel freezes above the selected row, not through it.

Columns are frozen unexpectedly. The selected cell was probably to the right of column A. Unfreeze the sheet, select the appropriate cell in column A, and apply Freeze Panes again. If you do want columns fixed too, select the cell one column to the right of the last column to freeze and one row below the last row to freeze.

The command appears unavailable or the sheet will not behave as expected. Check whether the worksheet is protected or whether you are editing a cell. Finish or cancel the cell edit, and, if the sheet is protected, ask the workbook owner whether protection can be removed or adjusted. Also confirm that you are using the View tab for the worksheet rather than a different Excel window or workbook.

The dividing line is hard to see. Scroll down a little and watch whether the top rows remain in place; that is the practical test. The separator can be subtle and may look different with display scaling or in the web app. If nothing stays put, unfreeze and repeat the steps, checking that you selected the cell below the intended rows and chose Freeze Panes rather than Freeze Top Row.

The freeze does not carry over to another sheet. This is expected: each worksheet has its own freeze setting. Click the other sheet tab, choose its boundary cell, and apply Freeze Panes there too. If you work with several sheets that have different header layouts, calculate the boundary separately for each one.

Frequently Asked Questions

Can I freeze more than one row in Excel?

Yes. Select a cell in column A on the first row that should scroll, then choose View > Freeze Panes > Freeze Panes. Excel keeps all rows above that cell visible.

How do I freeze the first three rows?

Select A4, then choose View > Freeze Panes > Freeze Panes. Rows 1, 2, and 3 stay visible; row 4 and the rows below it scroll.

Can I freeze rows that are not next to each other?

No. Freeze Panes locks a continuous block of rows beginning with row 1. It cannot keep separate rows fixed while allowing rows between them to scroll.

Can I freeze rows and columns together?

Yes. Select a cell below the last row and to the right of the last column you want fixed, then apply Freeze Panes. For example, C3 freezes the first two rows and the first two columns.

Will frozen rows print at the top of every page?

No. Freeze Panes controls what remains visible while you scroll on screen; it does not set print headings. To repeat rows on printed pages, use the separate print-title settings under Page Layout.

Does freezing rows lock them against editing?

No. Frozen rows stay visible during scrolling but remain editable unless the worksheet is separately protected. Freeze Panes changes the view, not the cell permissions.

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.