Excel Freeze Panes: Keep Top Rows and Side Columns Visible

Yes. To keep Excel’s top row and a side column visible at the same time, select the cell one row below and one column to the right of the areas you want to keep, then choose View > Freeze Panes > Freeze Panes. For the top row and first column, select B2 before applying the command.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of a worksheet and selected columns at the left while you scroll through the rest of the sheet. The frozen area stays in place; the unfrozen area moves. This is useful when a wide or long table has labels that you need to see to understand the values currently on screen.

The key is that Excel uses the active cell to determine where the frozen areas end. Everything above the selected cell becomes a frozen row area, and everything to its left becomes a frozen column area. The selected cell itself is not frozen. Excel marks the boundary with a line so you can see which parts of the worksheet will remain stationary.

Freeze Panes does not pin a row or column wherever you happen to click. It always freezes from the top of the worksheet downward and from the left edge toward the right. That makes it possible to keep both a header area and identifying columns visible, but it does not let you choose separate, non-adjacent areas.

How to Freeze the Top Row and a Side Column

In Excel for Microsoft 365 on Windows, use this procedure to freeze the first row and first column together:

Open the worksheet you want to change and switch to the View tab.
Select cell B2. Row 1 is above it, and column A is to its left.
Choose View > Freeze Panes > Freeze Panes.
Scroll down and to the right to check that the top row and first column remain visible.

For a larger header area or more than one identifying column, select a different cell before choosing Freeze Panes. For example, selecting C4 freezes rows 1 through 3 and columns A and B. The same rule applies regardless of the labels or data in those cells: the selection establishes the boundary, not the content.

Be sure to choose the first menu item named Freeze Panes, rather than Freeze Top Row or Freeze First Column. Those two options apply preset arrangements. They do not create a combined top-and-side freeze based on your selected cell.

Choose the Cell That Defines Both Edges

Think of the worksheet as having a horizontal boundary below the rows you want to retain and a vertical boundary to the right of the columns you want to retain. Select the cell where those two boundaries meet. In general, if you want to freeze rows 1 through r and columns A through c, select the cell in row r + 1 and column c + 1. Then apply View > Freeze Panes > Freeze Panes.

For example, imagine a sales sheet with three header rows: a report title, a date range, and column labels. If columns A and B contain a product name and category that you want to keep visible, select C4. Rows 1 through 3 and columns A and B will stay put while you scroll through the detail. If only the column-label row and product name need to remain visible, select B2 instead.

There is no requirement that the frozen rows contain formal table headers. You might freeze a title and units row in a measurement log, or a date row in a daily schedule. The practical test is whether the information will help you identify the values in the scrolling area. Freezing too many rows or columns can leave little room for the data, especially on a laptop screen.

Useful Layout Examples

Here are common arrangements and the cell to select immediately before applying Freeze Panes:

Top row and first column: Select B2. This suits a simple grid where row 1 has headings and column A has names or item numbers.
Top two rows and first column: Select B3. Both top rows and column A stay visible.
Top row and first three columns: Select D2. The top row remains visible while columns A through C stay at the left.
Three header rows and two identifying columns: Select C4. This works for reports with multi-line headings and labels in the first two columns.

These examples also clarify a common misconception: selecting a cell inside the header does not freeze that cell. Excel freezes the rows above it and columns to its left. If you select A2, for instance, you freeze row 1 but no columns, because there are no columns to the left of column A.

Freeze Panes, Freeze Top Row, and Freeze First Column

The View tab offers three related commands. Freeze Panes uses the selected cell to set both the row and column boundaries. Freeze Top Row keeps row 1 visible, while Freeze First Column keeps column A visible. The latter two are convenient when you need only one of those standard arrangements.

If you want the top row and first column together, Freeze Panes with B2 selected is the direct option. Choosing Freeze Top Row and then Freeze First Column is not the reliable way to combine them: each preset command establishes its own arrangement, rather than adding another frozen area to the existing one. Set the desired boundaries with one selection instead.

Freeze Panes is also different from Split. A split divides the worksheet into separate panes that can be scrolled independently; it does not simply hold chosen headers in place as you move through one continuous data area. Use Freeze Panes for persistent labels, and consider Split only when independently viewing different parts of the sheet is the goal.

Change or Remove a Freeze

To change the arrangement, first remove the current freeze. In Excel for Microsoft 365 on Windows, choose View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and choose View > Freeze Panes > Freeze Panes again. For example, to change from freezing row 1 and column A to freezing rows 1 through 3 and columns A and B, unfreeze, select C4, and apply Freeze Panes.

To remove frozen rows and columns without replacing them, choose Unfreeze Panes from the same menu. This returns the worksheet to ordinary scrolling. It does not delete data, alter formulas, or change the order of rows and columns; it changes only how the sheet is displayed.

Freeze settings belong to the worksheet view, so check each sheet in a workbook separately. A workbook with several tabs can have a useful freeze arrangement on one sheet and no freeze on another. If you copy data to a different worksheet, do not assume its pane setup will match the source sheet.

Common Problems and Fixes

The wrong rows or columns are frozen: Unfreeze Panes, click the correct boundary cell, and apply Freeze Panes again. Remember that the active cell freezes only the rows above and columns to the left.
Only the top row or first column stays visible: You may have chosen one of the preset commands. Unfreeze, select the cell at the intersection of your desired boundaries, and choose the general Freeze Panes command.
The command appears unavailable: Confirm that the intended worksheet is active and that Excel is in Normal view. If needed, choose View > Normal, then try the command again.
The freeze line is hard to interpret: Return to the top-left of the sheet and inspect the boundary before scrolling. The line indicates where the stationary area ends; it does not indicate a cell border or print boundary.
There is too little room to see the data: Reduce the number of frozen rows or columns. A large title block and several label columns can consume most of the visible window, so freeze only what is needed to identify the scrolling cells.

When checking a setup, scroll both vertically and horizontally. A sheet may appear correct when you scroll down but reveal a misplaced column boundary when you move far to the right. Testing both directions confirms that the intended top rows and side columns are being held.

Excel for Mac and Excel for the Web

In Excel for Mac, the same principle applies: select the cell below and to the right of the area to keep, then use the Freeze Panes command on the View tab or View menu, depending on the ribbon layout. For the first row and first column, select B2. Menu placement can differ from Windows, but the boundary-selection rule does not.

Excel for the web also provides freeze-pane controls under View. Select the boundary cell before applying Freeze Panes, and check the worksheet by scrolling. The web interface can look different as Microsoft updates its ribbon, so follow the visible Freeze Panes option rather than relying on a Windows keyboard shortcut. On Windows, the ribbon path is the clearest method; Mac users can use the menu or ribbon rather than expecting the same key sequence.

Frequently Asked Questions

How do I freeze the top row and first column in Excel?
Select B2, then choose View > Freeze Panes > Freeze Panes. Row 1 is above B2 and column A is to its left, so both remain visible as you scroll.

Can I freeze multiple rows and columns at once?
Yes. Select the cell immediately below the last row and immediately to the right of the last column you want to freeze. Selecting C4, for example, freezes rows 1 through 3 and columns A and B.

Why does Freeze Panes keep the wrong area visible?
The selected cell may not be at the boundary you intended, or a different freeze may already be active. Choose Unfreeze Panes first, select the correct cell, and apply Freeze Panes again.

Can I freeze a row that is not at the top?
Freeze Panes retains rows starting at row 1, so you cannot freeze only an isolated middle row while allowing the rows above it to scroll. You can freeze all rows above your selected cell, including the middle row, but the earlier rows will stay too.

Does freezing panes affect printing?
No. Freeze Panes controls on-screen scrolling; it does not set which rows repeat on printed pages. For printouts, use the separate print-title settings rather than expecting frozen rows to repeat.

For a quick setup, identify the rows and columns that must remain visible, select the cell at the bottom-right corner of that area, and use the general Freeze Panes command. If the result is not right, unfreeze and adjust the selected cell rather than trying to add another preset freeze.

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.