Excel Freeze Panes: Keep Any Rows or Columns Visible

To freeze rows or columns other than the top row in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C4 to keep rows 1–3 and columns A–B visible while you scroll.

How Freeze Panes works

Freeze Panes divides the worksheet into a fixed area and a scrolling area. Rows above the selected cell stay in place as you scroll down, while columns to its left stay in place as you scroll right. If you freeze both, Excel keeps the upper-left block fixed and lets you move around the rest of the sheet.

The position of the active cell is what matters when you apply the command. Excel does not ask you to enter a row number or choose a range in a dialog box. Instead, it uses the cell’s location as a boundary: everything above and to the left is eligible to remain visible. The selected cell itself belongs to the scrolling area.

Freeze Panes is useful in long lists where labels disappear offscreen. Keeping a heading row visible helps you interpret values lower down; keeping identifying columns visible helps you tell which record you are looking at when viewing columns far to the right.

Freeze several rows, several columns, or both

First identify the last row and last column that must remain visible. Select the cell one row below that row and one column to the right of that column. Then use View > Freeze Panes > Freeze Panes. These examples assume the worksheet starts at the usual upper-left corner, cell A1:

Keep the first two rows: Select A3. The rows above the selection remain fixed, and no columns are frozen.
Keep the first three rows: Select A4. Rows 1–3 stay visible as you scroll down.
Keep columns A and B: Select C1. Columns to the left stay visible as you scroll horizontally.
Keep rows 1–3 and columns A–B: Select C4. Excel freezes both the rows above and the columns to the left.
Keep row 1 and columns A–C: Select D2. This is handy when a wide report has one heading row and several identifying fields.

After selecting the cell, check that it is the active cell, then open the View tab and choose Freeze Panes, followed by Freeze Panes in the menu. The command is different from the menu’s Freeze Top Row and Freeze First Column presets, which are described below.

Why selecting the right cell matters

A common mistake is selecting a row or column header rather than the cell at the boundary. Excel needs an active cell to determine which rows and columns lie above and to its left. For example, selecting B4 freezes rows 1–3 and column A, not rows 1–4 or columns A–B. To include column B, select C4 instead.

Think of the selected cell as the top-left corner of the part of the worksheet that should continue scrolling. If you want to keep a larger fixed area, move the selection farther down, farther right, or both. If the result is not what you intended, unfreeze the panes and repeat the process with the corrected cell; repeatedly applying Freeze Panes is not a way to add another independent boundary.

This approach freezes only a continuous block starting at the top and/or left edge of the sheet. Excel cannot use Freeze Panes to hold row 10 in place while rows 1–9 scroll away, or to keep column D fixed while columns A–C scroll. The fixed area must be the rows above and columns to the left of the active cell.

Freeze Panes versus Freeze Top Row and Freeze First Column

The View tab offers three related commands, but they serve different purposes. Choose Freeze Top Row when you only need row 1 to remain visible. Choose Freeze First Column when you only need column A to remain visible. These presets are convenient for simple worksheets, but they do not let you specify a different number of rows or columns.

Choose the main Freeze Panes command when you need a custom boundary, such as three heading rows, two identifying columns, or a combination of both. The command name can be confusing because Freeze Panes is both the name of the overall menu and the option for using the selected cell as a custom boundary. In the menu, the first two preset choices are not substitutes for that custom option.

For instance, if your headings occupy rows 1 and 2, Freeze Top Row will hold only row 1. Select A3 and choose the custom Freeze Panes option to keep both heading rows visible. Similarly, if a report’s useful labels are in columns A and B, Freeze First Column will hold only column A; selecting C1 and choosing the custom option keeps both columns fixed.

Unfreeze or change the frozen area

To remove the current frozen boundaries in Excel for Windows, go to View > Freeze Panes > Unfreeze Panes. The worksheet returns to normal scrolling. Select a new boundary cell and apply Freeze Panes again to create a different arrangement.

If the menu shows Unfreeze Panes, panes are currently frozen. Use that command before setting a replacement. You do not need to delete, move, or edit worksheet data to change the view; freezing affects how the sheet scrolls, not the cell contents.

When you reopen a workbook, check the view if the frozen area matters to your task. Freeze settings belong to the worksheet view and are saved with the workbook, but another person may change the view or open the file in an environment with different controls. If a colleague sees an unexpected boundary, they can unfreeze it and apply the intended setting without altering the data.

Excel for Mac and Excel for the web

In Excel for Mac, select the boundary cell and use the View tab’s Freeze Panes controls; the same principle applies: rows above and columns to the left of the selection are held in place. The exact ribbon presentation can vary with the Excel for Mac release, so look under View for Freeze Panes and its custom option. Mac keyboard shortcuts differ from Windows, and the ribbon command is the clearest method when you need to set a specific boundary.

In Excel for the web, select the cell at the boundary and use View > Freeze Panes. Available menu labels and controls can differ slightly from the desktop app, and the browser version may not expose every desktop view control in the same way. If you cannot find the custom command or the displayed result is not what you need, open the workbook in the Excel desktop app and set it there.

On Windows, the ribbon can also be navigated with key tips, but the sequence depends on the ribbon language and interface. Using the visible View menu avoids relying on a shortcut sequence that may differ in another installation. In all versions, confirm the frozen area by scrolling down and across before relying on it during a presentation or review.

Common problems and practical checks

The wrong number of rows is fixed: Unfreeze, then select the cell one row below the final row you want to keep visible. Selecting A4, for example, keeps rows 1–3.
A column is not staying visible: Select a cell one column to the right of the final column you want fixed. To hold A and B, select a cell in column C.
Only the top row or first column is frozen: You may have chosen one of the preset commands. Unfreeze and use the custom Freeze Panes option after selecting the boundary cell.
The worksheet scrolls in an unexpected way: Check for existing frozen panes and confirm the active cell before applying the command. Unfreeze first if you are changing an earlier setup.
You want a middle row or column to remain fixed: Freeze Panes cannot isolate an interior row or column while allowing the cells before it to scroll independently. Consider reorganizing the worksheet so the key labels are at the top or left.

A useful check is to freeze the panes, then scroll in both directions. Scroll down to verify the intended heading rows remain visible, and scroll right to verify the identifying columns remain visible. If you have a wide table, test a point well beyond the frozen boundary: a small scroll may not make it obvious which cells are fixed.

When another view feature may be better

Freeze Panes is designed to keep selected top rows and left columns visible while the rest of the sheet scrolls. It does not create a second independently navigable view. If you need to compare distant sections of the same worksheet at once, use View > Split. Split divides the worksheet window into panes that can be scrolled separately; it is different from keeping the top or left labels fixed.

If a worksheet contains a long list with a heading row, converting the range into an Excel table may also help with browsing and filtering. Tables can display their own column headings during vertical scrolling in supported contexts, but they do not replace Freeze Panes when you need to keep several worksheet rows or left-side columns visible. Choose the feature based on whether you need persistent labels, independent comparison areas, or table-specific sorting and filtering.

For printing, frozen panes are not the setting that repeats headings on every printed page. Use the page layout print-title controls for that separate job. A heading that remains visible while scrolling on screen does not automatically mean it will repeat on paper.

Frequently Asked Questions

How do I freeze the first two rows in Excel?
Select A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 remain visible when you scroll down.

How do I freeze more than one column?
Select a cell immediately to the right of the last column to keep visible, then choose the custom Freeze Panes option. To freeze columns A through C, select a cell in column D.

Can I freeze rows and columns at the same time?
Yes. Select a cell below the last row and to the right of the last column to keep fixed. Selecting C4 freezes rows 1–3 and columns A–B.

Why does Freeze Panes freeze the wrong rows or columns?
The active cell sets the boundary. Excel freezes rows above it and columns to its left, so check the cell address and unfreeze before trying again if the boundary is wrong.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This changes the worksheet’s scrolling view, not its data.

Can I freeze a row other than the top row by itself?
Not while the rows above it scroll independently. Freeze Panes holds a continuous block from the top and/or left edge, so it cannot pin an isolated middle row.

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.