Freeze Panes in Excel: Lock Rows & Columns While Scrolling (2026 Guide)
Freeze panes in Excel — lock the top row, first column or both while scrolling. Step-by-step with shortcut, unfreeze, and why the option is greyed out.
Freeze Panes in Excel: Lock Rows & Columns While Scrolling (2026 Guide)
Scrolling through a big Excel sheet and losing track of what each column means? Freeze Panes locks your header row (or first column) in place — it stays visible no matter how far you scroll.
This guide covers freezing the top row, first column, any custom combination, the keyboard shortcut, and fixes for when the Freeze Panes button is greyed out.
Table of Contents
- What Is Freeze Panes in Excel?
- How to Freeze the Top Row
- How to Freeze the First Column
- How to Freeze Multiple Rows AND Columns
- Freeze Panes Keyboard Shortcut
- How to Unfreeze Panes
- Freeze Panes Greyed Out? Here's Why
- Freeze Panes vs Split — Difference
- Frequently Asked Questions
- Conclusion
What Is Freeze Panes in Excel?
Freeze Panes keeps specific rows or columns pinned on screen while the rest of the sheet scrolls. Essential for data with headers — you'll always see "Name | Sales | Date" instead of guessing which column is which at row 500.
Hindi: Freeze Panes se heading row ya column screen pe locked rahega — kitna bhi scroll karo, gayab nahi hogi.
How to Freeze the Top Row
- Open your sheet
- Go to View tab → Freeze Panes
- Select "Freeze Top Row"
Done — row 1 now stays visible while you scroll down. You'll see a thin dark line under it.
How to Freeze the First Column
Same menu:
- View → Freeze Panes
- Select "Freeze First Column"
Column A stays pinned when scrolling right — perfect for name/ID lists.
How to Freeze Multiple Rows AND Columns
Want the top 2 rows AND first column frozen together?
- Click the cell just below the rows and right of the columns you want frozen
* Example: freeze rows 1-2 + column A → click cell B3
- View → Freeze Panes → "Freeze Panes" (the top option)
Everything above and left of the selected cell locks in place.
Rule: Freeze happens at the selected cell's position — above it and left of it.
Freeze Panes Keyboard Shortcut
```
Alt + W, F, F
```
Press keys in sequence: Alt → W → F → F — freezes panes at the current selection. (Alt+W+F opens the Freeze Panes dropdown if you want options.)
How to Unfreeze Panes
- View → Freeze Panes
- Click "Unfreeze Panes" — the option only appears when panes are frozen
Freeze Panes Greyed Out? Here's Why
The button is disabled when:
- You're editing a cell — press Esc or Enter first
- Sheet is protected — unprotect it (Review → Unprotect Sheet)
- You're in "Page Layout" view — switch to Normal view (View → Normal)
- Table/List formatting glitch — click outside the table and retry
Freeze Panes vs Split — Difference
| Feature | What It Does |
|---|---|
| Freeze Panes | Locks rows/columns — frozen part never scrolls |
| Split | Divides screen into scrollable panes — all parts scroll independently |
Use Freeze for headers; use Split to compare two distant areas of the same sheet.
Frequently Asked Questions
How do I freeze a row in Excel?
View tab → Freeze Panes → "Freeze Top Row". For other rows, select the cell below the last row you want frozen → Freeze Panes.
How do I freeze row 1 and column A at the same time in Excel?
Click cell B2 → View → Freeze Panes → "Freeze Panes". Row 1 and column A both lock.
Why is my Freeze Panes option greyed out?
You're editing a cell (press Esc), the sheet is protected, or you're in Page Layout view — switch to Normal view.
What is the shortcut for Freeze Panes in Excel?
Alt + W, F, F — freezes at the current selection. Alt+W+F opens the dropdown menu.
How do I unfreeze panes in Excel?
View → Freeze Panes → "Unfreeze Panes" (appears only when something is frozen).
Does Freeze Panes work in Google Sheets?
Yes — View → Freeze → choose rows/columns, or drag the freeze handle at the top-left of the grid.
Conclusion
Freeze Panes takes 5 seconds and saves daily frustration: select the cell below/right of what you want locked → View → Freeze Panes. Your headers stay visible through thousands of rows.
Video Tutorial:
- AutoSum in Excel — Total in One Click
- Remove Duplicates in Excel Instantly
- Excel Conditional Formatting Guide
TAGS: freeze panes excel, freeze panes excel in hindi, freeze row excel, unfreeze panes excel, freeze panes in excel shortcut, freeze panes excel mac, how to freeze row in excel, excel freeze top row, techn trainer
What's Your Reaction?
