Freeze Columns in Excel: Keep a Group Visible While Scrolling

To freeze a group of columns in Excel for Microsoft 365 on Windows, select the first cell 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 columns from the left edge of the worksheet, not an arbitrary group elsewhere.

What You’ll Need

An Excel workbook with the worksheet you want to adjust.
A clear idea of which leftmost columns should remain visible. The columns must be next to one another and start at column A; for example, you can freeze A:C, but not just B:C while A scrolls away.
Access to the View tab. The procedure works in Excel for Microsoft 365 on Windows; Excel for Mac and Excel for the web have similar commands, with notes below.

Step-by-Step

Open the right worksheet. Click the worksheet tab that contains the data. Freeze settings apply to the active worksheet, so check that you are not working on a different tab. If the workbook has several sheets that need the same setup, repeat the procedure on each one.
Decide how many columns to keep visible. Count from column A through the last column you want fixed. If your table uses A for an ID, B for a name, and C for a category, and you want all three labels visible as you move right, the frozen group is A:C. You cannot select a group with the mouse and expect Freeze Panes to lock only those selected columns; Excel uses the active cell to determine the boundary.
Select the cell immediately to the right of the group. For columns A:C, click D1. The active cell is the reference point: Excel freezes the columns to its left. Select a cell in row 1 if you want to freeze columns only. If you select D5 instead, Excel freezes columns A:C and also rows 1 through 4, which may be useful but is not a columns-only result.
Open the Freeze Panes menu. On the ribbon, click View, then click Freeze Panes in the Window group. Depending on the ribbon layout or window size, the button may appear as a dropdown or be grouped with other window controls. If the ribbon is collapsed, expand it or maximize the Excel window to find the command.
Choose Freeze Panes. In the dropdown, select the top Freeze Panes command, not Freeze Top Row or Freeze First Column. Those two commands are shortcuts for locking only row 1 or column A. With D1 active, the general Freeze Panes command locks A:C and leaves the rows free to scroll vertically.
Check the result by scrolling horizontally. Use the horizontal scrollbar at the bottom of the worksheet and move it to the right. Columns A:C should remain visible while later columns move across the screen. Scroll back to the left and verify that the frozen boundary is where you intended. A narrow line at the edge of the frozen area indicates the pane boundary.
Save the workbook. Save as usual with File > Save or Ctrl+S on Windows. The frozen view is associated with the worksheet in the workbook, so saving helps preserve the setup for later use. If other people use the file, tell them which columns are frozen so the fixed section does not surprise them.

Example: Suppose a wide inventory sheet has SKU in A, item name in B, and warehouse in C, followed by monthly stock figures in D onward. Click D1 and use View > Freeze Panes > Freeze Panes. When you move to later months, the SKU, item name, and warehouse columns stay visible, making it easier to identify each row. If you also want the header row to remain visible while moving down the sheet, click D2 instead; that freezes row 1 as well as columns A:C.

In Excel for Mac, select the same boundary cell and use View > Freeze Panes > Freeze Panes. In Excel for the web, select the boundary cell and look for View > Freeze Panes; the available menu labels can depend on the current web interface. The basic rule is the same: select a cell below any rows and to the right of any columns you intend to freeze. If a command is unavailable, check that the workbook is open for editing rather than in a restricted viewing state.

Common Mistakes

Selecting the columns instead of the boundary cell: Highlighting A:C does not tell Excel where the scrolling area should begin. Select D1 for columns A:C, or the cell just beyond your desired frozen group.
Choosing Freeze First Column: This locks only column A. To keep A:C visible, use the general Freeze Panes command with D1 active.
Freezing extra rows by accident: The general command freezes every row above the selected cell as well as every column to its left. Use a cell in row 1 when you only want columns fixed; use a lower row only when you deliberately want both rows and columns frozen.
Expecting to freeze columns in the middle: Freeze Panes keeps a continuous block beginning at column A. It cannot pin, for example, column F while allowing B:E to scroll independently. Rearrange the columns so the ones you need are at the left, or consider another way to view the data.
Using Freeze Panes without clearing an earlier setting: Excel allows one frozen-pane arrangement on a worksheet at a time. A previous freeze may remain in effect, so unfreeze it before setting a different boundary.
Confusing freezing with hiding: A frozen column stays visible and remains part of the worksheet. Hiding a column removes it from view and does not keep it pinned during scrolling.

Tips

Freeze the minimum useful set. Keeping many columns fixed leaves less room for the columns you are trying to inspect. Start with the identifiers people need to recognize a row, such as a code and a short name, rather than freezing every descriptive field.
Use a boundary cell to combine rows and columns. If your sheet has a header in row 1 and you want A:C plus that header to stay in view, select D2 before choosing Freeze Panes. Excel freezes all rows above the active cell and all columns to its left. Check the result, because a cell several rows down freezes all those preceding rows.
Make the frozen area readable. Shorten overly wide headings, adjust column widths, or use Wrap Text before freezing. A fixed group that occupies most of the window can make the scrolling section difficult to use.
Use a table thoughtfully. Excel tables can provide filter buttons and other navigation features, but they do not replace freezing columns. For a very wide table, freeze the leftmost identifiers and use table filters to narrow the records you need.
Remember that scrolling direction matters. Frozen columns are most useful when the sheet is wider than the visible window. They do not prevent vertical scrolling; choose a cell in row 1 if you do not want any rows held in place.
Consider the reader’s screen size. A setup that looks comfortable on a large monitor can crowd the sheet on a laptop. After freezing, check that enough unfrozen columns remain visible to make comparisons practical.

Troubleshooting

The wrong columns or rows are frozen. Choose View > Freeze Panes > Unfreeze Panes first. Then click the correct boundary cell and apply Freeze Panes again. For columns A:C only, use D1. For A:C plus row 1, use D2. Do not try to correct the boundary by selecting a different cell while the old freeze is still active.

The Freeze Panes option is unavailable or does not respond. Confirm that you are in the worksheet grid and that the workbook is editable. A protected sheet or a restricted, read-only view can limit actions. If the file is open in a browser preview or another viewer, open it in the Excel app or obtain editing access, then try the View menu again.

The fixed columns seem to disappear when you scroll. Check whether you are actually scrolling horizontally and whether the boundary is where you expect. The vertical scrollbar moves through rows; frozen columns are meant to stay visible during horizontal movement. If the frozen area is very narrow, use the boundary line and the column letters to confirm which columns are locked.

Too many rows are also fixed. This usually means the selected cell was below row 1. Unfreeze the current arrangement and repeat from a cell in row 1. Excel freezes rows above the selected cell, not just the row containing the active cell.

You need a non-leftmost column to stay visible. Freeze Panes cannot pin an isolated middle column while earlier columns scroll. Move the needed column to the left edge, or create a separate view or copy of the relevant fields. Avoid copying live data unless you have a plan to keep the copy updated; duplicate values can become stale.

The setup looks different on another computer. Check the workbook in the desktop app and confirm the intended worksheet is active. Window size and zoom affect how much of the sheet is visible, but they do not change which columns the freeze boundary represents. If the boundary itself is wrong, unfreeze and set it again from the correct cell.

Frequently Asked Questions

Can I freeze columns A through C in Excel?
Yes. Select D1, then choose View > Freeze Panes > Freeze Panes. This keeps A:C visible and does not freeze any rows.

Can I freeze only columns B and C?
Not while column A scrolls away. Freeze Panes locks a continuous range starting at A. To keep B:C visible, move those columns to the left edge first, or use another layout.

Can I freeze columns and the top row at the same time?
Yes. To freeze A:C and row 1, select D2 before choosing Freeze Panes. Excel fixes the columns to the left and rows above the selected cell.

How do I remove frozen columns?
Go to View > Freeze Panes > Unfreeze Panes. The sheet then scrolls normally. You can select a different boundary and freeze panes again afterward.

Why does Freeze First Column not keep all my chosen columns visible?
That command freezes only column A. Use the general Freeze Panes command and select the cell immediately to the right of the entire group you want fixed.

Does freezing columns change the data or print layout?
No. It changes the on-screen worksheet view, not the cell contents or the printed page layout. If you need repeated columns on printed pages, use the separate print title settings rather than 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.