Excel Freeze Panes Based on Selection: How It Works

Yes. In Excel for Microsoft 365 on Windows, 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. Excel freezes every row above that cell and every column to its left; for example, selecting C5 freezes rows 1–4 and columns A–B.

What freeze panes does with your selection

Freeze Panes uses the active cell as a boundary between the stationary part of a worksheet and the part that can scroll. It does not freeze the selected cell itself. Rows above the active cell stay visible as you scroll down, and columns to its left stay visible as you scroll sideways. If the active cell is in the middle of a worksheet, the frozen area can therefore include both rows and columns.

The simplest and most reliable approach is to select one cell. A highlighted range can work too, but its active cell—the cell Excel treats as the current cell—sets the boundary. With a range, that active cell may not be the corner you intended, particularly if you selected the range by dragging in an unexpected direction. If the result is surprising, unfreeze the panes and try again with a single cell.

Freeze Panes is a viewing aid, not a change to the worksheet’s data. It does not move, copy, lock, or protect cells, and it does not change how formulas calculate. It simply keeps selected rows or columns in view while you navigate through the rest of the sheet.

How to freeze rows and columns from a cell

To set a custom freeze boundary in Excel for Microsoft 365 on Windows:

Open the worksheet and identify the rows and columns that should remain visible.
Click the cell directly below the last row to keep visible and directly to the right of the last column to keep visible.
Choose View > Freeze Panes > Freeze Panes.
Scroll down or across to check that the correct rows and columns remain on screen.

Suppose a worksheet has headings in rows 1 through 3 and category labels in column A. Select B4, then use Freeze Panes. The top three rows and column A will remain visible. For a table with four heading rows and two identifier columns, select C5. Excel will keep rows 1–4 and columns A–B stationary.

After freezing, the sheet usually shows a line marking the edge of the frozen area. You can scroll the unfrozen section without moving the headings or labels. Selecting a different cell later does not automatically move that boundary; the setting stays in place until you unfreeze it or apply a different freeze configuration.

Choosing the right cell: practical examples

Think of the selected cell as the first cell in the area that should scroll. That makes the boundary easier to picture: everything above and to the left is held in place, while the selected cell and the cells below and to the right belong to the scrolling area.

Keep only the top row: Select View > Freeze Panes > Freeze Top Row. If setting the boundary through a cell instead, select A2 and choose Freeze Panes.
Keep only the first column: Select View > Freeze Panes > Freeze First Column. The cell-based equivalent is B1.
Keep the top row and first column: Select B2 and choose Freeze Panes. This creates one custom freeze configuration covering both.
Keep several heading rows: To hold rows 1–3 in place, select A4 and choose Freeze Panes.
Keep several identifier columns: To hold columns A–C in place, select D1 and choose Freeze Panes.
Keep headings and identifiers: To hold rows 1–3 and columns A–C, select D4 and choose Freeze Panes.

These examples assume the frozen area starts at the top or left edge of the worksheet. Freeze Panes does not let you preserve an isolated middle row while allowing the rows above it to scroll independently. It freezes a continuous block from the top and left edges to the chosen boundary.

Freeze Panes, Freeze Top Row, and Freeze First Column

The View tab offers three related commands. Freeze Panes applies a custom boundary based on the active cell. Freeze Top Row keeps the first worksheet row visible, and Freeze First Column keeps column A visible. The latter two are convenient when the layout is simple; the custom command is the one to use when you need multiple rows, multiple columns, or both at once.

These commands are alternatives, not separate layers that accumulate. If you already froze the top row and then choose Freeze First Column, do not assume Excel will add the column to the existing setup. To create a combined layout reliably, first choose View > Freeze Panes > Unfreeze Panes, select the appropriate boundary cell—B2 to keep both the top row and first column, for example—and then choose Freeze Panes.

Freeze Panes is also different from the Split command. A split divides the worksheet window into independently scrollable sections. Freeze Panes keeps a top and/or left section fixed while the remaining area scrolls. If your goal is to compare distant parts of a sheet, Split or opening another window may suit the task better; if your goal is to keep table labels visible, Freeze Panes is usually the more direct option.

Changing or removing a freeze

Excel has one active freeze configuration for a worksheet view. To replace it, go to View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and choose Freeze Panes again. For instance, if you first froze three heading rows but later decide to keep two columns as well, unfreeze, select C4, and apply Freeze Panes. The new boundary will hold rows 1–3 and columns A–B.

Unfreezing does not delete or rearrange content. It only restores normal scrolling. If the command menu offers Unfreeze Panes, that indicates a freeze is currently active. If it offers Freeze Panes instead, there is no active freeze to remove. After changing the setting, scroll in both directions to confirm the new result, especially when the worksheet has a large used range.

Common problems and what to check

The wrong number of rows or columns stays visible: Unfreeze and select a single cell at the intended boundary. Remember that the active cell controls the result, not simply the size of a highlighted range.
Only the top row or first column freezes: You may have chosen one of the preset commands. Use the custom Freeze Panes command with a boundary cell such as C5 to freeze multiple rows and columns.
The freeze line appears in an unexpected place: Check the selected cell and any existing freeze. Remove the old configuration before applying a new one, then test by scrolling.
The command is unavailable or the sheet behaves differently: Check whether you are editing a worksheet or viewing a different workbook view, and whether the workbook or sheet has restrictions. Interface availability can also vary between desktop Excel and Excel for the web.
The headings disappear when printing: Freeze Panes affects on-screen scrolling, not printed page headings. For printouts, use Page Layout > Print Titles to repeat rows or columns on printed pages.

In Excel for the web, the View tab also provides freeze options, though the menu wording or layout can differ slightly from the Windows desktop app. If you do not see the command where expected, check the View tab and the workbook’s available editing controls. On Mac, use the View menu or View tab’s Freeze Panes options; menu placement can differ from Windows, but the boundary principle is the same.

Limits and useful alternatives

Freeze Panes is most useful for a single large table with headings at the top and identifying fields at the left. It is less suitable when the rows or columns you need to compare are separated by a large distance, because the frozen area must remain attached to the top or left edge. It also does not make the worksheet easier to read on a printed page; printing has separate page-layout settings.

If you need another way to navigate or compare information, consider these options:

Format the data as a table: A table can provide filter controls and structured formatting. It does not replace every freeze-pane use, but it can make column headings easier to work with.
Use Split: Split creates separate scrollable areas in one worksheet window, which can help when comparing distant sections rather than keeping headings fixed.
Hide or group rows and columns: This can reduce clutter, but hidden content is not the same as content that remains visible while scrolling.
Repeat print titles: Use Page Layout > Print Titles when the requirement is to repeat heading rows or columns on printed pages or in print output, rather than on-screen scrolling.

Freeze settings are also distinct from protecting a worksheet. Freezing headings does not stop another person from editing cells. If you need to restrict edits, use the worksheet protection features separately and confirm that the intended cells and permissions are configured appropriately.

Keyboard access and platform notes

On Windows, the ribbon path View > Freeze Panes > Freeze Panes is the clearest way to apply a custom boundary. In the English desktop ribbon, KeyTips can be opened with Alt; the sequence Alt, W, F, F commonly reaches Freeze Panes, though KeyTips can vary with language and interface version. Excel does not use a universal Ctrl-based shortcut for choosing an arbitrary boundary cell.

On Mac, use the View menu or the Freeze Panes control on the ribbon; Windows Alt KeyTips do not apply. Excel for the web uses its browser-based ribbon and may arrange the controls differently. Across these interfaces, the essential rule remains: set the boundary with the cell directly below and to the right of the content to keep visible, then verify the result by scrolling.

Frequently Asked Questions

Which cell should I select to freeze the top two rows?
Select A3 and choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 will remain visible; no columns will be frozen.

Can I freeze rows and columns at the same time?
Yes. Select the cell below the last row and to the right of the last column you want to keep visible. For example, C5 freezes rows 1–4 and columns A–B.

Does Excel freeze the selected cell or the cells before it?
It freezes the rows above the active cell and the columns to its left. The active cell marks the start of the scrolling area, rather than being frozen itself.

Can I freeze a row in the middle of a worksheet?
Not as an isolated row using Freeze Panes. The feature freezes a continuous block extending from the top and/or left edge, so you cannot keep one middle row fixed while the rows above it scroll separately.

How do I undo Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the viewing boundary without changing worksheet data.

Does Freeze Panes make headings repeat when I print?
No. It only affects on-screen scrolling. Set repeating print headings separately with Page Layout > Print Titles.

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.