Excel Column Stays When Scrolling? Freeze Panes Guide

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, choose View > Freeze Panes > Freeze First Column to keep column A visible while you scroll horizontally. To keep a different set of columns visible, select the cell immediately to the right of the columns you want to retain, then choose View > Freeze Panes > Freeze Panes.

What Freeze Panes does

Freeze Panes keeps selected rows or columns in view while the rest of the worksheet scrolls. The frozen area stays anchored at the top or left edge of the worksheet window, so you can compare information in distant parts of a large table without losing the labels that explain it.

A common example is a worksheet with employee names in column A and monthly figures in columns B through M. When you scroll right to review later months, the names can disappear off the left side. Freezing column A leaves the names visible as you move across the sheet. The same idea is useful for product names, account numbers, dates, or other identifying fields.

Freeze Panes is a viewing aid, not a change to the data. It does not lock cells against editing, protect a column, or make a column permanently visible to everyone who opens a printed copy. It changes how the worksheet is displayed on screen.

Keep the first column visible

For a simple worksheet where the labels you need are in column A, use the built-in first-column command:

  1. Open the worksheet and select any cell. The selected cell does not determine the result when you use Freeze First Column.
  2. On the ribbon, select View > Freeze Panes > Freeze First Column.
  3. Scroll horizontally to the right. Column A should remain visible while the other columns move.

Excel marks the boundary of the frozen area with a thin line. Depending on the worksheet and display settings, the line may be subtle, so test the result by scrolling a few columns to the right. If column A is very wide, the frozen area can take up much of the window; consider narrowing it if it leaves too little room to read the scrolling columns.

This command freezes only the first column. It is not a general command to keep whichever column is currently selected in place. For example, selecting cell D1 and choosing Freeze First Column still freezes column A, not column D.

Freeze more than one column

To keep two or more columns visible, use Freeze Panes rather than Freeze First Column. The key is to select the first cell to the right of the columns you want to keep. Excel freezes the columns to the left of that cell; it does not freeze the selected column itself.

  • To keep column A visible, select a cell in column B, such as B1, then choose View > Freeze Panes > Freeze Panes.
  • To keep columns A and B visible, select a cell in column C, such as C1, and choose the same command.
  • To keep columns A through D visible, select a cell in column E, such as E1, and choose the command.

For a concrete example, imagine columns A and B contain a customer ID and customer name, while columns C onward contain quarterly results. Select C1, then apply Freeze Panes. When you scroll across the results, both identifying columns stay at the left. Selecting C1 is enough because the columns left of it are A and B.

Frozen columns must form a continuous block from the left edge. You cannot freeze column A and column C while allowing column B to scroll independently using Freeze Panes. If you need nonadjacent information for comparison, consider rearranging the worksheet, using a second window, or creating a separate summary view.

Freeze a column and a header row together

You can keep columns on the left and rows at the top visible at the same time. Select the cell below and to the right of the area you want to freeze. Excel freezes every row above the selected cell and every column to its left.

For example, if row 1 contains headings and column A contains names, select B2 and choose View > Freeze Panes > Freeze Panes. Row 1 stays visible when you scroll down, and column A stays visible when you scroll right. If you select C3 instead, Excel freezes rows 1 and 2 as well as columns A and B. Check the selection before applying the command: an unexpectedly large frozen area often means the active cell was farther down or farther right than intended.

Excel also offers separate commands for Freeze Top Row and Freeze First Column. These are convenient when you need only one header row or only column A. If you need a combination, use the cell-selection method and the general Freeze Panes command instead.

Change or remove frozen columns

Excel allows one Freeze Panes arrangement at a time on a worksheet. To change which columns or rows are frozen, first remove the current arrangement, then set up the new one:

  1. Select View > Freeze Panes > Unfreeze Panes.
  2. Select the cell that is below and to the right of the rows and columns you want to retain.
  3. Choose View > Freeze Panes > Freeze Panes.

For instance, if column A is frozen but you now want columns A and B frozen with the top row too, unfreeze the current setting, select C2, and apply Freeze Panes. The result keeps row 1 and columns A and B visible.

Freeze settings apply to the worksheet, not to every sheet in the workbook as one global setting. If a workbook has several tabs where users need frozen headers, configure each relevant worksheet separately. Save the workbook after making the change if you want the view setting to be retained when the file is reopened.

Common reasons it does not look right

  • The wrong column stays visible. Freeze First Column always targets column A. To freeze another number of columns, unfreeze the current setting, select a cell immediately to the right of the desired block, and use Freeze Panes.
  • More rows or columns freeze than expected. The general command uses the active cell. Check which cell is selected: rows above it and columns to its left become frozen. Unfreeze and try again from the correct cell.
  • The column still moves. Confirm that you chose Freeze Panes rather than merely clicking a cell, and test by scrolling horizontally. For a column other than A, make sure you used the general Freeze Panes command.
  • There is a line but the column seems missing. The frozen area may be narrow, hidden behind the window edge, or outside the part of the sheet you are viewing. Look for the vertical boundary near the left of the worksheet and scroll back to the far-left side.
  • The command is unavailable or behaves differently. Check that the worksheet is in a normal worksheet view and that the ribbon menu is open under View. Excel’s available controls and menu layout can vary somewhat by platform and interface updates.

Also distinguish horizontal scrolling from vertical scrolling. Freezing a column helps when moving left and right across columns; it does not keep a row heading visible as you move down. To retain a heading while scrolling down, freeze a row, such as the top row, or use a combined Freeze Panes setup.

Freeze Panes compared with other options

Freeze Panes is usually the right choice when you want a fixed reference area at the left or top while the worksheet scrolls. It is built into the worksheet view and does not duplicate or reorganize the underlying data.

Split, found on the View tab, divides the worksheet window into panes that can be scrolled separately. It is useful when you want to examine distant areas of the same sheet at once, but it is not the same as simply keeping one label column fixed while the rest moves. If your goal is a familiar left-hand identifier column, Freeze Panes is generally more straightforward.

Hide removes columns from view rather than keeping them visible. It may make a worksheet less cluttered, but hidden data cannot serve as a persistent reference while scrolling. Print settings are different again: to repeat a heading column on printed pages, use Page Layout > Print Titles and set the columns to repeat at the left. A frozen on-screen column does not automatically mean that it repeats on every printed page.

Excel for Mac and Excel for the web

In current Excel for Mac, the equivalent controls are on the View tab under Freeze Panes. The available choices and exact menu presentation can differ from Windows, but the selection principle is the same: choose Freeze First Column for column A, or select a cell to the right of the columns to retain before applying Freeze Panes. To remove the setting, use the Unfreeze Panes command in the same area.

Excel for the web also provides Freeze Panes controls on the View tab. If the ribbon is collapsed or the window is narrow, expand the ribbon or look in the View controls for the freeze options. When collaborating, remember that freeze panes affect how a worksheet is displayed and may be visible to other people using that sheet; they do not restrict those people from editing cells. Interface details can change as Microsoft updates the web app, so follow the command labels shown in your current version.

Frequently Asked Questions

How do I keep a column visible in Excel while scrolling?
Choose View > Freeze Panes > Freeze First Column to keep column A visible. To keep multiple columns visible, select the cell immediately to the right of them and choose Freeze Panes.

Can I keep column B visible instead of column A?
Yes, but Freeze First Column is not the right command. To keep columns A and B visible, select a cell in column C, then choose View > Freeze Panes > Freeze Panes. Excel freezes the block from column A through the column just left of your selection.

Can I freeze a column and the top row at the same time?
Yes. To freeze column A and row 1 together, select B2 and choose Freeze Panes. More generally, select the cell below the rows and to the right of the columns you want to keep.

How do I unfreeze a column in Excel?
Choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or select a new cell and apply a different Freeze Panes arrangement.

Does freezing a column make it repeat when I print?
No. Freeze Panes controls the on-screen worksheet view. To repeat columns on printed pages, use Page Layout > Print Titles and specify the columns to repeat at the left.

Related

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.