How to Freeze Panes in Excel: Step-by-Step Guide
To freeze panes in Excel, select the cell below and to the right of the rows and columns you want to keep visible, then go to the
View tab and click Freeze Panes. This locks those rows and columns so they stay visible when you scroll through your worksheet.Syntax
Freezing panes in Excel is done through the ribbon interface, not by typing a formula. The main options are:
- Freeze Panes: Locks rows above and columns to the left of the selected cell.
- Freeze Top Row: Locks only the top visible row.
- Freeze First Column: Locks only the first visible column.
You select a cell, then choose one of these options from the View > Freeze Panes menu.
excel
Select a cell (e.g., B2) -> View tab -> Freeze Panes -> Freeze Panes
Example
This example shows how to freeze the first row and first column so they stay visible when you scroll down or right.
excel
1. Click cell B2 (this is below row 1 and right of column A). 2. Go to the View tab on the ribbon. 3. Click Freeze Panes. 4. Select Freeze Panes from the dropdown. Now, row 1 and column A will stay visible as you scroll.
Output
Row 1 and column A remain visible while scrolling through the worksheet.
Common Pitfalls
- Not selecting the correct cell before freezing panes. The freeze happens above and to the left of the selected cell.
- Trying to freeze panes on a protected sheet without unlocking it first.
- Forgetting to unfreeze panes before trying to freeze a different area.
Always select the cell carefully to freeze the exact rows and columns you want.
excel
Wrong way:
- Select cell A1 and click Freeze Panes (nothing freezes because no rows above or columns left).
Right way:
- Select cell B2 and click Freeze Panes to freeze row 1 and column A.Quick Reference
| Freeze Option | What It Does |
|---|---|
| Freeze Panes | Locks rows above and columns to the left of the selected cell |
| Freeze Top Row | Locks only the top visible row |
| Freeze First Column | Locks only the first visible column |
| Unfreeze Panes | Removes all frozen rows and columns |
Key Takeaways
Select the cell below and right of the rows and columns you want to freeze before using Freeze Panes.
Use Freeze Top Row or Freeze First Column for quick locking of just the top row or first column.
Unfreeze panes before changing which rows or columns to freeze.
Freezing panes helps keep headers or labels visible while scrolling large spreadsheets.