How to Freeze Rows and Columns in Excel

How-to basics · Updated November 20, 2026

To freeze rows or columns in Excel for Microsoft 365 on Windows, select the cell just below the rows and just to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For just the top row or first column, use View > Freeze Panes and choose the matching command. Frozen areas stay in view as you scroll; they do not change or lock the worksheet’s data.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of the worksheet, selected columns at the left, or both, while the rest of the sheet scrolls. It is useful when the information that explains a value—such as a column heading, product name, or date—would otherwise disappear as you move through a large worksheet.

For example, a sales worksheet might have a header row containing Date, Region, and Revenue, followed by hundreds of transactions. Freezing the top row lets you scroll down while still seeing which column contains each value. If the first column contains employee names, freezing that column lets you scroll horizontally while keeping each row identifiable.

Freezing is a viewing aid, not a way to protect information. It does not stop someone from editing cells, hide rows or columns, or keep a heading visible in a printed report. It applies to the current worksheet; other sheets can have their own freeze settings.

Choose the Right Freeze Option

The three commands suit different layouts. Excel’s Freeze Panes command is the flexible option: it uses the selected cell to determine which rows and columns remain fixed. The other two commands make common choices without requiring you to position the selection first.

  • Freeze Top Row: Keeps row 1 visible while you scroll vertically. Choose this when the worksheet’s headings are in the first row.
  • Freeze First Column: Keeps column A visible while you scroll horizontally. This is helpful when column A holds names, account IDs, or other row labels.
  • Freeze Panes: Keeps all rows above the selected cell and all columns to its left visible. Use it for multiple heading rows, multiple identifying columns, or a combination of both.

The built-in Top Row and First Column commands refer specifically to row 1 and column A. If your headings start lower down, or your identifying data is in another column, use Freeze Panes instead.

Freeze Multiple Rows or Columns

Excel decides what to freeze from the active cell’s position. The selected cell itself is not included in the frozen area: Excel freezes the worksheet rows above it and columns to its left. This rule makes it possible to freeze rows and columns together with one command.

  • To freeze rows 1 through 3 only, select cell A4, then choose View > Freeze Panes > Freeze Panes.
  • To freeze columns A and B only, select cell C1, then choose the same Freeze Panes command.
  • To freeze rows 1 through 3 and columns A and B, select cell C4, then choose View > Freeze Panes > Freeze Panes.

Check the selection before applying the command. For instance, selecting B4 freezes rows 1 through 3 and column A, not column B. If you choose a cell far into the worksheet by mistake, Excel may freeze more rows or columns than intended. You can unfreeze and repeat the process with the correct cell.

Step-by-Step on Windows

For a standard worksheet in Excel for Microsoft 365 on Windows, use these steps:

  1. Open the worksheet you want to adjust. Freeze settings are per worksheet, so select the correct sheet tab first.
  2. Click the cell below the last row you want frozen and to the right of the last column you want frozen. For rows only, use a cell in column A; for columns only, use a cell in row 1.
  3. Open the View tab on the ribbon.
  4. Choose Freeze Panes, then choose Freeze Panes in the menu. To freeze only row 1 or column A, choose Freeze Top Row or Freeze First Column instead.
  5. Scroll down or across to confirm that the intended headings or labels remain visible.

Excel usually indicates the boundary of a frozen area with a line in the worksheet. If the result is not what you expected, choose View > Freeze Panes > Unfreeze Panes and try again. The command’s name changes to Unfreeze Panes when a freeze is active.

Change or Remove a Freeze

You cannot add a second, independent freeze area on the same worksheet. To change which rows or columns are held in place, first choose View > Freeze Panes > Unfreeze Panes. Then select the cell that represents the new boundary and apply Freeze Panes again. For example, to replace a top-row freeze with a two-row freeze, unfreeze first, select A3, and freeze panes.

Unfreezing does not delete, move, or edit data. It simply returns the worksheet to ordinary scrolling. You can also switch from a custom Freeze Panes setting to Freeze Top Row or Freeze First Column by unfreezing the current setting first, then applying the desired command.

If you are reviewing a workbook and do not want to alter its saved view, consider whether you need to save after changing the freeze. Workbook view settings can be saved with the file, so saving may preserve your new arrangement for later sessions or for other people who open it.

Freeze Panes, Split, and Table Headers

Freeze Panes and Split both divide what you see in the worksheet, but they work differently. Freeze Panes keeps a defined set of rows at the top and columns at the left while the remaining worksheet scrolls. Split creates separate panes that can be scrolled independently. If you want the same headings to stay visible as you browse the rest of the sheet, Freeze Panes is generally the more straightforward choice. Use Split when you specifically need to compare distant parts of one worksheet at the same time.

Excel tables have a related behavior that can be mistaken for freezing. When you scroll down within a table, its column names can appear in the worksheet’s column-heading area in place of the usual letters. That table feature can make headings easier to read, but it is not the same as freezing worksheet rows: it does not keep arbitrary rows or left-side columns fixed. A table also does not automatically solve the problem of keeping identifying columns visible during horizontal scrolling.

Freezing is also different from hiding a row or column. Hidden content is removed from the visible grid until it is unhidden; frozen content remains visible in its normal position while other areas move. Neither operation changes what is printed unless you separately adjust print settings.

Common Problems and Fixes

  • The wrong rows or columns stay put: The active cell was probably in the wrong position. Unfreeze, then select the cell below and to the right of the intended frozen area before choosing Freeze Panes.
  • Only the first row or first column is frozen: Freeze Top Row and Freeze First Column are fixed shortcuts for row 1 and column A. Use the general Freeze Panes command for a different boundary or multiple rows and columns.
  • The command is unavailable or does not behave as expected: Finish editing the current cell by pressing Enter or Esc, then open the View tab again. Also check that you are on the worksheet you mean to change and that you are not expecting one sheet’s settings to apply to every sheet.
  • The freeze seems to have disappeared: Check whether the workbook was reopened in a different view or whether the setting was changed. Return to View > Freeze Panes to see whether the menu offers Unfreeze Panes.
  • Printed pages do not repeat the frozen heading: Freeze Panes controls on-screen scrolling, not print layout. Use the worksheet’s Page Layout print-title settings when you need rows or columns repeated on printed pages.

One practical check is to scroll both down and sideways after setting a freeze. A freeze created from cell C4 should keep rows 1 through 3 visible when scrolling vertically, columns A and B visible when scrolling horizontally, and both areas visible when moving diagonally through the sheet.

Excel for Mac and Excel for the Web

In Excel for Mac, the feature is also called Freeze Panes. Select the appropriate cell, then use the View tab and its Freeze Panes controls; the exact ribbon layout can vary with the Excel version and window size. The selection rule is the same: rows above and columns to the left of the active cell are frozen. Use the corresponding Unfreeze Panes command to remove the setting.

In Excel for the web, open the workbook in a browser, select the cell at the intended boundary, and use View > Freeze Panes. The available commands and their placement can differ somewhat from the desktop ribbon, but the basic selection logic is the same. If you do not see a particular control, check the View tab and the workbook’s current editing state. A workbook opened in a desktop app may show a slightly different interface, so follow the commands shown in that app.

Frequently Asked Questions

How do I freeze the top two rows in Excel?
First unfreeze any existing setting. Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible as you scroll down.

Can I freeze the top row and first column at the same time?
Yes. Unfreeze any current setting, select cell B2, and choose View > Freeze Panes > Freeze Panes. The row above and column to the left—row 1 and column A—stay visible.

Why can’t I freeze a row in the middle of the worksheet?
Freeze Panes keeps a continuous block from the top of the sheet, not an isolated middle row. Select the cell directly below the last row in the block you want to retain. Excel cannot freeze one separate row while allowing the rows above it to scroll normally.

Does freezing panes protect cells from editing?
No. It only affects scrolling and what remains on screen. To restrict changes, use worksheet protection separately; freezing a pane does not set a password or prevent edits.

How do I unfreeze panes in Excel?
On the worksheet with the freeze, choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or select a new boundary and apply Freeze Panes again.

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.