Excel Freeze Panes: Keep the Top Row and First Column

To keep both the top row and first column visible in Excel for Microsoft 365 on Windows, select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and the columns to the left of the selected cell, so scrolling down or right will leave row 1 and column A on screen.

How Freeze Panes Works

Freeze Panes divides the worksheet view into a stationary area and a scrolling area. The stationary area remains visible while you move through the rest of the sheet. It does not lock cells against editing, protect data, or change the worksheet’s layout; it only changes how the sheet appears while you work.

The selected cell determines the boundary. Excel freezes all rows above that cell and all columns to its left. Selecting B2 therefore freezes one row and one column. Selecting C3 freezes the first two rows and first two columns. The selected cell itself is not frozen as a boundary cell; it belongs to the scrolling area below and to the right of the frozen sections.

This is why the general Freeze Panes command is the right choice when you need both the top row and first column. The separate Freeze Top Row and Freeze First Column commands are convenient for freezing just one edge of a sheet. Applying one of those commands after another does not add a second independent frozen area; Excel uses one freeze configuration at a time.

Steps to Freeze the Top Row and First Column

Open the worksheet and make sure the data is arranged so that row 1 contains the headings and column A contains the identifying values you want to keep visible.
Select cell B2. Click the Name Box to the left of the formula bar, type B2, and press Enter if it is difficult to find the cell on a large sheet.
Choose View > Freeze Panes > Freeze Panes on the ribbon. Choose the first, general Freeze Panes option in the menu—not Freeze Top Row or Freeze First Column.
Scroll down and to the right to check the result. The headings in row 1 and the labels in column A should remain visible as the other rows and columns move.

If Freeze Panes is unavailable or the result is not what you expected, check whether the worksheet is in a special view or whether panes are already frozen. Choose View > Freeze Panes > Unfreeze Panes to clear the existing freeze, select B2, and apply Freeze Panes again. Unfreezing does not delete or rearrange worksheet data.

Choosing the Right Cell for Other Layouts

You can freeze more than one row or column by choosing a cell farther down or to the right. Excel freezes everything above and to the left, not just the row or column closest to your selection. A few examples make the rule easier to apply:

Top row and first column: select B2.
First two rows and first column: select B3.
Top row and first three columns: select D2.
First two rows and first three columns: select D3.

This is useful when a worksheet has a title row above the column headings, or when several left-hand columns together identify each record. For example, a project tracker might have two header rows and columns A through C for department, project number, and project name. Selecting D3 freezes those labels while the task details to the right and below can scroll.

Before freezing, confirm that the stationary area will not take up too much of the window. Freezing several rows and columns can leave little room to view the changing data, particularly on a small display. If the sheet is zoomed in, consider zooming out or freezing fewer columns rather than making the frozen area unnecessarily large.

When Freezing Both Edges Is Useful

Freezing the top row and first column is especially helpful in wide, long lists. As you scroll down, column headings such as Date, Customer, and Status remain available. As you scroll sideways to see later fields, the customer name or other label in column A stays in view. That combination makes it easier to tell which record and which field you are reading.

It is a good fit for schedules, inventory lists, survey responses, project trackers, and exported reports where each row represents one item and the first column identifies it. For instance, in a survey with hundreds of responses, you might keep the question headings visible at the top and a response ID visible at the left while reviewing columns farther across the sheet.

Not every sheet benefits from freezing both. A short worksheet that fits on screen may not need it, and a large first column can take up valuable space. If users mainly scroll vertically, freezing only the headings may be enough. If they mainly compare fields across a very wide sheet, keeping an identifier column visible may matter more. Pick the smallest stationary area that preserves the context people need.

Freeze Panes Versus Other Excel Options

Freeze Top Row and Freeze First Column are quick presets for one edge. They are useful when you only need one of those areas to stay put. For both edges at once, use the general Freeze Panes command after selecting B2. If a preset is already active, unfreeze it before setting a different arrangement.

Split, found on the View tab, divides a worksheet into separate panes that can be scrolled independently. It is useful when you want to compare distant parts of the same sheet, but it is not the same as freezing headings and labels. For the usual task of keeping row 1 and column A visible, Freeze Panes is simpler.

Print Titles serves a different purpose. Freeze Panes affects the on-screen worksheet view; it does not make headings repeat on printed pages. To repeat print headings, use Page Layout > Print Titles and set the rows to repeat at the top or columns to repeat at the left in Page Setup. You may use both features if you need convenient scrolling on screen and repeated labels on paper.

Excel tables can offer filter buttons and structured data features, but turning a range into a table does not automatically keep its headings visible while you scroll down the worksheet. Use Freeze Panes when that persistent on-screen context is needed.

Common Problems and Fixes

The first row or column did not freeze: check that B2 was selected before choosing the general Freeze Panes command. If you selected A1, there are no rows above or columns to the left to freeze.
Only one edge stays visible: you may have chosen Freeze Top Row or Freeze First Column, or an earlier freeze setting may still be active. Unfreeze, select B2, and choose the general command.
The wrong number of rows or columns is frozen: remember that everything above and to the left of the active cell is included. For example, selecting C2 freezes two columns, A and B—not just column A.
The frozen area seems too large: unfreeze the panes and select a cell closer to the top-left corner. A selection such as D5 freezes four rows and three columns, which may crowd the scrolling area.
Scrolling behaves unexpectedly: check for split panes as well as frozen panes. Unfreeze the panes or turn off Split from the View tab, then set up the view you actually want.

Frozen panes are a worksheet view setting, not a protection feature. They do not stop someone from changing values, and they should not be treated as a substitute for protecting a workbook. If the workbook is shared, explain the frozen layout to colleagues so they know how to remove or adjust it if needed.

Excel for Mac and Excel for the Web

In Excel for Mac, the same selection principle applies: select B2 to freeze the first row and first column, then use the Freeze Panes command on the View tab. Menu presentation can vary slightly between Excel releases, but look for the Freeze Panes options on View. To remove the setting, use the Unfreeze Panes option in that menu.

In Excel for the web, select B2 and use View > Freeze Panes, then choose the option that freezes panes based on the current selection if it is available in the displayed menu. The web interface can differ from the Windows desktop ribbon and may change over time. If the command or behavior you need is not present in your browser version, open the workbook in the desktop app and set the panes there.

Freeze settings are associated with the worksheet view and can be saved with the workbook. When opening a workbook created by someone else, the sheet may already have panes frozen. Check the View menu before applying another setting so you do not mistake an existing layout for a new one.

Frequently Asked Questions

Can I freeze the top row and first column at the same time in Excel?
Yes. Select cell B2, then choose View > Freeze Panes > Freeze Panes. This freezes row 1 and column A together.

Why does Freeze Top Row not also freeze the first column?
Freeze Top Row is a preset for the top row only. To freeze both row 1 and column A, first select B2 and use the general Freeze Panes command.

How do I freeze two rows and the first column?
Select B3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the two rows above B3 and the one column to its left.

How do I remove frozen panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This changes the worksheet view but does not remove any cell contents.

Will frozen rows repeat when I print the worksheet?
No. Freeze Panes is for on-screen scrolling. Set repeating print headings separately through Page Layout > Print Titles.

Can I freeze a row other than the top row?
Yes. Select a cell below the rows you want to keep visible and use Freeze Panes. For example, selecting B3 freezes rows 1 and 2, along with column A.

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.