To freeze rows and columns in Microsoft Excel, use the Freeze Panes command on the View tab. This locks selected rows and columns so they stay visible while you scroll through the rest of your worksheet.
What Freeze Panes Does
Freezing panes is a viewing feature that keeps specific parts of your spreadsheet on screen at all times. When you scroll down, the frozen rows remain at the top; when you scroll right, the frozen columns remain on the left. This is especially useful for large datasets where you need to see header rows or label columns while navigating.
Excel offers three freeze options:
- Freeze Panes – freezes rows above and columns to the left of the selected cell.
- Freeze Top Row – always shows the first row.
- Freeze First Column – always shows the first column.
The feature does not change your data or formulas; it only affects how the worksheet is displayed. You can freeze as many rows and columns as you need, limited only by the size of your sheet.
How to Freeze the Top Row
This is the most common freeze request, perfect for keeping column headers visible.
- Open your Excel workbook and go to the worksheet you want to modify.
- Click the View tab on the ribbon.
- In the Window group, click the Freeze Panes dropdown arrow.
- Select Freeze Top Row.
A thin black line appears under row 1, indicating the frozen boundary. Now when you scroll down, row 1 stays put. To unfreeze, go back to the same menu and choose Unfreeze Panes.
How to Freeze the First Column
This is useful when your spreadsheet has row labels in column A that you want to keep visible while scrolling horizontally.
- Go to the View tab.
- Click Freeze Panes dropdown.
- Select Freeze First Column.
Excel places a vertical line to the right of column A. Scroll right and column A remains on screen. You can combine this with freezing the top row? No, you cannot freeze both top row and first column using these two single commands at the same time. For that, you need the full Freeze Panes option described next.
How to Freeze Multiple Rows and Columns
When you need to freeze both headers and labels simultaneously, or freeze more than one row or column, use the general Freeze Panes command.
- Click on the cell that is just below the rows you want to freeze and just to the right of the columns you want to freeze. For example, to freeze rows 1 and 2 and columns A and B, click cell C3.
- Go to the View tab.
- Click Freeze Panes dropdown.
- Select Freeze Panes (the first option).
Excel draws both a horizontal line above the selected cell and a vertical line to its left. All rows above and columns to the left are now frozen. This method is the most flexible and is the one to use when you need anything beyond the simple top row or first column.
How to Unfreeze Panes
To remove all frozen rows and columns, go to the View tab, click Freeze Panes dropdown, and select Unfreeze Panes. This resets the worksheet to normal scrolling. Note that if you have not frozen anything, the option is grayed out.
You can also freeze panes in multiple worksheets independently. Freezing is a per-sheet setting, so freezing on Sheet1 does not affect Sheet2. Each sheet remembers its own freeze state.
Common Problems and Solutions
Users often run into a few issues when freezing panes:
- Freeze Panes is grayed out. This happens when you are in cell editing mode (click into the formula bar) or when the sheet is protected. Press Enter to exit edit mode, or unprotect the sheet under Review > Unprotect Sheet.
- Freeze Top Row and Freeze First Column both appear checked. That is normal; it means both are active. To remove one, you must unfreeze all and then reapply the one you want.
- Frozen rows disappear when scrolling. Make sure you are not in a table or a filtered list where scrolling behaves differently. Also, if you have split panes (the split box on the scroll bar), remove them by going to View > Split to toggle it off.
- Freeze does not work on multiple sheets at once. You need to apply freeze separately to each sheet. There is no built-in way to freeze all sheets simultaneously, though you can select multiple sheet tabs and then apply freeze to apply to all selected sheets.
Freeze vs. Split vs. Print Titles
People sometimes confuse freezing with other similar features:
- Split divides the window into separate scrollable panes. Unlike freeze, each pane scrolls independently. Use it when you want to compare distant parts of the same sheet.
- Print Titles (Page Layout tab) repeats specified rows or columns on every printed page. This is for printing only and does not affect on-screen scrolling.
- Freeze keeps rows/columns visible on screen but does not affect printing.
For a typical workflow, freezing is the right choice for on-screen navigation, while print titles are for paper output.
Frequently Asked Questions
How do I freeze both the top row and the first column at the same time?
Click on cell B2 (the cell just below row 1 and to the right of column A), then go to View > Freeze Panes > Freeze Panes. This freezes both row 1 and column A simultaneously.
Why can’t I see the Freeze Panes option?
The Freeze Panes button is on the View tab in the Window group. If it is grayed out, you are likely in cell edit mode or the sheet is protected. Press Enter or Escape, or unprotect the sheet.
Does freezing panes work in Excel Online or Google Sheets?
Yes. Excel for the web has the same Freeze Panes options under View. Google Sheets has a similar feature under View > Freeze, where you can choose rows and columns.
Can I freeze more than one row or column?
Yes. Use the general Freeze Panes option and select a cell below and to the right of the rows/columns you want to freeze. For example, to freeze the first three rows, click cell A4 and then Freeze Panes.
How do I unfreeze panes on a Mac?
On Excel for Mac, go to the View tab, click Freeze Panes, and select Unfreeze Panes. The steps are nearly identical to Windows.
Why does my frozen row scroll away when I use the mouse wheel?
Make sure you have not accidentally split the window. Check View > Split and toggle it off. Also, ensure you are not in a table with a header row that scrolls differently; convert to a normal range if needed.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- How to Enable Privacy Indicators on Chromebook
- How to Calculate Taxes on Overtime Pay
- VPN Not Working on iPhone? Fixes That Actually Work
- Hide & Unhide Apps on Samsung Phones
- Fix DNS Server Unavailable Error in Windows 11
- Fix iOS 17 Keyboard Not Working Properly