How to Freeze X and Y Axes in Excel at the Same Time

To keep a worksheet’s top row and leftmost column visible while you scroll, select cell B2, then choose View > Freeze Panes > Freeze Panes. For more than one header row or column, select the cell just below and to the right of the area you want to keep visible, then use the same command. In Excel, this feature is called Freeze Panes; it keeps worksheet rows and columns in place rather than freezing chart axes.

What You’ll Need

A worksheet open in Microsoft Excel for Microsoft 365 on Windows. The steps are similar in current versions of Excel for Mac and Excel for the web, though menu placement can vary slightly.
A clear idea of which rows and columns should stay visible as you scroll. For example, you might want to keep row 1, which contains column headings, and column A, which contains names.
A worksheet view that is not already split or frozen in a way you no longer need. You can remove an existing freeze before setting a different one.

Step-by-Step

Open the worksheet and identify the headers. Freeze Panes works on the active worksheet, so first click the sheet tab you want to adjust. Decide exactly which rows at the top and columns on the left must remain visible. For a typical data list, this is row 1 and column A. If your table has two header rows and a category column plus a name column, you may want to preserve rows 1 and 2 and columns A and B.
Choose the cell that marks the freeze boundary. Click the cell immediately below the last row you want to freeze and immediately to the right of the last column you want to freeze. Excel freezes everything above that cell and everything to its left. To keep only the top row and first column, select B2. To keep rows 1 through 3 and columns A through C, select D4. The selected cell itself is not frozen; it marks where the scrolling area begins.
Open the Freeze Panes command. In Excel for Microsoft 365 on Windows, select the View tab on the ribbon. In the Window group, choose Freeze Panes to open its menu. Depending on the width of the Excel window, the group or command may be condensed, so maximize the window if you cannot see it.
Freeze both the selected rows and columns. In the menu, choose Freeze Panes, which is the first command in the menu. Do not choose Freeze Top Row or Freeze First Column if you need to preserve both a row and a column using a custom boundary. Those two commands are quick options for freezing one edge of the worksheet, while the main Freeze Panes command uses your selected cell.
Check that the freeze is in place. Scroll down and confirm the selected top rows remain visible. Then scroll horizontally using the bottom scrollbar and check that the left-side columns remain visible. A thin line across the sheet and a thin line down the sheet indicate the frozen boundaries. The lines may be subtle, so scrolling is the best practical check.
Adjust the freeze if the wrong area stayed put. Choose View > Freeze Panes > Unfreeze Panes. Then click the correct boundary cell and repeat the freeze command. For example, if you intended to keep row 1 and column A but accidentally selected C2, Excel also freezes column B. Unfreeze, select B2, and apply Freeze Panes again.

In Excel for Mac, select the boundary cell and use View > Freeze Panes > Freeze Panes. The labels and location can differ slightly by Excel version. In Excel for the web, select the boundary cell, then look for View > Freeze Panes and choose the freeze command. If a command is not visible, widen the browser window or check the View tab’s menu. The cell-selection rule is the same: select one row below and one column to the right of the area to preserve.

For the simplest two-edge setup, B2 is the key selection: it tells Excel to keep row 1 and column A in view. For a worksheet with title rows above the actual table, be deliberate about whether those title rows should stay fixed too. If you freeze through row 3, all three rows remain visible, even if only row 3 contains the column labels.

Common Mistakes

Selecting the header cell instead of the boundary cell. If row 1 and column A should stay visible, selecting A1 or B1 does not specify the correct boundary. Select B2, the cell below row 1 and to the right of column A. For multiple frozen rows or columns, move the selection down and right accordingly.
Using Freeze Top Row when you also need a column. Freeze Top Row is convenient if only the first row needs to remain visible. It does not let you define a custom left-side column at the same time. Use the Freeze Panes command with a carefully chosen cell to freeze both directions.
Freezing too many rows or columns. If you select a cell far down or across the sheet, all rows above and columns to the left become fixed. This can leave little room for the scrolling area, particularly on a laptop screen. Unfreeze and choose a boundary closer to the top-left corner.
Expecting worksheet freezing to lock chart axes. Freeze Panes applies to worksheet rows and columns. It does not keep a chart’s horizontal or vertical axis fixed while changing the chart’s data or scaling. For a chart, adjust its axis options or chart layout instead; that is a separate task.
Thinking the frozen area is protected from editing. Frozen cells remain editable. Freeze Panes changes what stays on screen when you scroll; it does not protect cells, lock their contents, or prevent changes. Use worksheet protection if you need to restrict editing.

Tips

Use the boundary-cell rule rather than guessing. Count the rows and columns that should remain visible, then select the next row and next column. If you need rows 1 and 2 plus columns A and B, select C3. Excel freezes the rows above and columns to the left of the selected cell.
Keep headers compact. Freeze only the rows and columns that help identify the data as you navigate. A very tall frozen header takes up screen space and can make it harder to inspect records below it.
Test both scroll directions. A freeze can look correct when you scroll vertically but still include an unwanted column. Check down the sheet and across it before sharing the workbook, especially if a colleague will use a smaller display.
Remember that the setting belongs to a worksheet view. Freeze panes on one sheet does not automatically freeze the same rows and columns on every sheet in the workbook. Set it separately on each worksheet where it is useful.
Unfreeze before creating a new layout. Excel generally replaces the existing freeze when you apply a new one, but unfreezing first makes the change easier to reason about and check. It is also useful if you cannot tell what boundary is currently active.
Use Freeze Top Row or Freeze First Column when that is all you need. These options are faster for a single header edge. For example, View > Freeze Panes > Freeze Top Row keeps row 1 visible. The equivalent Freeze First Column option keeps column A visible. Use the custom Freeze Panes command when you need both or want a different boundary.

Troubleshooting

The wrong rows or columns are frozen. Select View > Freeze Panes > Unfreeze Panes. Click the correct boundary cell and choose Freeze Panes again. Remember that a selected cell such as D4 freezes rows 1 through 3 and columns A through C, not just the row and column beside it.

The Freeze Panes option is unavailable or does not seem to work. Confirm you are in a worksheet and have selected a cell, rather than editing a chart, shape, or cell contents. If the worksheet is protected or opened in a restricted view, some commands may be unavailable; check the workbook’s protection and editing status. Also make sure you are using the View tab’s Freeze Panes command, not a similarly named setting for a chart or window layout.

The boundary lines are hard to see. Do not rely only on the lines. Scroll down several rows and across several columns. If the top header or left-side labels stay visible while the rest of the sheet moves, freezing is working. You can also return to the View menu to see whether the available command is now Unfreeze Panes.

Only one direction appears frozen. Check that you chose the main Freeze Panes menu command after selecting the boundary cell, rather than Freeze Top Row or Freeze First Column. Then unfreeze, select the cell one row below and one column to the right of the complete area you want fixed, and try again.

You are using Split instead of Freeze Panes. Split divides the worksheet window into separate panes that can scroll independently; it is not the same as keeping headers fixed. If the sheet has divider bars or independently moving sections, turn off View > Split, then set Freeze Panes using the boundary-cell method.

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. Row 1 and column A will remain visible as you scroll.

How do I freeze more than one row and column?
Select the cell immediately below the last row and immediately to the right of the last column you want to keep. For example, select D4 to freeze rows 1 to 3 and columns A to C, then apply Freeze Panes.

Can I freeze a row that is not at the top?
Freeze Panes keeps rows above the selected boundary, starting from the top of the worksheet. It cannot freeze an isolated middle row while allowing the rows above it to scroll separately. You can use Split for independently scrolling sections, but it behaves differently.

Does freezing rows or columns change the workbook data?
No. It changes the worksheet’s scrolling view, not the cell values or formulas. You can unfreeze panes at any time without deleting or moving data.

Can I freeze the X and Y axes of an Excel chart?
Not with Freeze Panes. That command applies to worksheet rows and columns. Chart axes have their own formatting and scaling options, but they do not have a worksheet-style freeze command.

Will the freeze setting apply to every sheet in the workbook?
No. Freeze Panes is set for the active worksheet view. Repeat the steps on each sheet where you want the same rows or columns to remain visible.

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.