Freeze Panes in Excel: Keep Rows and Columns Visible

To freeze panes in Excel for Microsoft 365 on Windows, select the cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel keeps the rows above and columns to the left of that cell on screen as you scroll; choose View > Freeze Panes > Unfreeze Panes to undo it.

What Freeze Panes Does

Freeze Panes keeps chosen worksheet rows, columns, or both in view while the rest of the sheet moves. It is especially useful when a table is longer or wider than the visible window. A heading row can remain visible while you inspect records far below it, and identifying columns can stay put while you move across many fields.

The feature changes how you view and navigate a worksheet; it does not rearrange, hide, or lock the underlying data. Frozen cells remain part of the same worksheet, and formulas and values continue to work normally. The frozen area is separated from the scrolling area by a thin line, which helps show where the fixed rows or columns end.

Freeze Panes applies to the current worksheet, not automatically to every sheet in the workbook. If a workbook has several data tabs, set up the view on each one where it is useful. Freezing panes also does not make a heading repeat on printed pages; print settings control that separately.

Freeze a Header Row or the First Column

Excel provides quick commands for the two most common cases. On Windows, open the View tab and use the Freeze Panes menu:

Choose Freeze Top Row to keep row 1 visible while scrolling down. This is useful when the column labels are in the first row.
Choose Freeze First Column to keep column A visible while scrolling horizontally. Use it when that column contains names, dates, product codes, or another identifier.

These commands are convenient, but they target only the top row or first column. If the labels start lower down, or you need more than one column fixed, use the main Freeze Panes command with a deliberately selected cell instead. For example, if your labels are on row 3, selecting A4 and choosing Freeze Panes keeps rows 1 through 3 visible. Excel freezes every row above the selected cell, not only the row that contains labels.

Freeze Rows and Columns Together

To keep both headings and identifiers visible, select the cell immediately below the last row and immediately to the right of the last column you want fixed. Then choose View > Freeze Panes > Freeze Panes. The active cell marks the boundary: everything above it and everything to its left stays in place.

For example, imagine a worksheet with two heading rows and customer names in column A and account numbers in column B. Select C3, then freeze panes. Rows 1 and 2 and columns A and B remain visible as you scroll through the records. To keep four heading rows and the first three columns fixed, select E5 before choosing Freeze Panes. This pattern works for any number of rows and columns, subject to the size of the worksheet window.

Before freezing, check the selected cell in the Name Box or the row and column labels. Selecting C2 instead of C3 in the first example would freeze only row 1, while selecting B3 would freeze only column A as well as the two rows above. If the result is wrong, unfreeze and repeat the operation with the correct boundary cell.

How to Choose What to Freeze

The right arrangement depends on what a reader needs to identify while moving through the data. Freeze as little as possible while preserving useful context. A large fixed area takes space away from the part of the worksheet you are trying to inspect, particularly on a laptop display or in a narrow window.

Freeze one heading row when a simple list has its field names in row 1.
Freeze more than one row when the sheet has a title, notes, or multiple header levels above the records.
Freeze the first column when row labels or names need to remain visible during horizontal scrolling.
Freeze several columns when a record is identified by more than one field, such as region and customer name.
Freeze rows and columns together when the worksheet is both tall and wide, and both types of labels are needed to interpret a cell.

Think about the specific cell you will be trying to understand at the far edge of the data. If you scroll to column M and row 200, will the frozen labels still tell you what that value represents? If the answer is yes, the boundary is probably useful. If the frozen region hides too much of the worksheet, reduce it or consider a different way to structure the data.

Unfreeze, Change, or Check the Pane Layout

Excel offers one freeze-pane arrangement at a time on a worksheet. To replace it, first choose View > Freeze Panes > Unfreeze Panes. Then select a new boundary cell and apply Freeze Panes again. You do not need to delete or move any worksheet content to change the view.

If the sheet appears divided by a line but does not behave as expected, check whether Split is active. Split divides the worksheet window into separately scrollable sections; it is a different feature from Freeze Panes. Use View > Split to toggle a split layout off, then set the frozen rows or columns you actually need. A split can be useful for comparing distant parts of a sheet, but it is not usually the right choice for keeping column labels in view while scrolling a table.

To confirm what is fixed, scroll down and sideways. Frozen headings should stay in place while the worksheet content moves in the unfrozen region. If the wrong area remains visible, choose Unfreeze Panes and select the correct cell again. The frozen boundary can also be hard to notice if the worksheet is zoomed out or the window is very large, so test the view using a cell well beyond the frozen area.

Freeze Panes Versus Printing and Other Features

Freezing panes affects the on-screen worksheet view; it does not repeat rows on each printed page. If a report spans multiple pages and needs its column headings repeated in print, use Page Layout > Print Titles. In the Page Setup dialog, specify the row or rows to repeat at the top. That print setting solves a different problem and can be used whether or not panes are frozen.

Freeze Panes is also different from hiding rows or columns. Hidden content is removed from view until it is unhidden, whereas frozen content remains visible and the rest of the sheet scrolls around it. It is not the same as protecting a worksheet, either: freezing panes does not prevent another person from editing cells. For a long list, filters and Excel tables can help sort or narrow records, but they do not replace freezing useful headings when you scroll.

These distinctions matter when a workbook is shared or prepared as a report. A reader may need fixed headings while exploring the file, repeated headings on printed pages, and protection against accidental edits. Those are three separate needs, so each requires its own feature or setting.

Common Problems and Practical Fixes

If Freeze Panes seems to freeze the wrong rows or columns, the usual cause is the selected cell. Remember that Excel fixes all rows above and all columns to the left; it does not infer which cells contain headings. Unfreeze the panes, select the boundary cell again, and apply the command. For a top row plus the first two columns, for instance, choose C2.

The heading disappears when scrolling: confirm that the heading is in the frozen area. If it is on row 2, Freeze Top Row alone will not keep it visible; select A3 and choose Freeze Panes.
Too much of the screen is fixed: unfreeze and choose a cell closer to A1. Frozen rows and columns take up screen space even when the worksheet is scrolled.
The line or scrolling looks unusual: check whether Split is on, and turn it off if you do not want independently moving sections.
The command appears unavailable: finish editing the current cell by pressing Enter or Esc, then try the View tab again. Also check that you are working in the intended worksheet window.
The setting is missing on another tab: freeze panes are set separately for each worksheet, so apply the arrangement on that sheet as well.

On a small screen, a frozen area that works well on a desktop monitor may leave too little room for data. You can temporarily unfreeze panes while reviewing the sheet and restore them later. If several people use the workbook, explain the fixed area in a note or clear heading structure so the view is not mistaken for hidden or missing data.

Excel on Mac and in a Web Browser

In Excel for Microsoft 365 on Mac, use the View tab or View menu and choose Freeze Panes, then select the appropriate freeze command. The exact placement can differ slightly with the Excel interface version, but the selection rule is the same: Excel freezes rows above and columns to the left of the active cell. To remove the setting, use the Unfreeze Panes command in that same menu.

In Excel for the web, open the View tab and use Freeze Panes. The browser version provides freezing options for worksheet rows and columns, though available interface details can vary as Microsoft updates the service. If a particular command is not visible in your browser, check the View tab or open the workbook in the desktop app. The Windows ribbon path in this guide is for Excel for Microsoft 365 desktop.

Keyboard access can vary with the platform, keyboard layout, and current Excel interface, so the ribbon command is the clearest general instruction. On Windows, pressing Alt can display KeyTips for navigating ribbon commands; the letters shown on screen are the ones to follow in that installation. On Mac, use the View menu or ribbon rather than assuming a Windows Alt sequence applies.

Frequently Asked Questions

Can I freeze the top two rows in Excel?
Yes. Select A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible because both are above the selected cell.

Can I freeze the first two columns and the top row?
Yes. Select C2 and choose View > Freeze Panes > Freeze Panes. The rows above and columns to the left stay fixed, so row 1 and columns A and B remain visible.

Why does Freeze Top Row not keep my heading visible?
Freeze Top Row fixes only worksheet row 1. If your actual headings are in a lower row, select the cell immediately beneath them in column A and use the main Freeze Panes command.

Does Freeze Panes affect every worksheet in a workbook?
No. It applies to the active worksheet. Set up the view separately on each sheet where fixed rows or columns are useful.

How do I make frozen headings appear on every printed page?
Use Page Layout > Print Titles and set the rows to repeat at the top in Page Setup. Freeze Panes is for on-screen scrolling and does not control printed page headings.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.