Excel: Freeze the Top Row and First Column

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel will keep row 1 and column A visible while you scroll through the rest of the worksheet.

What freezing both keeps visible

Freeze Panes divides the worksheet into a stationary area and a scrollable area. With B2 selected before you apply the command, the stationary area is the top row and the first column: row 1 stays at the top as you scroll down, and column A stays at the left as you scroll right. The rows below row 1 and columns to the right of column A continue to move normally.

This is useful when a table has column headings across the top and identifying information down its left side. For example, a sales sheet might have months in row 1 and product names in column A. After freezing both, you can inspect a product’s figures in later months without losing either the month labels or the product name.

Freezing changes the worksheet’s on-screen scrolling behavior; it does not lock cells, protect data, or change the order of the rows and columns. It is a view setting, not a way to prevent edits. That distinction matters when you need to keep labels visible for navigation but still want to enter or change values in the worksheet.

Steps in Excel for Microsoft 365 on Windows

  1. Open the worksheet you want to adjust.
  2. Select cell B2. If the Name Box is visible to the left of the formula bar, you can click it, type B2, and press Enter to move directly to that cell.
  3. On the ribbon, select View > Freeze Panes > Freeze Panes.
  4. Scroll down and to the right to confirm that the headings in row 1 and labels in column A remain visible.

Choose the first command named Freeze Panes in the menu, not Freeze Top Row or Freeze First Column. Those latter commands apply just one of the two simple presets. The general Freeze Panes command uses the active cell to decide which rows and columns to keep stationary, so selecting B2 is what makes it freeze both at once.

If you have already frozen something, Excel may show Unfreeze Panes in the menu. Choose that first, then select B2 and apply Freeze Panes again. Excel maintains one freeze arrangement at a time; you cannot add a second independent freeze by applying another preset afterward.

Why cell B2 is the right selection

Excel uses the active cell as a boundary. When you choose Freeze Panes, it freezes every row above that cell and every column to its left. The active cell itself and the cells below and to its right remain in the scrolling area.

  • Select B2 to freeze row 1 and column A.
  • Select C3 to freeze rows 1 and 2, plus columns A and B.
  • Select A2 to freeze row 1 without freezing any columns.
  • Select B1 to freeze column A without freezing any rows.

These examples assume the worksheet begins at its normal upper-left corner. The same boundary rule is useful for larger headers: if a table uses its first two rows for headings and its first column for names, select B3 before choosing Freeze Panes. Excel keeps the rows and columns above and to the left of that boundary in place.

There is an important detail: selecting B2 does not freeze the cell B2 itself as a special object. It establishes the horizontal and vertical dividing lines between the fixed labels and the scrollable data. If the active cell is somewhere else when you choose the command, Excel will use that other position instead.

Choosing the right freeze option

For only one heading row, use View > Freeze Panes > Freeze Top Row. For only the leftmost identifying column, use View > Freeze Panes > Freeze First Column. These options are quick when a worksheet needs just one fixed edge.

Use the general Freeze Panes command when you need both row and column labels, or when you need more than one row or column to stay visible. The three choices are alternatives, not cumulative switches. For instance, choosing Freeze Top Row and then choosing Freeze First Column does not reliably build a combined freeze; the second preset changes the current arrangement. To keep both, clear any existing freeze, select the cell just below and to the right of the area you want fixed, and choose Freeze Panes.

Think about how far readers will scroll before deciding how many headings to keep. Freezing too many rows or columns can leave little room for the data, especially on a small laptop display. A compact title row and one identifier column are often enough; a multirow report header may justify a deeper frozen area.

Excel for Mac and Excel for the web

In Excel for Mac, the same selection principle applies: click B2, then use View > Freeze Panes > Freeze Panes. Menu presentation can differ slightly between releases, but choose the general Freeze Panes command for a custom row-and-column boundary. To remove it, use View > Freeze Panes > Unfreeze Panes.

Excel for the web also has freeze controls on the View tab. Select B2 and use the Freeze Panes option to set the boundary, or choose the top-row or first-column preset when you need only one. The exact menu presentation can vary as Microsoft updates the web interface. If the command is unavailable or the worksheet is in a restricted view, open it in the desktop app and set the freeze there.

Freezing panes is a worksheet view choice, so do not assume that setting it on one worksheet automatically sets it on every sheet in a workbook. Check each worksheet where the same scrolling behavior is needed. When sharing a workbook, it is also sensible to save it after setting the view so the intended starting view is retained for recipients; their own app or view settings may affect what they see.

Common problems and how to fix them

  • The wrong rows or columns are frozen: Choose View > Freeze Panes > Unfreeze Panes, select the correct boundary cell, and apply Freeze Panes again.
  • Only the top row or only the first column is frozen: Clear the current setting and use the general Freeze Panes command with B2 selected. The preset commands do not combine into a custom freeze.
  • The headings seem to disappear: Check whether you are scrolling within the intended worksheet and whether the freeze is still enabled. Also check that row 1 or column A actually contains the labels you meant to keep visible.
  • The frozen area takes up too much room: Unfreeze the panes and choose a closer boundary, such as B2 instead of C5. Excel freezes all rows above and columns to the left of the active cell, so a cell far down or right creates a large stationary area.
  • The freeze command is disabled or behaves unexpectedly: Confirm that you are in a normal worksheet view and not editing a cell. Some workbook protection or shared editing situations can limit available actions; if necessary, check the workbook’s permissions or try the command in the desktop app.

A related misconception is that freezing the first row keeps the first row of a table visible wherever that table begins. The Freeze Top Row preset refers to worksheet row 1, not a table’s header row if the table starts farther down the sheet. For a header at row 5, select the cell below the intended frozen rows and to the right of the intended frozen columns, then use Freeze Panes.

Freeze Panes, Split, and printed headings

Freeze Panes is designed to keep selected worksheet rows and columns stationary while you scroll. Split is a different viewing tool: it divides the worksheet window into independently scrollable panes. That can help compare distant sections of a large sheet, but it does not serve the same simple purpose as keeping the top headings and left labels fixed in one continuous view.

Neither feature determines what appears on printed pages. If a long worksheet should repeat its headings on each printed page, use the print-title settings rather than relying on frozen panes. In Excel for Windows, the page setup controls include Page Layout > Print Titles, where you can specify rows to repeat at the top or columns to repeat at the left. Print preview is the right place to confirm the result. A row frozen on screen does not automatically repeat on paper.

These distinctions help avoid choosing a view feature for a print-layout problem. Use Freeze Panes for scrolling through a worksheet, Split for independent viewing areas, and print titles for repeated labels on printed pages.

Practical examples

In a budget worksheet, column A might list expense categories and row 1 might contain months. Freezing at B2 lets you scroll to later months or lower categories while retaining both sets of context. In an inventory list, the first column could contain item codes and the top row could contain fields such as quantity, location, and status; freezing both makes a wide and long list easier to scan.

For a report with two heading rows, such as a title row followed by field names, select B3 to keep both rows and column A fixed. If the data starts in column C because columns A and B contain identifiers, select C2 to keep the first row and both identifier columns in view. The goal is to place the active cell at the upper-left corner of the part that should scroll.

Before sharing a complicated worksheet, test the arrangement by moving both scrollbars. Confirm that the frozen labels are useful at typical viewing sizes and that the stationary region does not hide too much of the data. If the sheet is also printed, inspect print preview separately because the on-screen freeze and printed-page settings are independent.

Frequently Asked Questions

Can I freeze the top row and first column at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The top row and column A will stay visible as you scroll.

Why does Freeze Top Row not also freeze the first column?
Freeze Top Row is a preset for row 1 only. To freeze a row and a column together, select the cell just below and to the right of the desired fixed area and use the general Freeze Panes command.

How do I unfreeze rows and columns in Excel?
Choose View > Freeze Panes > Unfreeze Panes. Then select a new boundary cell and choose Freeze Panes if you want to set a different arrangement.

Can I freeze a table’s header row if it is not worksheet row 1?
Yes, but use a custom boundary rather than the Freeze Top Row preset. Select the cell immediately below the rows to keep and immediately to the right of the columns to keep, then apply Freeze Panes.

Does freezing panes make the headings repeat when I print?
No. Frozen panes affect scrolling on screen. To repeat headings on printed pages, set rows or columns to repeat through the worksheet’s print-title or page setup controls, then verify the layout in print preview.

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.