How to Freeze Rows and Columns in Excel
Freezing rows and columns keeps your headers visible while you scroll through data. Excel offers three commands under View → Freeze Panes that cover every situation. Here's how to use each one.
⚡ Quick Answer
Click View → Freeze Panes → Freeze Top Row to keep row 1 visible. For multiple rows or columns, select the cell below-and-right of what you want frozen, then click View → Freeze Panes → Freeze Panes.
Method 1: Freeze the top row
The most common case — a header row that stays visible while you scroll through data.
Open the View tab
Click the View tab in the ribbon.
Click Freeze Panes
In the Window group, click Freeze Panes.
Select Freeze Top Row
From the dropdown, choose Freeze Top Row. Row 1 is now locked. Scroll down — row 1 stays put.
Method 2: Freeze the first column
For datasets where the leftmost column has labels you want to keep visible while scrolling right.
Open View → Freeze Panes
Same starting point as before.
Select Freeze First Column
Column A stays visible when you scroll horizontally.
Method 3: Freeze multiple rows or columns
The most flexible option — freeze any number of rows, columns, or both simultaneously.
Select the anchor cell
Click the cell that is below the last row and to the right of the last column you want frozen. Example: to freeze rows 1-2 and column A, click cell
B3.Open View → Freeze Panes → Freeze Panes
Click View → Freeze Panes → Freeze Panes. Excel freezes everything above and to the left of your selected cell.
Think of the selected cell as the "hinge" — everything above and to the left is frozen. Click A2 to freeze only row 1. Click C1 to freeze columns A and B. Click C3 to freeze rows 1-2 and columns A-B.
How to unfreeze panes
Open View → Freeze Panes
Click the View tab, then Freeze Panes.
Select Unfreeze Panes
The option replaces "Freeze Panes" when panes are already frozen. Click it to remove all frozen rows and columns.
Keyboard shortcuts
Freeze Panes Shortcuts
What if Freeze Panes is greyed out?
Three common reasons Freeze Panes won't work:
- You're in Page Layout view. Switch to View → Normal.
- The worksheet is protected. Go to Review → Unprotect Sheet and enter the password if required.
- Multiple sheets are grouped. Right-click any tab and choose Ungroup Sheets.
Both live in the View tab, but they do different things. Freeze keeps rows or columns visible while scrolling. Split divides the worksheet into 2 or 4 independently-scrollable panes — useful for comparing distant sections but different from freezing.
Excel Wizard — automate what freezing can't solve
Frozen headers help you navigate. But if you're constantly scrolling through data to find things, that's a data-analysis problem, not a viewing problem. Excel Wizard's =AI() function summarizes data, extracts key rows, and answers questions about your spreadsheet directly — no scrolling needed.
Frequently asked questions
How do I freeze the top row in Excel?
Click the View tab, then Freeze Panes, then Freeze Top Row. Row 1 will stay visible when you scroll down. This works regardless of which cell is selected.
How do I freeze multiple rows in Excel?
Click the cell directly below the last row you want frozen (e.g., click A3 to freeze rows 1 and 2). Then click View → Freeze Panes → Freeze Panes. Rows above your selection are frozen.
Why can't I freeze panes in Excel?
The most common reasons: (1) You're in Page Layout view — switch to Normal view first. (2) The worksheet is protected — unprotect it via Review → Unprotect Sheet. (3) Multiple sheets are grouped — right-click a tab and Ungroup Sheets.
What's the difference between Freeze Panes and Split?
Freeze Panes locks rows or columns so they stay visible when scrolling. Split divides the worksheet into two or four independently-scrollable regions. Freeze is for keeping headers visible; Split is for viewing two distant parts of a sheet simultaneously.