How to Freeze Multiple Columns in Excel While Scrolling

To freeze several columns in Excel, 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 D1 to keep columns A through C on screen while you scroll horizontally. Freeze Panes locks the columns to the left of your selected cell, and it can also lock rows above it.

This is useful in wide worksheets where names, IDs, dates, or other identifying details would otherwise disappear as you move across the data. Before you start, decide which leftmost columns should stay visible and whether you also need to keep a header row on screen.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365. The same basic process is available in recent desktop versions of Excel and Excel for the web.
A worksheet with the columns you want to freeze positioned at the far left. Freeze Panes locks adjacent columns starting with column A; it cannot keep separate, nonadjacent columns visible.
A clear idea of whether you want to freeze rows as well. The cell you select determines both what is frozen above it and what is frozen to its left.

Step-by-Step

Open the correct worksheet. Click the worksheet tab containing your data. Freeze settings apply to the active worksheet, not to every sheet in the workbook. If your workbook has several sheets, you will need to set up freezing separately on each one where it is needed.
Decide how many columns to keep visible. Count from the left edge of the worksheet. To freeze columns A and B, the first unfrozen column is C. To freeze A through C, the first unfrozen column is D. This works for a contiguous block beginning at column A, not for a column farther to the right by itself.
Choose the correct cell in the worksheet. Click the cell at the intersection of the first column you want to scroll and the first row you want to scroll. To freeze A through C but no rows, select D1. To freeze A through C and row 1, select D2. In general, Excel freezes everything above the selected cell and everything to its left. If you prefer, click the Name Box to the left of the formula bar, type D1 or D2, and press Enter to select the cell directly.
Open the Freeze Panes menu. On Windows, go to the View tab on the ribbon, find the Window group, and select Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row or Freeze First Column. Those two options apply only their named preset and do not set a custom group of multiple columns.
Check that the freeze line is in the right place. Excel displays a line marking the boundary between frozen and scrolling areas. For columns A through C, the vertical boundary should appear between columns C and D. If you also froze the top row, a horizontal boundary should appear below row 1. The line may be subtle, so check the selected cell and the visible column letters as well.
Test the worksheet by scrolling. Use the horizontal scrollbar at the bottom of the worksheet and move to the right. The frozen columns should stay in place while the other columns move. If you froze a header row, scroll down and make sure that row remains visible too. Testing both directions helps confirm that you selected the intended cell.
Change the frozen area if needed. If the wrong columns or rows are locked, go to View > Freeze Panes > Unfreeze Panes. Then select the correct cell and choose View > Freeze Panes > Freeze Panes again. Excel allows one frozen-pane arrangement per worksheet, so unfreeze the existing arrangement before creating a different one.

Example: Suppose a report has an employee ID in column A, a name in B, a department in C, and monthly figures beginning in D. Select D1 if you want only the three identifying columns to stay visible. If the column labels are in row 1 and must stay visible while you scroll down, select D2 instead. You can then move across the monthly figures without losing the employee details or, in the second setup, the headings.

Common Mistakes

Selecting the column you want to freeze instead of the one after it. To freeze A through C, choose D1 or D2, not C1 or C2. Excel freezes the columns to the left of the selected cell; the selected column itself remains in the scrolling area.
Choosing Freeze First Column. This preset freezes only column A. It does not freeze a larger group. For several columns, select the appropriate cell and use the main Freeze Panes command.
Using Freeze Top Row when you need columns. Freeze Top Row locks row 1 only. It does not freeze the columns containing IDs or labels. Use the custom Freeze Panes option for a combination of rows and columns.
Expecting to freeze columns in the middle of a sheet. Freeze Panes keeps a continuous block attached to the left edge. It cannot leave columns A and B scrolling while pinning only column D, or freeze two separated groups.
Forgetting that a prior freeze is still active. A previous setting can make a new attempt seem ineffective or leave a different boundary than expected. Use Unfreeze Panes first, then select the new intersection cell.
Selecting a cell in the wrong pane. If the worksheet is already divided by a freeze boundary, it may be unclear which cell is active. Unfreeze first, click the intended cell in the normal worksheet, and apply the setting again.

Tips

Freeze only what readers need to identify the data. A wide frozen block reduces the room available for scrolling columns. Keep the frozen area to essential fields, such as an ID and a short description, rather than locking every identifying or explanatory column.
Use a row-and-column intersection when working with tables. Selecting D2 freezes row 1 and columns A through C at the same time. The rule is consistent: everything above and to the left of your chosen cell stays fixed.
Keep headings in the top row when practical. If your actual column headings are lower in the worksheet, selecting a cell below them will freeze all rows above that cell, not just the heading row. Consider whether those extra rows are useful to keep visible before setting the freeze.
Save the workbook after setting up a useful view. Freeze settings are part of the worksheet view and are normally retained when you save the workbook. Save, close, and reopen if you want to confirm the workbook opens with the arrangement you expect.
Distinguish freezing from hiding. Frozen columns remain visible while other columns move; they are not removed from the sheet. Hiding columns changes what is displayed and is not a substitute when you need to refer to those fields as you scroll.
Use the menu rather than relying on a shortcut. Excel’s ribbon key tips and keyboard behavior can vary by version and platform. The View > Freeze Panes path is clear on Windows; on Mac, use the View menu or View tab and choose Freeze Panes. The exact menu layout can vary slightly between desktop and web versions.

Troubleshooting

The wrong number of columns stays visible: Check the selected cell before applying the command. If you intended to freeze A through C, the selected cell must be in column D. Unfreeze the current panes, select D1 for columns only or D2 for columns plus row 1, and apply Freeze Panes again.

The columns do not stay in place when you scroll: Make sure you are moving the horizontal scrollbar, not simply selecting another cell. If the scrollbar is already at the far left, drag it to the right to test. Also check that the boundary line appears after the last column you meant to freeze. If no boundary appears, the freeze may not have been applied, or you may have used a preset that does not match your goal.

You cannot find Freeze Panes: Confirm that you are on the View tab or View menu and that the worksheet is active. In the desktop app, look in the Window group on the View tab. In Excel for the web, open View and look for Freeze Panes; the available menu layout may differ from the desktop ribbon. If the workbook is in a restricted or read-only state, switch to an editable copy before changing its view.

More rows are frozen than expected: The selected cell was probably below the row you meant to freeze. For example, selecting D5 freezes rows 1 through 4 as well as columns A through C. Unfreeze, then select a cell on row 1 if you want no frozen rows, or row 2 if you want only row 1 frozen.

The setting seems to affect only one worksheet: That is expected. Freeze Panes is applied sheet by sheet. Repeat the steps on each worksheet where you need a fixed set of columns. If you group worksheet tabs to make changes together, be careful: edits can apply to every grouped sheet, so ungroup them when finished.

Frequently Asked Questions

Can I freeze more than one column in Excel?
Yes. Select a cell in the first column that should scroll, then choose View > Freeze Panes > Freeze Panes. For example, D1 freezes columns A through C.

Can I freeze columns and the top row at the same time?
Yes. Select the cell just below the row to freeze and just to the right of the columns to freeze. For columns A through C and row 1, select D2 before choosing Freeze Panes.

Can I freeze columns that are not next to column A?
Not as a separate group. Excel freezes columns continuously from the left edge through the column immediately before your selected cell. You cannot freeze only column C while allowing A and B to scroll.

How do I remove frozen columns?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen arrangement on the active worksheet. You can then apply a different arrangement by selecting a new cell first.

Does freezing columns change or protect my data?
No. Freezing changes how the worksheet is displayed while you scroll. It does not lock cells against editing, protect the sheet, hide data, or change the workbook’s underlying values.

Can I freeze columns in Excel for Mac or Excel for the web?
Yes. The same selection rule applies: choose the cell immediately right of the columns to freeze, and below any rows to freeze. Use Freeze Panes from the View menu or tab; the exact placement of the command can differ slightly from Excel for Windows.

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.