Freeze Panes in Excel: Keep Rows and Columns Visible

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. For just the top row or first column, choose View > Freeze Panes and select the matching command.

What Freeze Panes does

Freeze Panes keeps selected rows at the top of a worksheet, selected columns at the left, or both in place while you scroll through the rest of the sheet. It is especially useful when a long list has headings such as Date, Customer, Region, or Total: the labels remain visible as you inspect records farther down or across the worksheet.

The feature changes how the worksheet is displayed; it does not change the data or its order. Frozen cells remain editable unless some separate protection setting prevents editing. It also does not make a row or column stay visible in a printed document. Printing repeated headings is a different setting, covered below.

Freeze settings apply to the active worksheet, not automatically to every sheet in the workbook. If a workbook has several data tabs, set up the view on each sheet where it is useful. A frozen area stays fixed while the unfrozen area scrolls, so freeze only the headings or identifiers you need; a large frozen block can leave little room to view the rest of the worksheet.

Freeze multiple rows and columns together

To freeze both directions, click one cell rather than selecting whole rows or columns. Excel uses that cell’s position as the boundary: everything above it becomes frozen, as does everything to its left. For example, to keep rows 1 through 3 and columns A and B visible, select C4 before using the Freeze Panes command.

Open the worksheet and click the cell just below the last row to freeze and just to the right of the last column to freeze.
On the ribbon, select View > Freeze Panes > Freeze Panes.
Scroll down and across to confirm that the intended headings and identifier columns stay in view.

Here are a few selection examples:

Select A2 to freeze row 1 only. There are no columns to the left of A.
Select A5 to freeze rows 1 through 4, with no frozen columns.
Select D1 to freeze columns A through C, with no frozen rows.
Select D5 to freeze rows 1 through 4 and columns A through C.

The cell itself is not frozen as a special case; it marks the dividing line. If you want rows 1 and 2 plus column A, select B3. For the clearest result, make sure the cell selection is on the correct worksheet and check the boundary before choosing the command.

Freeze only the top row or first column

Excel has two convenient commands for common layouts. Choose View > Freeze Panes > Freeze Top Row to keep row 1 visible while scrolling vertically. Choose View > Freeze Panes > Freeze First Column to keep column A visible while scrolling horizontally. These options are designed for the worksheet’s top row and first column, not whichever row or column happens to be selected.

For instance, if your column headings are on row 4 because the first three rows contain a report title and notes, Freeze Top Row will keep row 1—not row 4—visible. Instead, click A5 and choose Freeze Panes > Freeze Panes to freeze rows 1 through 4. Similarly, if the key identifier is in column C, select a cell in column D and use Freeze Panes to keep columns A through C in view. The extra columns to the left will freeze too, so consider whether they are useful to keep visible.

Only one freeze arrangement can be active on a worksheet at a time. Choosing Freeze Top Row or Freeze First Column replaces the current arrangement rather than adding another independent freeze boundary. If the result is not what you meant, unfreeze first and set the boundary again.

Choose the right boundary for a real worksheet

Start by identifying what readers need to know while they scroll. A sales export might have headings in row 1 and a customer name in column A. Selecting B2 freezes both, leaving the transaction details free to scroll. A wider inventory report might need the first two heading rows and the item code in column A; selecting B3 freezes those rows and that column.

For a wide schedule, keeping a few identifying columns visible can make it easier to associate values with a person, project, or date. But freezing every descriptive column is rarely helpful: the remaining scrollable area may become too narrow, particularly on a laptop. If the view feels cramped, unfreeze and keep only the most useful label columns.

Remember that freezing works from the top and left edges. Excel can freeze a continuous block of top rows and a continuous block of leftmost columns, but it cannot freeze row 1 and row 5 while allowing rows 2 through 4 to scroll, or freeze column A and column D while columns B and C move. If a non-contiguous label must remain visible, consider reorganizing the worksheet or using a separate summary view.

Unfreeze panes and fix common problems

To remove the current freeze arrangement, choose View > Freeze Panes > Unfreeze Panes. The worksheet returns to ordinary scrolling. You can then select a new boundary and freeze a different set of rows or columns. Unfreezing does not delete, move, or alter worksheet data.

If the wrong rows or columns stay visible, first unfreeze, then check the selected cell. To freeze through row 4 and column C, the boundary cell is D5—not C4. C4 would freeze only rows 1 through 3 and columns A through B. This off-by-one boundary is one of the most common causes of an unexpected result.

If Freeze Panes is unavailable or appears disabled, leave cell-editing mode by pressing Esc or Enter, then check that the sheet is in Normal view. In Excel for Windows, Normal is available from View > Workbook Views > Normal. Also confirm that you are working in the worksheet whose view you want to change. If a workbook opens with an unfamiliar view, switching to Normal and reopening the Freeze Panes menu can help identify the active setting.

If scrolling seems to affect the wrong part of the sheet, look for a visible divider between the fixed and moving areas and test by scrolling both vertically and horizontally. If you no longer need the arrangement, use Unfreeze Panes rather than trying to drag the divider. Excel’s Split feature uses adjustable panes and can behave differently.

Freeze Panes, Split, and printed headings

Freeze Panes and Split solve related but different viewing problems. Freeze Panes pins the rows above and columns left of a selected boundary. Split divides a worksheet window into separate panes that can be scrolled independently. Split may be useful when comparing distant parts of the same sheet, while Freeze Panes is usually simpler for keeping headings visible as you browse one continuous data area. Avoid treating them as interchangeable controls.

Neither feature repeats headings on paper or in a PDF. To print row or column headings on multiple pages, use Page Layout > Print Titles, then set the rows to repeat at top or columns to repeat at left in the Page Setup options. Print preview is a useful check because screen freezing and print layout are separate settings.

Excel tables and frozen panes can also be confused. A table provides structured data features such as filter buttons and a defined header row; freezing is a worksheet view setting. If the goal is to keep an ordinary worksheet heading in sight during scrolling, use Freeze Panes even if the data is formatted as a table. Choose the feature based on the problem: table tools help manage data, while freezing controls what remains on screen.

Windows, Mac, and Excel for the web

The ribbon path in Excel for Microsoft 365 on Windows is View > Freeze Panes. In the English Windows desktop app, keyboard Key Tips can open the command with Alt, then W, then F, then F, pressing the keys in sequence rather than holding them together. Key Tip letters can differ with language or interface changes, so the ribbon path is the reliable fallback.

In Excel for Mac, use the View tab and its Freeze Panes menu; the exact menu presentation can vary slightly by release. The Windows Alt sequence is not a Mac shortcut. If a keyboard command is not shown in the Mac menu or shortcut list, use the ribbon command rather than assuming the Windows sequence works there.

Excel for the web also provides Freeze Panes from the View tab. Select the boundary cell first when you need a custom combination of rows and columns, then choose the freeze command. The web ribbon may present the controls differently from the Windows desktop app, and some keyboard behavior depends on the browser. The core rule is unchanged: the position of the selected cell determines the rows above and columns to its left that remain visible.

Frequently Asked Questions

Can I freeze more than one row or column?
Yes. Select a cell below all the rows and to the right of all the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes the continuous rows above and columns to the left of that cell.

How do I freeze a row other than the top row?
To keep rows 1 through 4 visible, select a cell in row 5 and choose Freeze Panes. Freeze Top Row only pins row 1, so use the general Freeze Panes command when the headings are farther down the sheet.

Why does Freeze Panes keep the wrong columns visible?
The selected cell marks the boundary, and all columns to its left are frozen. To freeze only column A, select a cell in column B. To freeze columns A through C, select a cell in column D, then check that no existing freeze arrangement is affecting the view.

Does freezing panes affect printing?
No. It changes the on-screen worksheet view only. To repeat headings on printed pages, set them separately with Page Layout > Print Titles and verify the result in print preview.

How do I remove frozen rows or columns?
Choose View > Freeze Panes > Unfreeze Panes. This restores normal scrolling without changing the cells or their contents. You can then set a different freeze boundary if needed.

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.