Excel Freeze Panes in Two Directions: Rows and Columns

Yes. In Excel for Microsoft 365 on Windows, you can freeze rows and columns at the same time: select the cell immediately below the rows and immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C2 to keep row 1 and columns A:B visible while you scroll.

What freezing panes in two directions means

Freezing panes divides the worksheet view into a stationary area and a scrolling area. The stationary area stays visible as you move through other parts of the sheet. When you freeze both rows and columns, the top section remains in view during vertical scrolling, and the left section remains in view during horizontal scrolling. Excel keeps those areas anchored at the top and left edges of the worksheet.

This is useful when a table has headings across the top and labels down the side. Imagine a staff schedule with employee names in column A, departments in column B, and dates in row 1. Freeze row 1 and columns A:B, and you can scroll to later dates without losing either the date headings or the employee details. A wide sales report, project tracker, or inventory list can benefit in the same way.

“Two directions” means keeping some top rows and some leftmost columns fixed at once. It does not mean you can pin any arbitrary row and column in the middle of a worksheet. Freeze Panes works from the top and left boundaries, so the retained areas must begin at row 1 and column A.

How to freeze rows and columns together

Open the worksheet you want to change. Freeze Panes affects the active worksheet, not every sheet in the workbook.
Decide how many top rows and left columns should remain visible.
Select the cell one row below the last row to keep and one column to the right of the last column to keep.
On the ribbon, choose View > Freeze Panes > Freeze Panes.
Scroll down and across to check that the intended rows and columns stay visible.

For example, to freeze the first three rows and the first two columns, select C4 before choosing Freeze Panes. Rows 1:3 are above row 4, while columns A:B are to the left of column C. To freeze only the first row and first column, select B2. That selection marks the intersection below row 1 and to the right of column A.

Use the Freeze Panes command at the top of its menu for a custom combination. The menu also includes shortcuts such as Freeze Top Row and Freeze First Column. Those preset commands are handy when you need just one boundary, but they are not a way to add a second boundary to an existing freeze. For both directions, choose the cell first and use the general Freeze Panes command.

Choosing the right cell for your layout

The active cell is the key to getting the result you expect. Excel freezes everything above and to the left of that cell. It does not freeze the selected cell itself, nor does it infer which rows or columns are headings. A quick way to choose correctly is to write down the last row and column you want fixed, then move one row down and one column right.

Keep row 1 and column A: select B2.
Keep rows 1:2 and columns A:B: select C3.
Keep rows 1:4 and column A: select B5.
Keep row 1 and columns A:D: select E2.

For a real example, suppose a worksheet has a two-row header and the first three columns contain a product code, product name, and category. Select D3 to freeze rows 1:2 and columns A:C. When you scroll to the right to inspect monthly figures, the product identifiers remain in view; when you scroll down, the two header rows remain in view.

Be deliberate about how much you freeze. Retaining many rows or columns leaves less room for the part of the worksheet you are trying to inspect. On a smaller screen, keeping a single header row and one or two identifying columns is often easier to work with than freezing a large block.

How to remove or change a freeze

To remove the current freeze, choose View > Freeze Panes > Unfreeze Panes. After unfreezing, select the cell for the new row-and-column boundary and choose Freeze Panes again. Excel uses one freeze-pane arrangement at a time on a worksheet; you do not build a more complex arrangement by repeatedly applying different preset commands.

If the freeze seems to be in the wrong place, unfreeze it before trying again. Then return to the intended boundary cell and check its row and column coordinates. For instance, if you want to retain rows 1:2 and columns A:B, C3 is the correct selection. Choosing B3 retains the two rows but only column A; choosing C2 retains columns A:B but only row 1.

Freeze settings are separate for each worksheet. If a workbook has several tabs with similar tables, set the freeze arrangement on each relevant sheet rather than assuming one change applies throughout the workbook. Save the workbook after making changes if you want to preserve your updated view for later.

Freeze Panes compared with Split and preset commands

Freeze Panes and Split can both show different parts of a worksheet, but they solve different problems. Freeze Panes keeps selected top rows and left columns fixed while the rest of the sheet scrolls. Split divides the worksheet window into independently scrollable sections. Use Freeze Panes for persistent headings and identifiers; consider Split when you need to compare distant worksheet areas at the same time.

Freeze Top Row retains row 1 only, while Freeze First Column retains column A only. They are quick presets, not cumulative settings. If you click Freeze Top Row and then choose Freeze First Column, do not expect Excel to combine both choices. To retain a row and a column together, remove any current freeze, select the boundary cell such as B2, and use Freeze Panes.

Freezing is also different from hiding rows or columns, protecting a worksheet, or setting print titles. Hiding removes an area from the visible grid until it is unhidden. Worksheet protection controls what users can edit. Print Titles repeats chosen rows or columns on printed pages, whereas Freeze Panes changes the on-screen scrolling view. A frozen heading will not automatically repeat on every printed page.

Common problems and practical fixes

If nothing appears to happen, check that you selected the general Freeze Panes command rather than clicking a preset that does not match your goal. Then scroll the worksheet: a freeze is easiest to confirm by moving well below the retained rows and well to the right of the retained columns. A horizontal or vertical boundary line may also help indicate where the stationary section ends.

If Excel keeps the wrong number of rows or columns, the selection was likely one cell too high, low, left, or right. Remember the rule: everything above and left of the active cell stays fixed. Selecting C4 does not freeze row 4 or column C; it retains rows 1:3 and columns A:B.

If the Freeze Panes menu offers Unfreeze Panes, a freeze is already active. Remove it before setting a different arrangement. Also check whether you are working on the intended worksheet, especially if several sheets have similar names or layouts. A view change on one tab does not set the same freeze on other tabs.

A common misconception is that freezing protects headings from edits. It does not. A frozen cell can still be edited if the worksheet allows editing, and a frozen column is not locked against deletion or changes. If you need to prevent edits, look into worksheet protection separately and choose settings appropriate to the workbook.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic selection rule applies: select the cell below and to the right of the areas to retain, then use View > Freeze Panes. The ribbon layout can differ from Windows, but the important action is the general Freeze Panes command rather than a one-area preset. Use the corresponding Unfreeze Panes command to clear an existing arrangement.

Excel for the web also includes freeze-pane controls on the View tab, though the exact menu presentation can vary as Microsoft updates the interface. Look for Freeze Panes, choose the option that freezes panes based on the selected cell, and verify the result by scrolling. If you cannot find the custom command in the web interface, open the workbook in the desktop app and set the desired boundary there.

Keyboard shortcuts are not necessary for this task: the reliable method is to select the boundary cell and use the View menu. Windows and Mac keyboards differ, and there is no need to substitute a guessed shortcut for the ribbon command. In either desktop version, the selected cell determines the rows and columns retained.

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. This keeps row 1 and column A visible. Do not apply Freeze Top Row and Freeze First Column one after another expecting them to combine.

Can I freeze several rows and several columns together?
Yes. Select the cell immediately below the last row and immediately right of the last column to retain. For example, select D5 to keep rows 1:4 and columns A:C visible.

Can I freeze a row in the middle of the worksheet?
Not as an isolated row with Freeze Panes. The feature retains a continuous block from row 1 down to the row above your selection. To keep row 10 visible, for example, the rows above it would also be part of the frozen area if you set the boundary below row 10.

Why did Freeze Top Row remove my frozen columns?
Freeze Top Row is a preset arrangement, not an extra layer added to the current one. Unfreeze the existing panes, select the cell that marks both boundaries, and use the general Freeze Panes command to freeze rows and columns together.

Does freezing panes affect printing?
No. Freeze Panes changes how the worksheet scrolls on screen; it does not set repeated print headings. To repeat rows or columns on printed pages, use the Page Layout print-title controls separately.

When freezing panes is most useful

Freeze rows and columns when readers need stable context as they move through a large table. The best candidates are descriptive headings at the top and identifiers at the left: dates, account names, product codes, employee names, or project labels. A useful test is to scroll far enough that the table’s meaning would become unclear without its headings. If the labels disappear, a modest freeze can make the sheet easier to navigate.

Before sharing the workbook, check the view at typical screen sizes and make sure the retained area does not crowd the data. If the table’s structure changes, revisit the freeze boundary: inserting or rearranging rows and columns can make an old setting less useful. Freeze Panes is a small display feature, but choosing the right intersection cell makes it a practical way to read wide and long worksheets without losing essential labels.

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.