Excel Freeze Panes: Keep Columns Visible While Scrolling

To freeze columns vertically in Excel for Microsoft 365 on Windows, select the cell immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C1 to keep columns A and B in place while you scroll horizontally; because the selection is in row 1, no rows are frozen.

What vertical freeze panes do

Freeze Panes keeps chosen rows or columns visible while you move through the rest of a worksheet. “Vertical” usually means freezing one or more columns at the left edge, so those columns remain on screen as you scroll sideways. This is useful when a wide sheet extends beyond the window and you need to keep names, dates, product codes, or other identifying information in view.

The frozen area stays fixed at the top or left of the worksheet window, while the unfrozen area can scroll. The feature does not lock cells against editing, protect data, or change the worksheet’s underlying values. It is a viewing aid, not a security or data-entry control.

Excel offers a preset for freezing the first column as well as a custom Freeze Panes command. The custom command can freeze several leftmost columns, and it can also freeze rows at the same time. The selected cell determines the boundary: rows above it and columns to its left are frozen.

Freeze the first column

If column A contains row labels or identifiers, the built-in command is the quickest option. In the Windows desktop version of Excel for Microsoft 365:

Open the worksheet you want to work with.
Select View on the ribbon.
Choose Freeze Panes, then Freeze First Column.
Scroll horizontally to confirm that column A remains visible.

Excel marks the boundary with a subtle line just to the right of the frozen column. The line can be easy to miss, especially at some zoom levels, but the column should remain in place as the rest of the sheet moves. The command freezes column A specifically; it is not a way to choose a different single column while leaving earlier columns unfrozen.

To freeze a different set of columns, use the cell-selection method in the next section. For instance, if the useful identifiers are in columns A through C, select D1 and use Freeze Panes > Freeze Panes.

Freeze several columns without freezing rows

Use the general Freeze Panes command when you want to keep two or more adjacent columns visible. The selection must be in the first row if you want to freeze columns only. Otherwise, Excel will also freeze every row above the selected cell.

Click the cell in row 1 immediately to the right of the columns to keep visible.
Choose View > Freeze Panes > Freeze Panes.
Scroll to the right. The columns to the left of the boundary should stay put.

For example, if columns A and B contain a customer ID and customer name, select C1. When you choose Freeze Panes, Excel freezes A and B, but no rows. If you instead select D1, columns A, B, and C are frozen. Excel freezes a continuous block from the left edge; you cannot use this feature to keep only column C visible while columns A and B scroll away.

To freeze columns A through C and the header row at the same time, select D2 before choosing Freeze Panes. Excel freezes the rows above the selection (row 1) and the columns to its left (A through C). The same boundary rule applies no matter how many rows or columns you need to hold in place.

How to choose the right cell

It helps to decide first which labels must remain visible, then locate the cell at the corner where the scrolling area should begin. The selected cell itself is not frozen. Its position sets the dividing line: the frozen columns are to its left, and the frozen rows are above it.

Only column A: use Freeze First Column, or select B1 and choose Freeze Panes > Freeze Panes.
Columns A and B: select C1, then choose Freeze Panes > Freeze Panes.
Columns A through D: select E1, then choose Freeze Panes > Freeze Panes.
Top row and columns A and B: select C2, then choose Freeze Panes > Freeze Panes.
Top three rows and column A: select B4, then choose Freeze Panes > Freeze Panes.

Before applying the setting, check the row number and column letter of your selection. A frequent mistake is clicking the first data cell below the headers when the intention is to freeze columns only. If that cell is in row 2 or later, the rows above it will also be frozen. That may be exactly what you want, but if not, return to row 1 and select the appropriate boundary cell.

Unfreeze or change the frozen area

Excel generally allows one freeze-pane arrangement at a time on a worksheet. To replace it, first remove the current arrangement and then set a new boundary. On Windows, choose View > Freeze Panes > Unfreeze Panes. After that, select the correct cell and choose Freeze Panes > Freeze Panes again, or choose Freeze First Column for the preset.

If the Freeze Panes menu offers Unfreeze Panes, a freeze arrangement is active. Unfreezing does not delete rows, columns, or data; it only removes the fixed scrolling boundary. If you want to move the boundary, do not try to drag the visible line. Unfreeze the current setting and apply a new one from the cell at the desired boundary.

Freeze settings apply to the active worksheet, not automatically to every sheet in the workbook. If several sheets need the same arrangement, repeat the steps on each one. Check the active sheet before using the command, particularly in a workbook with many tabs.

Freeze Panes compared with Split

Freeze Panes and Split both divide the worksheet view, but they are meant for different tasks. Freeze Panes holds selected top rows and left columns in place while the remaining area scrolls. Split divides the window into independently scrollable panes, which can help you compare distant parts of a worksheet at once.

For example, freezing column A is convenient when every visible row needs its label as you browse across a wide table. A split may be more useful if you want to compare the first rows with rows much farther down while keeping both areas available in separate panes. If the window has been split and behaves differently than expected, check View for the Split command and turn the split off before setting freeze panes. A split is not the same as freezing a column.

Common problems and useful checks

The wrong rows are frozen: the selected cell was below row 1. Unfreeze, select the boundary cell in row 1, and apply Freeze Panes again.
Only column A stays visible: Freeze First Column was used. To hold more columns, unfreeze, select the cell to the right of the full block in row 1, and use the general Freeze Panes command.
The column you clicked is not the only one frozen: Excel freezes all columns to the left of the selected cell, not just that cell’s column. Select the correct boundary.
The boundary is hard to see: scroll horizontally or inspect the line between frozen and scrolling columns. Try a different zoom level if the divider is subtle.
The setting seems to affect only one tab: freeze panes are set per worksheet. Repeat the operation on each sheet that needs it.
You cannot find the command: open the View tab and look for the Freeze Panes menu. If a freeze is already active, the menu includes Unfreeze Panes.

Frozen columns remain visible in the worksheet window, but that does not mean they are repeated automatically on printed pages. Print layout is controlled separately through page setup and print titles. Similarly, freezing a column does not prevent someone from changing its contents; use worksheet protection or appropriate sharing controls if editing restrictions are required.

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 area to freeze, then use the Freeze Panes controls on the View tab. The exact presentation of the ribbon or menu can vary with the Mac version and window layout, but the choice is still based on rows above and columns to the left. Use the View controls to unfreeze before choosing a different boundary.

Excel for the web also includes freeze-pane controls on the View tab. Choose the relevant freeze option there; if you need a custom arrangement, select the boundary cell first and use the available Freeze Panes command. The browser interface can differ slightly from the Windows desktop ribbon, and some workbook features may behave differently between versions. If a command is missing or the layout is important to a shared workbook, check the file in the desktop application.

Frequently Asked Questions

Can I freeze a column other than the first column?
Yes, but Excel freezes a continuous block starting at column A. To freeze A through C, select D1 and choose View > Freeze Panes > Freeze Panes. You cannot freeze only column C while allowing A and B to scroll.

How do I freeze columns but not the top row?
Select the cell in row 1 immediately to the right of the columns you want to freeze. For example, select C1 to freeze columns A and B without freezing any rows.

Can I freeze the first column and top row together?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. Excel freezes row 1 and column A because they are above and to the left of the selected cell.

Why does Excel freeze more columns than I selected?
The active cell sets a boundary, rather than selecting an individual column. Every column to its left is frozen. To freeze only column A, select B1; to freeze A and B, select C1.

Do frozen columns appear on every printed page?
No. Freeze Panes affects on-screen scrolling, not print repetition. To repeat labels on printed pages, set print titles separately using the Page Layout options.

How do I remove frozen columns?
Choose View > Freeze Panes > Unfreeze Panes in Excel for Windows. This removes the fixed pane boundary without changing worksheet data. You can then apply a different freeze arrangement 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.