Errors
To freeze multiple rows in Excel, click the row below the last row you want frozen, then go to View > Freeze Panes > Freeze Panes. For example, to freeze the top 3 rows, click on row 4, then apply Freeze Panes. Everything above row 4 stays visible while you scroll through the rest of the spreadsheet.
Freezing rows is essential when working with large datasets where you need header rows to remain visible as you scroll through hundreds or thousands of rows. Excel allows you to freeze any number of top rows, left columns, or both simultaneously. This guide covers every freezing scenario with clear examples.
Click on the row below the rows you want to freeze (e.g., click row 3 to freeze rows 1-2). Go to View > Freeze Panes > Freeze Panes. Done — scroll down and the frozen rows stay at the top.
Method 1: Freeze the Top Row Only
The simplest option — freezes just the first row, typically your column headers.
Go to the View Tab
Click the View tab in the ribbon.
Click Freeze Panes
Click Freeze Panes in the Window group.
Select Freeze Top Row
Click Freeze Top Row. A thin line appears below row 1, indicating it is frozen. Scroll down to verify that row 1 remains visible.
Method 2: Freeze the Top 2, 3, or More Rows
When your spreadsheet has multi-row headers or you want to keep several reference rows visible while scrolling.
Select the Row Below Your Freeze Point
Click on the row number of the first row you want to scroll. For example, to freeze the top 3 rows, click anywhere in row 4. To freeze the top 5 rows, click row 6.
Go to View Tab
Click the View tab in the ribbon.
Click Freeze Panes > Freeze Panes
Click Freeze Panes, then click Freeze Panes (the first option in the dropdown, not Freeze Top Row). A line appears below your frozen rows.
Test by Scrolling
Scroll down through your spreadsheet. The rows above the freeze line remain locked at the top while the rest of the data scrolls normally.
Tip: The key to freezing multiple rows is selecting the correct row BEFORE applying Freeze Panes. Always click the row immediately below the last row you want frozen. Excel freezes everything above the selected cell.
Method 3: Freeze Rows AND Columns Simultaneously
You can freeze both top rows and left columns at the same time by selecting a cell at the intersection point.
Click the Cell at the Intersection
To freeze the top 2 rows and left 1 column, click cell B3. Everything above row 3 and to the left of column B will be frozen.
Apply Freeze Panes
Go to View > Freeze Panes > Freeze Panes. Two freeze lines appear — one horizontal and one vertical.
Scroll to Test
Scroll both down and right. The frozen rows and columns stay in place while the rest of the sheet moves.
Method 4: Unfreeze Panes
Removing frozen rows and columns is a single-click operation.
Go to View Tab
Click the View tab.
Click Freeze Panes
Click Freeze Panes in the ribbon.
Select Unfreeze Panes
Click Unfreeze Panes (this option replaces Freeze Panes when panes are currently frozen). All freeze lines are removed.
Method 5: Freeze Rows in Google Sheets
Google Sheets has a simpler interface for freezing rows.
Open Your Spreadsheet in Google Sheets
Go to sheets.google.com and open your spreadsheet.
Go to View > Freeze
Click View in the menu bar, then hover over Freeze.
Select the Number of Rows
Choose 1 row, 2 rows, or Up to Current Row. For more than 2 rows, click the row you want as the last frozen row, then select Up to Current Row.
Warning: Frozen rows do not affect printing. To repeat header rows on every printed page, use Page Layout > Print Titles > Rows to Repeat at Top instead of Freeze Panes.
Why Freeze Rows in Excel Spreadsheets?
Large spreadsheets become unmanageable when column headers scroll out of view. You lose track of which column contains which data, leading to errors when entering or reading values. Freezing the header rows keeps column labels permanently visible regardless of how far down you scroll. This is particularly important for data entry tasks, financial reports with hundreds of rows, inventory sheets, student grade books, and any dataset where the header row contains essential context for understanding the data below it.
Frequently Asked Questions
Click on row 3 (the first row below your headers), then go to View > Freeze Panes > Freeze Panes. Rows 1 and 2 will stay visible while scrolling.
No, you can only freeze rows starting from the top. However, you can use the Split feature (View > Split) to create independently scrollable panes at any position.
Freeze Panes is grayed out when you are in cell editing mode (press Esc first), when the spreadsheet is in Page Layout view (switch to Normal view), or when the sheet is protected.
No. Frozen rows are purely a visual feature. They do not affect calculations, formulas, sorting, filtering, or any data operations.
Go to View > Freeze Panes > Freeze First Column. To freeze multiple columns, click a cell in column C (or further right) and apply Freeze Panes.
Yes. Excel Online supports freezing rows. Go to View > Freeze Panes and select your option. The interface is slightly different from the desktop version.
Freeze Panes does not affect printing. Go to Page Layout > Print Titles, click in the Rows to Repeat at Top field, and select your header rows. These will print on every page.
No, Excel only supports one freeze point. You get one horizontal freeze line and one vertical freeze line. For more complex viewing needs, use the Split feature instead.
The process is identical: click the row below your freeze point, then go to View > Freeze Panes. The Mac version of Excel has the same ribbon interface.
Freeze Panes locks rows/columns in place so they are always visible. Split divides the worksheet into independently scrollable panes — both sections can show any part of the sheet.