How to Freeze Rows in Excel: 5 Methods That Work
Here’s the thing — you’re working with a spreadsheet that has hundreds of rows, and the moment you scroll down, the header row disappears. Now you have no idea which column is which. If you’ve ever scrolled through a 5,000-row spreadsheet trying to remember what column “F” means, you’re not alone. Knowing how to freeze rows in Excel solves this problem permanently. Set it once, and your headers stay visible no matter how far you scroll. This guide covers five methods: freezing a single row, freezing multiple rows, freezing columns, freezing rows and columns at the same time, and fixing it when freeze panes stops working.
How to Freeze Rows in Excel: The Top Row
The most common use case is locking the very first row — and it’s the fastest method to set up. It doesn’t matter which cell is currently selected. The Freeze Top Row option always locks row 1 regardless of cursor position.
Step 1: Click the View tab in the top ribbon.
Step 2: Click Freeze Panes in the Window group.
Step 3: Select Freeze Top Row from the dropdown.
Done. A thin grey line appears below row 1 to confirm the freeze is active. Scroll down as far as you like — row 1 stays locked at the top. This is the simplest answer for most everyday spreadsheet users.
Keyboard Shortcut to Freeze Rows in Excel
If you prefer to keep your hands on the keyboard, press Alt → W → F → R in sequence — not all at once. Each key is pressed and released one at a time. This shortcut freezes the top row instantly on Windows. On Mac, there’s no direct keyboard shortcut; use the View menu instead.
For the full freeze panes menu via keyboard, use Alt → W → F → F. This opens the standard Freeze Panes option, which is what you’ll need for anything beyond just the top row — including multiple rows or combined row and column freezes.
How to Freeze Multiple Rows in Excel
Freezing multiple rows works differently from freezing just the top row. This is where almost everyone gets confused. The key is selecting the correct row before applying the freeze — and most people get this wrong the first time. You don’t select the rows you want to freeze. You select the row directly below them.
Step 1: Click the row number of the first row you want to remain unfrozen. To freeze rows 1 through 3, click row number 4 to select the entire row.
Step 2: Click the View tab.
Step 3: Click Freeze Panes.
Step 4: Select Freeze Panes — the first option in the dropdown, not Freeze Top Row.
Every row above your selected row is now frozen. To freeze the top 5 rows, select row 6. To freeze the top 2 rows, select row 3. Here’s the part that trips people up if you skip it: always select one row below where you want the freeze to end.
How to Freeze the Top 3 Rows — and Why Row Selection Is Everything
To freeze the top 3 rows: click the number 4 on the left side of the spreadsheet to highlight the entire row 4, then go to View → Freeze Panes → Freeze Panes. Rows 1, 2, and 3 are now locked. This same logic applies no matter how many rows you’re freezing — the selected row stays visible and unfrozen, everything above it gets locked.
The grey dividing line appears below row 3 to confirm the freeze is active. If the line appears somewhere unexpected, you’ve selected the wrong row. Unfreeze panes and try again — getting this right always starts with selecting the correct boundary row first.
How to Freeze Multiple Columns in Excel
Freezing columns follows the exact same logic as freezing rows — select the column immediately to the right of the last column you want frozen, then apply Freeze Panes. It looks confusing at first, but it’s simply the horizontal version of the same process.
Step 1: Click the column letter of the first column you want to remain unfrozen. To freeze columns A and B, click column letter C.
Step 2: Click the View tab.
Step 3: Click Freeze Panes → Freeze Panes.
Columns A and B are now frozen. Scroll right as far as you need — those two columns stay locked on the left.
Freeze First Column Only — The Fast Way
If you only need to freeze column A, go to View → Freeze Panes → Freeze First Column. No need to select a cell or column first — it applies instantly. This is the column equivalent of Freeze Top Row and the fastest option when only one column needs to be locked.
Freezing more than one column only requires the standard Freeze Panes route. Just as with multiple rows, column selection before freezing is mandatory when going beyond the first column.
How to Freeze Rows and Columns in Excel at the Same Time
Freezing rows and columns simultaneously is the most powerful freeze panes configuration. Microsoft documents this approach for large datasets where both row headers and row labels need to stay visible. That’s where most people go wrong — the trick is selecting a single cell, not a row or column, that sits at the intersection of where both freezes should end. This combined freeze is also common among people working with large datasets.
Step 1: Click a single cell. Everything above it and to the left of it will be frozen. To freeze row 1 and column A, click cell B2.
Step 2: Click the View tab.
Step 3: Click Freeze Panes → Freeze Panes.
Row 1 and column A are now both locked. Scroll in any direction and both headers remain visible.
Cell Selection Is the Key to Simultaneous Freeze
The cell you select determines both freeze points at once. Select C3 and you freeze rows 1–2 and columns A–B simultaneously. Select D5 and you freeze rows 1–4 and columns A–C. The selected cell itself is never frozen — it’s always the boundary point. To boost your overall office productivity beyond spreadsheet basics, our guide on the best AI tools in 2026 covers tools that work alongside Excel to cut your daily workload significantly.
💡 PRO TIP
Before applying any freeze, check whether freeze panes is already active. If you see “Unfreeze Panes” in the Freeze Panes dropdown, a freeze is already set. Applying a new freeze on top of an existing one gives unexpected results every time. Always unfreeze first, then reapply from scratch. It takes five seconds and prevents a lot of confusion on complex spreadsheets.
How to Unfreeze Panes and Fix Freeze Panes Not Working
Unfreezing is even simpler than freezing in the first place. Go to View → Freeze Panes → Unfreeze Panes. One click removes all active freezes simultaneously. This option only appears when a freeze is already active — if you see “Freeze Panes” instead of “Unfreeze Panes,” nothing is currently frozen.
For the official Microsoft documentation, the Microsoft Support freeze panes guide covers every version of Excel in detail.
Why Freeze Panes Is Greyed Out or Not Working
Two issues cause this almost every time. First: the cell is in edit mode — the cursor is blinking inside a cell. Press Escape to exit edit mode, then try again. Second: the workbook is protected. Go to the Review tab → Unprotect Workbook, enter the password if required, then apply your freeze.
A third less common issue: if you’re in Page Layout view instead of Normal view, freeze panes is disabled. Switch back via View → Normal, then apply the freeze. This catches out a lot of users who’ve accidentally switched views.
A complete visual walkthrough of how to freeze panes in Excel — rows, columns, and both at once.
Frequently Asked Questions
Why can’t I freeze multiple rows in Excel?
The most common reason is selecting the wrong row. Freezing rows correctly means selecting the row directly below the last row you want frozen — not the rows themselves. To freeze rows 1 through 3, click row 4, then apply Freeze Panes. Also check that you’re not in edit mode (press Escape) and that the workbook isn’t protected (Review tab → Unprotect Workbook).
Can I freeze both the first row and first column in Excel?
Yes. Click cell B2, then go to View → Freeze Panes → Freeze Panes. Row 1 and column A will both be locked simultaneously. Everything above and to the left of your selected cell gets frozen — this is the most efficient way to lock a row and a column at the same time.
What is the keyboard shortcut to freeze panes in Excel?
On Windows, press Alt → W → F → F in sequence to open the Freeze Panes option. For Freeze Top Row specifically, use Alt → W → F → R. For Freeze First Column, use Alt → W → F → C. These are sequential key presses, not simultaneous combinations. Mac users don’t have a direct shortcut — use the View menu instead.
How do I freeze rows in an Excel table?
Excel tables formatted with Ctrl + T automatically keep column headers visible when you scroll — no freeze panes required. The header row replaces the column letters at the top of the screen as you scroll down. If your data is in a regular range instead of a table, use the freeze panes method described above.
Does freezing rows in Excel work the same way in Google Sheets?
The concept is the same but the menu path is different. In Google Sheets, go to View → Freeze → choose the number of rows or columns to lock. There’s no Freeze Panes option — you select the number directly. If you switch between Excel and Google Sheets regularly, the underlying logic transfers but the menu navigation doesn’t.
Once you understand how Freeze Panes works, you’ll never lose track of your headers again.
You May Also Like
Python in Excel: How to Enable It and 3 Key Functions
XLOOKUP vs VLOOKUP: 5 Reasons to Switch Now
Google Sheets Tutorial for Beginners: Formulas That Work
Cheap Meal Prep: Stop Wasting $125 a Month on Food
Meal Prep on a Budget: 10 High-Protein Recipes
Vegetables Dogs Can Eat: A Complete Safety Guide
Naver Maps English: 7 Tips to Navigate Korea Like a Local
How to Find Unclaimed Money from the Government for Free