Freeze Panes in Excel: Keep Rows and Columns Visible

How-to basics · Updated November 20, 2026

To keep headings or labels visible while you scroll in Excel, use View > Freeze Panes. Choose Freeze Top Row or Freeze First Column for a single edge, or select the cell below and to the right of the rows and columns you want to keep visible, then choose Freeze Panes.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows at the top of the window, columns at the left, or both, while the rest of the sheet scrolls. It is useful when a worksheet is wider or longer than the visible screen: you can inspect a value farther down the sheet without losing sight of the column headings, or move across columns while keeping row labels visible.

The feature changes how the worksheet is displayed, not the data itself. It does not lock cells against editing, protect a sheet, prevent someone from scrolling, or keep a row in place when you sort data. It also does not move or duplicate content. The frozen area remains visible as the worksheet’s scrollable area moves.

Freeze settings apply to the current worksheet, not automatically to every sheet in the workbook. You can choose different frozen rows or columns on different worksheets. The setting is part of the workbook view, so save the workbook if you want the arrangement to be there when it is reopened.

Freeze the Top Row or First Column

In Excel for Microsoft 365 on Windows, select the View tab, open Freeze Panes, and choose the option that matches the layout:

  • Freeze Top Row keeps worksheet row 1 visible as you scroll down.
  • Freeze First Column keeps worksheet column A visible as you scroll sideways.

These commands refer to the worksheet’s first row and first column, not whichever row or column happens to contain your headings. For example, if a report has a title in row 1 and its actual field names in row 3, Freeze Top Row will keep the title visible, not row 3. To keep row 3 visible instead, use the general Freeze Panes method and select a cell in row 4 before applying it.

To freeze both the top row and the first column, select cell B2, then choose View > Freeze Panes > Freeze Panes. Row 1 is above B2 and column A is to its left, so both remain on screen.

Freeze Several Rows or Columns

For a custom frozen area, first click the cell immediately below the last row to keep visible and immediately to the right of the last column to keep visible. Then choose View > Freeze Panes > Freeze Panes. Excel freezes all rows above the selected cell and all columns to its left.

For example, suppose a worksheet has two rows of headings and three left-hand columns containing an ID, a name, and a department. Select D3 and choose Freeze Panes. Rows 1 and 2 are above the selection, while columns A through C are to the left; those rows and columns stay visible as you scroll through the remaining records.

Selection matters: selecting D3 does not freeze row 3 or column D. It freezes the areas before that cell. If you select A4, you freeze rows 1 through 3 but no columns. If you select C1, you freeze columns A and B but no rows. A quick way to check your choice is to identify the boundary: the frozen rows are above the active cell, and the frozen columns are to its left.

Choose What to Freeze

Freeze only the information that helps you interpret the moving data. A single header row and perhaps one or two identifying columns are often enough. Freezing many rows or columns can leave little room for the worksheet itself, especially on a small display.

  • For a long list of transactions, freeze the row containing field names so values remain associated with the correct headings.
  • For a wide schedule, freeze the column containing employee or project names so each date or task can still be identified.
  • For a report with multiple heading rows and several identifiers, use a cell below and to the right of the complete block you need to retain.
  • If the headings are not in row 1, use the custom method rather than Freeze Top Row.

It can help to scroll to the point where you expect to work before setting the panes. Confirm that the intended rows and columns are visible and that the remaining area is large enough to read. If the frozen region is too large, unfreeze it and make a smaller selection.

Unfreeze or Change the Frozen Area

Excel allows one freeze-pane arrangement at a time on a worksheet. To remove the current arrangement, select View > Freeze Panes > Unfreeze Panes. The worksheet returns to ordinary scrolling. To create a different arrangement, unfreeze first, select the cell that defines the new boundary, and apply Freeze Panes again.

Choosing Freeze Top Row or Freeze First Column when another pane arrangement is already active may not produce the new layout you expect. The reliable sequence is to unfreeze the existing panes and then choose the new option. If you are adjusting several worksheets, repeat the steps on each sheet; changing one sheet does not reset the others.

Unfreezing does not delete, hide, or rearrange worksheet data. It only removes the fixed screen area. If a row or column seems to have disappeared, check whether it is hidden or outside the current scroll position; unfreezing panes does not unhide worksheet rows or columns.

Freeze Panes and Split Are Different

Freeze Panes and Split can both divide the worksheet window, but they are intended for different ways of viewing data. Freezing keeps selected rows at the top and columns at the left while the main worksheet area scrolls. A split creates separate panes that can be scrolled independently, which is useful when you want to compare distant parts of the same worksheet at once.

For example, a frozen header remains fixed while you scroll down a long table. With a split, you could instead scroll one pane to a later section while another pane remains positioned elsewhere. A split is not a substitute for a fixed table heading if the goal is simply to keep that heading visible as you move through the records. If you see a dividing line or independently moving sections you did not intend, check the View tab for Split and turn it off if appropriate.

Common Problems and Fixes

  • The wrong row stays visible: Freeze Top Row always means row 1. Unfreeze, select a cell below the heading you need, and apply Freeze Panes.
  • The wrong columns are frozen: Excel freezes columns to the left of the selected cell. To freeze A through C, select a cell in column D before choosing Freeze Panes.
  • The worksheet has too little room: Too many frozen rows or columns can crowd the scrolling area. Unfreeze and choose a boundary closer to the top-left corner.
  • The command appears unavailable: Finish editing a cell by pressing Enter or Esc, and check that the worksheet is in Normal view rather than Page Layout view. The ribbon layout can also be collapsed, so expand the View tab if needed.
  • A pane line remains after unfreezing: The line may be a split rather than a freeze boundary. Check View > Split and remove the split if it is active.
  • Frozen panes do not follow a heading after sorting: Freeze Panes fixes a screen position, not a particular record. Sorting changes where records appear; make sure the table is sorted as intended and that the desired headings are still in the frozen rows.

Excel on Mac and in a Browser

In Excel for Microsoft 365 on Mac, use the View tab and its Freeze Panes controls; the same basic rule applies: the selected cell determines which rows above and columns to the left are frozen. Ribbon wording and layout can vary somewhat by release, but the options are under View. If you use Excel for the web, look under View for Freeze Panes and choose the available row, column, or custom-pane option. The browser interface may place the command differently from the Windows desktop ribbon.

If you do not see an option in your current Excel interface, check that you are editing the workbook in Excel rather than a preview-only viewer, and that the relevant worksheet is active. On a shared workbook, freezing panes changes the view rather than the underlying cell values; collaborators may still need to set their own view depending on the way the file is opened and the Excel experience they use.

Frequently Asked Questions

How do I freeze the first two rows in Excel?
Click cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible because both are above the selected cell.

How do I freeze the top row and first column at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. The row above and column to the left of B2 stay visible.

Can I freeze a row that is not at the top?
Yes. Select a cell in the row immediately below the row or rows you want to keep visible, then use Freeze Panes. Excel freezes all rows above that cell, so intermediate rows are included too.

Why does Freeze Top Row keep the wrong heading?
That command freezes worksheet row 1, even if your actual headings are lower down. Use the custom Freeze Panes method, selecting a cell immediately below the real heading row.

How do I remove frozen panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the fixed rows and columns but does not change or delete worksheet data.

Related

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.