How to Freeze Columns in Excel While Scrolling: A Guide

How-to basics · Updated November 20, 2026

To keep a column visible as you scroll horizontally in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze First Column. To keep two or more columns visible, select the cell immediately to the right of the columns you want to keep, then choose View > Freeze Panes > Freeze Panes. The frozen columns stay on screen while you move across the worksheet, making it easier to compare values with their row labels.

Before you begin, decide how many columns need to remain visible and check that they are the first columns on the left. Excel freezes a continuous block starting at column A; it cannot freeze an isolated column while letting the columns before it scroll away. The steps below cover the Windows desktop app first, with notes for Mac and Excel for the web.

What You’ll Need

  • A worksheet open in Excel for Microsoft 365, Excel for Mac, or Excel for the web.
  • A clear idea of which columns should stay visible. For example, a list may need column A for employee names, or columns A and B for names and departments.
  • If you want to freeze multiple columns, identify the first cell to the right of the last column you want to keep. This is the key to selecting the correct Freeze Panes setting.

Step-by-Step

  1. Open the worksheet and identify the columns. Find the columns that contain labels you need to see while moving horizontally through the sheet. If the labels are in column A only, you can use the built-in Freeze First Column command. If you need columns A and B, or more, count the columns from the left edge. Excel freezes a continuous block from column A through the column just before your selection.
  2. Choose the simplest option for just the first column. On Windows, open the View tab on the ribbon. In the Window group, select Freeze Panes, then choose Freeze First Column. The first column remains visible as you scroll to the right. This command is ideal for a single identifier column, such as product names, dates, or customer IDs.
  3. Select a cell for freezing two or more columns. Click the cell in the top row immediately to the right of the last column you want to freeze. For instance, to keep columns A and B visible, select any cell in column C, such as C1. To keep columns A through D visible, select a cell in column E. The selected row also matters if you intend to freeze rows at the same time; see the next step before choosing the cell.
  4. Freeze only the columns, if that is your goal. To freeze columns A and B without freezing any rows, select C1. Then choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of the selected cell and the rows above it. Because C1 is in the first row, there are no rows above it to freeze. A vertical boundary appears after column B, showing where the frozen area ends.
  5. Freeze columns and rows together when useful. The same Freeze Panes command can lock both a block of columns and a block of rows. Select the cell below the rows and to the right of the columns you want to keep. For example, to keep rows 1 and 2 and columns A and B visible, select C3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell and the columns to its left. This is useful when a worksheet has both column headings and row identifiers.
  6. Check the result by scrolling. Use the horizontal scroll bar at the bottom of the worksheet or a trackpad gesture to move to the right. The frozen columns should remain in place while later columns move. If you froze rows too, scroll down as well; the frozen rows should remain visible at the top. Look for the boundary line beside the frozen area to confirm where the split is.
  7. Remove or change the freeze when needed. To clear the current setting in the Windows desktop app, select View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply the desired Freeze Panes command again. Excel generally allows one frozen-pane arrangement per worksheet, so unfreeze the existing one before setting up a different arrangement.
  8. Use the equivalent controls on other platforms. In Excel for Mac, use the View tab and its Freeze Panes menu; the available choices are similar, though ribbon layout and wording can vary slightly by version. In Excel for the web, open View and look for Freeze Panes. The web interface may display the freeze options in a compact menu. If you do not see a particular option, use the desktop app or check that the workbook is open in editing mode.

Common Mistakes

Selecting a cell too far to the right. Excel freezes every column to the left of the selected cell, not just the column you had in mind. If you select F1, for example, Excel freezes columns A through E. To freeze only A and B, select a cell in column C.

Selecting a cell below the first row by accident. Freeze Panes considers both the row and column of your selection. Selecting C3 freezes columns A and B, but it also freezes rows 1 and 2. If you want columns only, select a cell in row 1, such as C1.

Expecting a middle column to freeze by itself. The standard freeze feature keeps a contiguous block anchored at the left edge. You cannot freeze column D alone while columns A through C scroll away. Reorder or copy the key information to the left if it needs to remain visible.

Applying a new freeze without clearing the old one. If the worksheet already has frozen panes, the new selection may not produce the layout you expect. Choose Unfreeze Panes first, then make a fresh selection.

Confusing Freeze Panes with Split. Split divides the worksheet into independently scrolling sections; it does not simply pin columns in place. For labels that should stay visible while the rest of the sheet moves, use Freeze Panes.

Tips

Freeze only what you need. Keeping a single identifier column or two compact label columns visible usually leaves plenty of room to read the scrolling data. If you freeze too many columns, the remaining worksheet area can become narrow, especially on a laptop display. You can unfreeze and adjust the setting whenever the layout changes.

Make the frozen columns useful as a reference. A short name, category, or unique ID is often more helpful than a wide block of descriptive text. If a frozen column is unusually wide, consider resizing it before freezing: drag the boundary between its letter headings, or use Home > Format > Column Width to enter a width.

For a data table with headings in row 1 and labels in column A, freeze both together if you need to scroll down and sideways. Select B2 and choose View > Freeze Panes > Freeze Panes. That keeps row 1 and column A visible. If you also need column B to stay visible, select C2 instead; that freezes row 1 and columns A and B.

Save the workbook after setting up the view if you want the freeze arrangement to be available when you return to it. Frozen panes are a worksheet view setting, not a change to the underlying values, so they do not alter formulas or data. For a workbook with several sheets, set the freeze arrangement on each sheet where it is needed; do not assume a change on one worksheet applies to all the others.

Troubleshooting

The wrong number of columns stays visible: Unfreeze the panes, then count from column A and select the cell immediately after the desired block. To freeze A through C, select a cell in D. Reapply View > Freeze Panes > Freeze Panes and scroll right to check the result.

Rows are frozen when you only wanted columns: The selected cell was probably below row 1. Choose Unfreeze Panes, select the correct column in row 1, and apply Freeze Panes again. For example, select C1 to freeze columns A and B without freezing any rows.

The columns do not appear to stay fixed: Make sure you are scrolling horizontally, not just vertically. Frozen columns are useful when moving left and right across a wide sheet. They do not stop normal vertical movement; frozen rows, rather than columns, stay at the top as you scroll down. If the boundary is hard to see, scroll a little farther right and look for the line separating the frozen and scrolling areas.

The Freeze Panes command is unavailable or behaves unexpectedly: Check whether the sheet is protected or whether you are viewing the workbook in a restricted state. If the file is read-only, switch to editing mode or save an editable copy if you have permission. Some ribbon layouts hide commands in a smaller menu, so expand the View tab or search Excel’s command box for Freeze Panes. In the web app, try opening the workbook in the desktop app if the option is missing or the layout differs.

You need a different set of frozen columns: Excel does not move the freeze boundary by dragging it. Choose Unfreeze Panes and set the arrangement again using a new selection. If the desired column is not next to the left edge, consider moving the column or adding a copy of its identifying information to the first column. Keep an original copy of the workbook if moving data could affect formulas or references.

Frequently Asked Questions

Can I freeze more than one column in Excel?
Yes. Select a cell in the column immediately to the right of the block you want to keep, then choose View > Freeze Panes > Freeze Panes. Selecting C1 freezes columns A and B.

Can I freeze a column and the top row at the same time?
Yes. Select the cell below the row and to the right of the column block you want to freeze. For the top row and column A, select B2, then choose Freeze Panes. For the top row and columns A and B, select C2.

Can I freeze columns that are not next to column A?
Not with the standard Freeze Panes command. Excel freezes a continuous block from the left edge, so a column in the middle cannot remain fixed on its own while earlier columns scroll.

Will freezing columns change or lock my data?
No. It changes what stays visible while you navigate the worksheet. You can still edit cells normally, and unfreezing panes does not remove or change any worksheet data.

How do I freeze the first column on a Mac?
Open the View tab, choose Freeze Panes, and select Freeze First Column if it is shown. Menu placement can vary by Excel for Mac version; to clear it, return to the same menu and choose Unfreeze Panes.

Does freezing columns work in Excel for the web?
Yes, Excel for the web includes Freeze Panes controls on the View tab. If the menu options differ from the desktop instructions or are unavailable in your current view, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac and apply the setting there.

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.