How to Freeze Panes in Excel: Lock Rows, Columns, and Both

Freezing panes in Excel keeps specific rows or columns visible on screen while you scroll through a large spreadsheet. Without frozen panes, when you scroll down through hundreds of rows of data, the header row disappears off the top of the screen and you lose track of which column each number belongs to. With frozen panes, the header row stays in place no matter how far down you scroll — the data moves but the labels don't. The same logic applies horizontally: freeze the first column, and it stays visible while you scroll right through many columns of data.

This feature is especially valuable in large spreadsheets with more rows or columns than fit on a single screen — financial models with 50 columns, data tables with thousands of rows, comparison reports spanning multiple months or products. Working without frozen headers in these contexts means constant scrolling back to the top to remember what each column means, which slows down work and increases the chance of entering data in the wrong column.

Freeze panes is a view setting, not a data change — it doesn't modify the content of the spreadsheet, doesn't affect formulas, and doesn't change what gets saved or printed unless you configure it to. It affects how the sheet looks on your screen (and on other users' screens when they open the same file), but the data itself is unchanged. You can freeze and unfreeze panes at any time without risking any data.

A common point of confusion: freezing panes and locking cells are different features that do different things. Freezing panes keeps rows or columns visible during scrolling. Locking cells (via Format Cells > Protection > Locked, combined with worksheet protection) prevents those cells from being edited. You can freeze a header row without locking it, and you can lock cells without freezing them.

They're found in different places and serve different purposes — freeze panes is in the View tab, and cell locking is in the Format menu and Review tab. For reference on the cell locking mechanism that complements freeze panes in multi-user spreadsheets, the how to freeze panes in excel guide to freezing the top row covers the single-row freeze option in detail.

This guide covers every freeze panes scenario: freezing the top row only, the first column only, multiple rows, multiple columns, and combinations of rows and columns simultaneously, on both Windows and Mac.

If you work regularly with financial models, project trackers, or data entry sheets, learning how to freeze panes in Excel is one of the highest-impact skills you can develop. The payoff is immediate: once headers stay visible, data entry errors caused by misidentifying the wrong row or column drop significantly, and navigating large datasets becomes substantially less frustrating.

How to Freeze the Top Row in Excel

The simplest and most common freeze panes use case is locking the first row — the header row — so it stays visible while scrolling down through data. To do this, go to the View tab on the ribbon and click Freeze Panes. A dropdown menu appears with three options: Freeze Panes, Freeze Top Row, and Freeze First Column. Click Freeze Top Row. A thin line appears below row 1 indicating the freeze boundary, and the top row is now locked. Scroll down and the header stays put regardless of how far down you go.

On Mac, the same options appear in the View menu under Freeze Rows and Columns. In Excel Online, go to the View tab and look for Freeze. The interface differs slightly across versions, but the underlying behavior is identical.

The keyboard shortcut for accessing freeze panes options in Windows Excel is Alt+W+F — this opens the Freeze Panes dropdown in sequence. You can then press F for Freeze Panes, R for Freeze Top Row, or C for Freeze First Column. These shortcuts are useful if you frequently work with large datasets and switch freeze states regularly.

Once the top row is frozen, it behaves independently of the rest of the sheet during scrolling. You can still edit cells in the frozen row, type new content, change formatting, or apply formulas — freezing only affects visibility during scrolling, not editability. If you want to prevent editing in the header row as well, that requires worksheet protection on top of (and independent of) the freeze setting.

One practical use of top-row freezing: if you apply AutoFilter to your data (Data > Filter), the filter dropdowns appear in the header row. With the top row frozen, filter dropdowns remain accessible at the top of the screen even when you've scrolled down to see the filtered results — you can adjust filter criteria without scrolling back to the top. For comprehensive navigation shortcuts that work alongside freeze panes to move efficiently through large spreadsheets, the how to freeze panes in excel guide to freezing cells covers column and combined row-column freeze options.

Understanding when to freeze rows versus columns versus both requires thinking about how your data is structured. Horizontal datasets with many columns benefit most from freezing the first column so row labels remain anchored as you scroll right. Vertical datasets with many rows benefit from freezing the top row. Complex dashboards with both dimensions benefit from freezing both simultaneously at the intersection cell.

How to Freeze Multiple Rows or Columns

Freezing more than the top row requires a different approach than the "Freeze Top Row" shortcut. To freeze multiple rows, you need to select the cell that marks the boundary of the freeze: click on the first cell of the row BELOW the rows you want frozen. If you want rows 1 and 2 frozen, click on cell A3. If you want rows 1 through 5 frozen, click on A6. Then go to View > Freeze Panes > Freeze Panes (the first option, not "Freeze Top Row"). Excel freezes everything above the row containing the selected cell.

The same logic applies to freezing multiple columns. To freeze columns A and B, click on cell C1. To freeze the first five columns, click on F1. Then View > Freeze Panes > Freeze Panes. Everything to the left of the selected cell's column gets frozen. A vertical freeze line appears at the boundary.

To freeze both rows and columns simultaneously, click on the cell that sits at the intersection point — the cell directly below the last row you want frozen AND directly to the right of the last column you want frozen. If you want rows 1-2 frozen and columns A-B frozen, click on cell C3. Then View > Freeze Panes > Freeze Panes. Both a horizontal freeze line (below row 2) and a vertical freeze line (to the right of column B) appear, and scrolling in any direction keeps both the frozen rows and columns visible.

The cell selection determines the freeze boundary — this is the most important concept to understand. The "Freeze Panes" option always freezes everything ABOVE and to the LEFT of the selected cell. If you select a cell that's inside the area you wanted to freeze, the result won't be what you expected. Go back to View > Freeze Panes > Unfreeze Panes, click the right cell, and reapply.

This mismatch between intended and actual freeze boundary is the most common freeze panes error. For context on how freeze panes interacts with the keyboard shortcuts that speed up large-spreadsheet navigation, the how to freeze panes in excel shortcuts guide covers navigation commands that work with frozen panes.

If you split panes (View > Split) before freezing, Excel treats the split windows as separate scrolling areas. Freeze panes and split view interact in ways that can produce unexpected results — if you have active splits when you try to freeze, Excel may convert the split into a freeze. Clear any active splits before applying freeze panes if you want predictable behavior.

One practical tip for workbooks you share with others: document your freeze settings in a notes cell or a separate instructions tab. When collaborators open the file and see a fixed header row, they may not realize it was intentionally frozen, and they may accidentally unfreeze it. A brief note helps preserve the intended viewing experience across different users and Excel versions.

Freeze Panes on Mac and Excel Online

Excel for Mac implements freeze panes in nearly the same way as Windows Excel. Go to the View menu (not the ribbon tab, but the menu bar View option on Mac) and look for Freeze Rows and Columns. The same three options appear: Freeze Rows and Columns (equivalent to Freeze Panes), Freeze Top Row, and Freeze First Column. The cell selection logic is identical: click the cell below and to the right of what you want frozen, then select the option. The freeze line appears on screen and the file saves the freeze state just like on Windows.

One Mac-specific note: older versions of Excel for Mac placed freeze panes under a different menu path. If you're on an older Excel for Mac version and can't find freeze options in the View menu, try the Format menu under "Row" or check if your ribbon has a View tab with freeze options. Modern Excel 365 for Mac has the freeze options clearly in the View menu and also accessible from the View ribbon tab if you're using the ribbon interface.

Excel Online (the browser-based version at office.com) supports freeze panes with some limitations. The freeze options are accessible through the View tab in the ribbon. Freeze Top Row and Freeze First Column work identically to the desktop app. Freezing multiple rows or columns works the same way — select the appropriate cell and use View > Freeze Panes.

However, some users find that freeze settings applied in Excel Online don't always persist reliably when the file is later opened in the desktop app, particularly for complex freeze configurations. For freeze settings that need to be consistent across desktop and browser use, it's worth opening the file in the desktop app to apply or verify the freeze configuration. The how to freeze panes in excel guide to Excel spreadsheets covers broader spreadsheet organization principles including when freeze panes is most valuable.

Mobile Excel apps (iOS and Android) display frozen rows and columns correctly when a freeze was set in the desktop app, but the ability to apply or change freeze settings may be limited or absent depending on the app version. Most mobile Excel use involves viewing and light editing rather than spreadsheet configuration, so the read-only display of frozen panes on mobile is usually sufficient for the use case.

Excel Online has been improving its freeze panes support over successive updates. If a feature described in this guide is missing from your browser-based version, check that your browser is up to date and that you are using the full editing mode rather than a read-only or embedded view. Some institutional Microsoft 365 deployments also restrict certain worksheet settings at the admin level.

How to Unfreeze Panes and Troubleshooting

To remove freeze panes, go to View > Freeze Panes > Unfreeze Panes. This single option removes all freeze settings simultaneously — you can't selectively remove just the row freeze while keeping the column freeze. If you want to change a freeze configuration, you need to unfreeze completely and then reapply with the new cell selection. On Mac, the option appears as View > Unfreeze Rows and Columns when any freeze is active.

The "Unfreeze Panes" option only appears in the dropdown when freeze panes are currently active. If you don't see it, either no freeze is currently applied or the workbook is in a protected or shared mode that prevents changes. If you can see the freeze line but can't access Unfreeze Panes, check whether the workbook is protected (Review tab > Protect Workbook or Protect Sheet) and whether structure protection is preventing changes to the view.

Freeze lines that appear in unexpected locations are the most common issue. If you clicked on A1 or had a range selected when you applied Freeze Panes, the freeze boundary may have been placed at row 1 or column A rather than where you wanted. The fix is always the same: View > Freeze Panes > Unfreeze Panes, click the correct cell (the one directly below the last row and directly to the right of the last column you want frozen), then View > Freeze Panes > Freeze Panes.

Frozen rows or columns that appear blank can indicate that the content in those cells has white text on a white background, or that the cells are hidden (row height or column width set to zero). The cells are there and frozen correctly — the content is invisible because of formatting. Select the frozen area and check the font color and row/column size to identify the issue.

Printing with frozen headers requires a separate configuration — freeze panes affects screen display only, not print output. To repeat header rows when printing, go to Page Layout > Print Titles and specify the rows to repeat at the top of each printed page. This is a separate setting from freeze panes and must be configured independently. For practice with the full range of Excel interface and navigation features, the how to freeze panes in excel cell locking guide covers the related protection features that pair with freeze panes in shared workbooks.

Once you have mastered freeze panes, consider combining it with Excel table formatting. Converting your data range to an official Excel table using Ctrl+T provides automatic header repetition when scrolling within the table view, which complements freeze panes nicely. Together, these two features create a navigation experience in large workbooks that keeps context visible and reduces the cognitive load of tracking data across hundreds of rows.