Can You Custom Freeze Panes in Excel? Here’s How

Can You Custom Freeze Panes in Excel? Here's How

Yes. 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 C3 to keep rows 1–2 and columns A–B visible while you scroll.

What custom freeze panes mean

Freeze Panes is a worksheet view setting that keeps selected upper rows and left-hand columns in place as you scroll through the rest of a sheet. It is useful when a long list has labels or identifiers that would otherwise disappear offscreen. A sales report, for instance, might have two heading rows and a customer-name column; freezing the right area lets you compare values farther down or across the worksheet without losing those references.

Excel does not ask you to type a number of rows and columns into a custom dialog. Instead, it uses the active cell as a boundary. Everything above that cell is eligible to remain visible as frozen rows, and everything to its left is eligible to remain visible as frozen columns. The cell itself and the cells below and to the right continue to scroll.

This allows a combination of rows and columns in one freeze arrangement. It does not let you freeze unrelated or nonadjacent areas, such as row 1 and row 10 while allowing the rows between them to scroll. The frozen region is anchored at the top and left of the worksheet.

How to freeze a custom number of rows and columns

First decide which headings or identifiers must remain visible, then click the cell at the intersection just below and to the right of those areas. Use the Freeze Panes command—not the separate Freeze Top Row or Freeze First Column commands—when you need a custom combination.

Open the worksheet and select the cell that marks the freeze boundary. To freeze the first two rows and first two columns, select C3.
On the ribbon, choose View > Freeze Panes > Freeze Panes.
Scroll down or to the right to confirm that the intended rows and columns remain in view.

The selection matters: selecting B3 freezes rows 1–2 and column A; selecting D2 freezes row 1 and columns A–C. If only rows are needed, select the first cell below them in column A. If only columns are needed, select the first cell to their right in row 1. The command uses the selected cell’s position, not the cell’s contents.

In Excel for Mac, select the boundary cell and use View > Freeze Panes > Freeze Panes. In Excel for the web, use the View tab’s Freeze Panes controls; available options can depend on the current web interface, but the same boundary principle applies where freezing at the selection is offered. If a menu looks different, check that you are in the worksheet’s View controls rather than a print or page-layout view.

Examples for common worksheet layouts

Here are practical selection examples. Assume the worksheet begins in cell A1 and the labels to preserve start at the top or left edge:

Keep the first row: Choose View > Freeze Panes > Freeze Top Row. This is the quickest choice for a single header row.
Keep the first column: Choose View > Freeze Panes > Freeze First Column. This is convenient when names or categories are in column A.
Keep the first three rows: Select A4, then choose Freeze Panes. Rows 1–3 remain visible.
Keep columns A and B: Select C1, then choose Freeze Panes. Columns A and B remain visible.
Keep two heading rows and two identifying columns: Select C3, then choose Freeze Panes.

For a wider worksheet, freezing an identifier column together with a header row can make horizontal comparisons much easier. For example, a monthly report may have employee names in column A, departments in column B, and one column per month. Freezing A and B while keeping the month labels at the top means you can scroll to later months and still identify both the person and the column headings.

What Excel can and cannot freeze

Freeze Panes is designed for the top and left edges of a scrolling worksheet. It cannot keep a row near the bottom of the sheet fixed while rows above it move, nor can it pin a column on the far right while columns to its left scroll. If you select a cell halfway down and across a worksheet, the frozen areas are still the rows above and columns to the left of that selection; Excel does not turn the selected row or column into a floating panel.

You also cannot create several independent frozen blocks in the same worksheet with the standard Freeze Panes command. The option is one continuous top section, one continuous left section, or both. This distinction helps avoid a common misunderstanding: clicking a particular cell does not freeze that individual cell. It establishes the border between the stationary part and the scrolling part.

A frozen pane is also not a lock on editing. It changes what stays on screen during scrolling; it does not protect cells, prevent edits, or stop data from changing. To restrict editing, use worksheet protection separately. And freezing a heading on screen does not automatically repeat it on printed pages—print settings handle that job.

How to change or remove a freeze

Excel generally allows one freeze arrangement at a time per worksheet. To replace it, first remove the existing arrangement, then select a new boundary cell and apply Freeze Panes again. On Windows, go to View > Freeze Panes > Unfreeze Panes. The corresponding Freeze Panes controls are on the View tab in current Mac and web versions as well.

Unfreezing does not delete rows, columns, or worksheet data. It simply returns the sheet to ordinary scrolling. Then you can choose a different boundary. For instance, if you initially froze only row 1 but later decide that columns A and B should stay visible too, unfreeze, select C2, and apply Freeze Panes. That selection keeps row 1 and columns A–B stationary.

Freeze settings belong to the worksheet view, so check each worksheet separately in a workbook. Applying a freeze on one tab does not automatically apply the same arrangement to every other tab. The setting is saved with the workbook, but users may see different on-screen results if they open a different worksheet or change the view.

Common problems and how to fix them

If the wrong rows or columns stay put, the usual cause is selecting the wrong boundary cell. Unfreeze first, count the rows and columns you want to preserve, and select one row below and one column to the right. For two rows and two columns, that is C3—not B2 or C2.

The Freeze Panes option is unavailable or behaves unexpectedly: Check whether the worksheet is in a mode or state that limits editing, and make sure you have selected a worksheet cell. If the workbook is protected, review its protection settings; protection can restrict actions.
A split line appears instead of the expected freeze: Split is a different viewing command. Remove the split or return to the normal view, then use the Freeze Panes menu.
Headings disappear when printing: Freeze Panes affects on-screen scrolling only. Set print titles in Page Layout > Print Titles instead.
The frozen area takes up too much screen space: Unfreeze and select a boundary with fewer rows or columns. Frozen rows and columns reduce the space available for scrolling data, especially on a small display.

For a useful setup, freeze only the labels needed to interpret the visible data. Keeping a dozen rows fixed may technically work, but it can leave little room to see the records you are reviewing. Test the arrangement by scrolling both vertically and horizontally, not just in one direction.

Freeze Panes compared with Split and print titles

Freeze Panes and Split can both divide the worksheet window, but they solve different problems. Freeze Panes keeps a top and/or left section stationary while the remaining area scrolls. Split divides the view into independently scrollable sections, which can help compare distant parts of a worksheet without continually moving back and forth. A split does not mean that the selected rows or columns are permanently pinned as a header.

Print titles serve a third purpose. If a report spans several printed pages, you can use Page Layout > Print Titles to repeat chosen rows at the top or columns at the left of each page. A row frozen on your monitor will not necessarily repeat on paper or in a printout. For a worksheet used both on screen and in print, configure the relevant view and print settings independently.

There is no need to use Split just because you want to freeze both rows and columns: one Freeze Panes selection can do both. Conversely, if you need two independently moving views of distant areas, a split may fit better than freezing a large block.

Tips for choosing a useful freeze boundary

Start with the question a reader must answer while scrolling: Which record is this, and what does each value represent? Often that means freezing a name or ID column and one or two rows of headings. Keep the boundary as small as practical so the working area remains large.

Include every header row if labels occupy more than one row; a partially visible heading can be confusing.
Freeze stable identifiers, such as product codes, only if they help interpret the columns currently being viewed.
Avoid freezing blank rows or columns unless they deliberately separate the labels from the data.
Check the result at the zoom level and window size people will actually use.

If a worksheet has a title, notes, and several lines of headings above its data, consider whether all of that material needs to remain visible. A title may be useful at the top of the sheet but consume too much screen space when frozen. A clean table with one clear header row may be easier to navigate than an oversized frozen area.

Frequently Asked Questions

Can I freeze multiple 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, then use View > Freeze Panes > Freeze Panes. Selecting C3 freezes rows 1–2 and columns A–B.

Can I freeze a row other than the top row?
You can freeze several rows starting at the top, but the standard command does not pin an isolated middle row. To freeze rows 1–4, select A5 and apply Freeze Panes; rows 1–4 stay visible together.

Why can I not freeze the first two columns using Freeze First Column?
Freeze First Column is a preset for column A only. To freeze two columns, select C1 and choose Freeze Panes. If another arrangement is already active, unfreeze it before setting the new one.

Does Freeze Panes work in Excel for the web?
Excel for the web includes Freeze Panes controls on the View tab. The exact menu presentation can vary as the web interface changes, but where freezing at a selection is available, choose the cell at the desired boundary first.

Will frozen headings appear on every printed page?
No. Freeze Panes is an on-screen scrolling feature. To repeat worksheet rows or columns in a printout, use Page Layout > Print Titles and configure the print titles separately.

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.