Freeze Multiple Columns in Excel: A Step-by-Step Guide

To freeze multiple columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right of the last column 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. The selected cell’s position determines which columns and rows stay fixed, so check it before applying the command.

Frozen panes make wide worksheets easier to read: labels, names, dates, or ID fields remain on screen while you move across the rest of the data. You can also freeze columns and rows together. The same basic approach works in Excel for Mac and Excel for the web, though the ribbon layout can vary slightly.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
A clear idea of the last column you want to keep visible. For example, to freeze A through C, the boundary is immediately before column D.
A worksheet view in which you can select a cell. You do not need an add-in, formula, or special workbook setup.

Step-by-Step

Open the correct worksheet. Click its sheet tab at the bottom of the workbook. Freeze settings apply to the active worksheet view, so confirm you are working on the sheet you want. If the workbook has several similar tabs, check the data before changing the view.
Decide how many columns to freeze. Count from the left edge of the sheet. To keep columns A and B visible, you will freeze two columns. To keep A through D visible, you will freeze four. Excel freezes the columns to the left of the selected cell; it does not offer a command to freeze an arbitrary group of columns in the middle while leaving columns to their left scrollable.
Choose the right selection cell. Click the cell in the first column that should scroll, on the row immediately below any rows you also want to freeze. For columns A and B only, select C1. For A through D only, select E1. If you also want to keep row 1 visible, select C2 to freeze A:B and row 1 together. In general, the cell’s column sets the vertical boundary, and its row sets the horizontal boundary.
Open the Freeze Panes menu. On the Windows ribbon, select View > Freeze Panes. The menu includes Freeze Panes, Freeze Top Row, and Freeze First Column. Choose the first option, Freeze Panes, for a custom number of columns or for a combination of rows and columns. The preset options are useful for a single top row or the first column, but they are not the way to freeze several columns.
Apply the custom freeze. With the intended cell still selected, click View > Freeze Panes > Freeze Panes. Excel places a boundary line between the fixed area and the scrolling area. If you selected C1, columns A and B should remain visible when you scroll horizontally. If you selected C2, those two columns and row 1 should stay visible.
Check the result by scrolling. Use the horizontal scrollbar at the bottom of the sheet, or the mouse wheel or trackpad, to move to the right. The frozen columns should remain on the left while the other columns move. If you froze a row as well, scroll down to confirm it remains at the top. A visual boundary line can be subtle, so testing the scroll is more dependable than judging the line alone.
Adjust the freeze if the boundary is wrong. Choose View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply Freeze Panes again. For example, if you meant to hold A:B but selected D1, Excel will hold A:C instead. Unfreezing and resetting is the simplest correction; you cannot drag the freeze boundary to a different column.
Save the workbook if you want to retain the view. Save normally after confirming the panes. The setting is part of the worksheet’s view, not a change to the cell data. If colleagues open the workbook, they may see the frozen layout too, depending on how they open and view the file.

On Mac: Select the boundary cell and use View > Freeze Panes > Freeze Panes. The logic is the same as on Windows: columns to the left of the selected cell and rows above it are held in place. Menu placement or wording can vary with the Excel for Mac release. In Excel for the web: use the View tab and its Freeze Panes controls; select the boundary cell first when creating a custom freeze. If you do not see the same menu arrangement as the desktop app, look for Freeze Panes on the View ribbon.

Common Mistakes

Selecting the column you want to freeze instead of the next one. To freeze A and B, C is the boundary column, so choose a cell in column C. Selecting B1 freezes only column A, because Excel fixes columns to the left of the selected cell, not the selected column itself.

Choosing Freeze First Column for a multi-column layout. That preset freezes column A only. Use the custom Freeze Panes command for two or more columns. Likewise, Freeze Top Row is a preset for row 1, not a way to combine that row with a custom column boundary.

Forgetting the row position of the selected cell. Selecting C2 freezes both A:B and row 1. That is helpful if row 1 contains headings, but it is a surprise if you meant to freeze columns only. For columns without frozen rows, select the boundary column in row 1, such as C1.

Trying to freeze columns that are not at the far left. Freeze Panes creates a fixed block starting at the upper-left corner. It cannot keep column D fixed while A:C scroll, or freeze A and C while B moves. Rearrange the layout if you need a different grouping.

Assuming frozen means protected. Freezing changes what stays visible during scrolling; it does not prevent someone from editing or deleting cells. Use worksheet protection separately if you need to limit editing. Frozen panes also do not determine which rows or columns appear on printed pages; use print settings for that purpose.

Tips

Plan the freeze around the way people read the sheet. A roster might freeze employee names in A:B, while a sales report might keep a date or product identifier visible. Avoid freezing more columns than necessary: a wide fixed area leaves less room to see the scrolling data, especially on a small screen.

If column headings are on row 1, combining the headings and identifying columns is often the most useful setup. For two fixed columns plus the heading row, select C2 before choosing Freeze Panes. For four fixed columns plus the heading row, select E2. Remember the general rule: select one column to the right of the fixed block and one row below the fixed rows.

Freeze panes are a view aid, not a filter or a split of the data. You can still edit cells in the frozen and scrolling areas, use formulas, sort, and filter according to the worksheet’s normal settings. If you need to compare distant areas of a large worksheet, Excel’s Split feature may be useful, but it creates independently scrolling panes rather than a fixed left-hand block.

For a quick check before sharing, scroll far enough right that the original columns would normally disappear. Make sure the labels remain visible and that the first scrolling column is the one you expect. Also confirm the setting on the worksheet itself; freezing panes on one tab does not automatically freeze the same columns on every other tab.

Troubleshooting

The wrong number of columns stays fixed: Note the selected cell’s column letter. If you selected E1, Excel freezes A:D, not A:C. Unfreeze, select the cell immediately after the intended block, and apply Freeze Panes again.

The top row is frozen when you did not ask for it: The selected cell was probably below row 1. Choose View > Freeze Panes > Unfreeze Panes, select the boundary cell in row 1, and apply the custom command again. For example, C1 freezes A:B without freezing row 1.

Nothing appears to change: Scroll horizontally or vertically to test it; the boundary line can be faint. Also confirm that you used the custom Freeze Panes option rather than selecting a preset that does not match your layout. In a narrow window, the fixed columns may take up most of the visible area, making the scrolling effect less obvious.

The Freeze Panes command is unavailable: If you are editing a cell, press Enter to finish the edit or Esc to cancel it, then try again. Confirm that a worksheet cell is active rather than a chart or another object. If a split view is active, turn it off with View > Split and try the freeze command again. If the desktop and web versions show different controls, try the View tab in the version you are using.

You cannot make the columns move independently: That is expected. Freeze Panes holds all columns to the left of the selected boundary together. It does not allow nonadjacent columns or a middle section to remain fixed on its own. Move the needed identifying fields to the left side of the worksheet if they must stay visible together.

Frequently Asked Questions

Can I freeze two or more columns in Excel?
Yes. Select a cell in the column immediately to the right of the last column to freeze, then choose View > Freeze Panes > Freeze Panes. For A:B, select C1.

How do I freeze columns and the top row at the same time?
Select a cell below row 1 and to the right of the columns to keep visible. For A:B plus row 1, select C2, then apply Freeze Panes.

Can I freeze columns on both sides of the worksheet?
No. Excel freezes a continuous block from column A through the column immediately before your selection. It cannot freeze a separate group on the right while the center scrolls.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This returns the worksheet to normal scrolling without deleting or changing any cell contents.

Does freezing columns affect printing?
No. It controls the on-screen worksheet view. To repeat headings on printed pages, use the print settings for rows or columns to repeat instead of relying on Freeze Panes.

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.