Freeze in Excel: Keep Rows and Columns Visible

How-to basics · Updated November 20, 2026

To freeze rows or columns in an Excel spreadsheet, select the cell just below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For a quick preset, choose View > Freeze Panes > Freeze Top Row or Freeze First Column.

How freezing panes works

Freezing panes keeps selected rows at the top of the worksheet or selected columns at the left while you scroll through the rest of the sheet. The frozen area stays visible on screen; it does not change the values, layout, or order of your data. This is useful when a long list has headings that would otherwise scroll out of view, or when labels in the first columns identify each row.

Excel determines what to freeze from the active cell when you use the main Freeze Panes command. It freezes every row above that cell and every column to its left. The cell itself becomes the first cell in the scrollable area. For example, if you select C4 and choose Freeze Panes, rows 1 through 3 and columns A and B remain visible. You can scroll down and right through the other cells while keeping those headings and identifiers in view.

A worksheet can have one frozen-pane arrangement at a time. The line separating the frozen area from the scrolling area helps show where the boundary is. Freezing affects only the current worksheet, so you can set a different arrangement on another sheet in the same workbook.

Freeze the top row for column headings

If your column labels are in row 1, use the top-row preset. This keeps that row visible as you move down a table or list, making it easier to tell whether a number belongs to a date, price, status, or other field.

  1. Open the worksheet you want to adjust.
  2. Select the View tab on the ribbon.
  3. Choose Freeze Panes, then choose Freeze Top Row.
  4. Scroll down to confirm that row 1 stays in place.

The preset is intended for the worksheet’s first row. If your headings start lower down—for example, because the sheet has a title and notes in rows 1 and 2—select the first cell below the actual heading rows and use the main Freeze Panes command instead. Selecting A4, for instance, freezes rows 1 through 3. That also keeps any title or notes in those rows visible, so consider whether they need to remain on screen.

Freeze the first column

When the first column contains names, product IDs, or other row labels, the First Column preset keeps column A visible while you scroll horizontally. On the View tab, choose Freeze Panes, then Freeze First Column. Move the horizontal scroll bar to the right to check that the labels remain on screen.

This preset freezes only column A. If the identifying information spans columns A and B, or if column A is not the column you need to keep visible, use the main Freeze Panes command with a carefully chosen active cell. To freeze columns A and B, select a cell in column C; the row number of that cell determines which rows, if any, are frozen too. Selecting C1 freezes the two columns without freezing any rows.

Freeze multiple rows and columns together

To keep several heading rows and several left-hand columns visible at the same time, select the cell immediately below and to the right of the areas you want frozen. Then choose View > Freeze Panes > Freeze Panes. The selection is a boundary: everything above it and everything to its left is held in place.

  • To freeze rows 1 and 2, but no columns, select A3.
  • To freeze columns A and B, but no rows, select C1.
  • To freeze rows 1 through 3 and columns A and B, select C4.
  • To freeze row 1 and columns A through C, select D2.

After setting the panes, scroll both down and to the right. This confirms that the intended headings and labels stay visible, and that the rest of the sheet remains accessible. If the boundary is not what you expected, unfreeze the panes and repeat the selection; choosing a different cell after panes are frozen does not revise the existing boundary.

Choose a useful freeze arrangement

The best setup depends on how readers move through the worksheet. A simple sales list with headings in the first row usually needs only Freeze Top Row. A wide inventory sheet may benefit from keeping item codes at the left and headings at the top. A report with a title, a date range, and two heading rows may need more rows frozen, but keeping too much of the screen fixed can leave little room for the data.

Before choosing a boundary, identify the information someone needs to interpret a visible cell. If a person scrolling to row 500 needs the column names and the customer name in column A, freeze the heading row and column A. If they also need a region in column B, freeze both left-hand columns. Avoid freezing empty rows or columns just because they are above or beside the selection: Excel freezes the whole area before the active cell, including blanks.

Try the layout at the screen size and zoom level people are likely to use. A configuration that works on a large monitor may cover too much of a smaller laptop display. Frozen panes are a viewing aid, not a substitute for clear labels, sensible column widths, or a well-organized data table.

Unfreeze panes or change the boundary

To remove an existing freeze, go to View > Freeze Panes > Unfreeze Panes. Excel returns the worksheet to normal scrolling. You can then select a new boundary cell and apply Freeze Panes again. The Freeze Panes menu may show the available freeze or unfreeze command depending on the current state of the worksheet.

Unfreezing does not delete rows, columns, or data. It only changes how the worksheet scrolls on screen. If the sheet appears stuck because a frozen section is taking up too much space, unfreeze it and create a smaller frozen area. If you are unsure what is fixed, look for the boundary line and test scrolling horizontally and vertically.

Common problems and quick fixes

  • The wrong rows or columns stay visible: The active cell was probably not at the intended boundary. Unfreeze, select the cell below and to the right of the desired frozen area, then apply Freeze Panes.
  • Only the top row or first column is frozen: A preset was used. For a custom combination, use the main Freeze Panes command after selecting the correct boundary cell.
  • The command is unavailable or looks different: Check that you are on the View tab and in Normal view. Ribbon layouts can vary slightly between Excel versions, but Freeze Panes is a View command in Excel for Microsoft 365.
  • The sheet still scrolls in one direction: That is expected. Freezing selected rows prevents them from scrolling vertically; freezing selected columns prevents them from scrolling horizontally. The unfrozen area can still move.
  • A line appears across or down the worksheet: It marks the edge of the frozen area. It is not a border added to your cells and will not print as a cell border.

Also distinguish frozen panes from protected cells. Freeze Panes does not prevent someone from editing or deleting data, and it does not secure a workbook. If you need to limit edits, use worksheet protection separately. Likewise, freezing a heading on screen does not automatically repeat that heading on printed pages; print settings handle that separately.

Freeze Panes, Split, and print titles are different

Freeze Panes is designed to keep a chosen set of rows or columns visible while the rest of the worksheet scrolls. Split, available from the View tab, divides the worksheet window into separate panes that can be scrolled independently. A split is useful for comparing distant parts of the same sheet, but it is not the same as keeping a heading row fixed above one continuous scrolling area. If the goal is simply to retain column headings while browsing, Freeze Panes is usually the more direct choice.

Print Titles solve a different problem: they repeat selected rows or columns on printed pages. A frozen row may be visible while working in Excel but is not automatically repeated on every printed page. To set repeated print headings in desktop Excel, use Page Layout > Print Titles and specify the rows to repeat at top or columns to repeat at left in the Page Setup dialog. Check Print Preview to confirm the result.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, use the View tab and its Freeze Panes menu as described above. In Excel for Mac, the command is also available from the View tab, although the ribbon arrangement can differ. Select the boundary cell first when you need a custom combination of rows and columns, then use the Freeze Panes command rather than assuming a preset will retain the other frozen area.

Excel for the web also includes freeze options under View. The precise menu presentation can differ from the desktop app, but the key idea remains the same: select the cell below and to the right of the areas to keep visible, then freeze panes at that selection. If you do not see the same controls, check that you are editing the workbook in Excel rather than viewing a read-only preview.

Frequently Asked Questions

Can I freeze more than one row in Excel?
Yes. Select the first cell in the row immediately below the rows you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Selecting A4 freezes rows 1 through 3.

Can I freeze rows and columns at the same time?
Yes. Select a cell below the rows and to the right of the columns you want to freeze. For example, selecting C4 and choosing Freeze Panes keeps rows 1 through 3 and columns A and B visible.

Why does Freeze Panes keep the wrong area visible?
The command uses the active cell as the boundary. Unfreeze the current panes, select the cell immediately below and to the right of the intended frozen area, and apply Freeze Panes again.

Does freezing panes lock cells from editing?
No. It only affects scrolling and what remains visible on screen. Use worksheet protection if you need to restrict edits; freezing alone does not protect data.

Will a frozen header repeat when I print?
Not automatically. Set repeating headings separately with Page Layout > Print Titles, then review the pages in Print Preview. Freeze Panes controls the on-screen worksheet view.

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.