How to Freeze Specific Columns in Excel While Scrolling

To freeze columns in Excel, select the cell immediately to the right of the last column you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes every column to the left of that cell, not just an isolated column. This keeps labels or identifying details on screen as you scroll through a wide worksheet.

These instructions are for Microsoft Excel for Microsoft 365 on Windows. The same basic Freeze Panes command is available in Excel for Mac and Excel for the web, though ribbon layout and menu placement can vary slightly. Before starting, decide which columns need to stay visible and whether you also want to keep a header row on screen.

What You’ll Need

An Excel workbook with the worksheet you want to adjust.
A clear idea of the last column you want frozen. Excel freezes a continuous block beginning at column A, so freezing column D also freezes A, B, and C.
If the sheet is shared or important, permission to change its view settings. Freeze Panes changes the worksheet view, not the cell contents.

Step-by-Step

Open the worksheet and check its layout. Open the workbook, then click the sheet tab that contains the data. Identify the columns that contain information you need to see while moving horizontally, such as an ID, customer name, date, or product. If those columns are A through C, for example, the freeze boundary should be immediately after C. Freeze Panes works on the active worksheet, so confirm you are on the correct tab before continuing.
Choose how much to freeze. Excel can freeze columns only as a continuous block starting at the left edge of the worksheet. If your key data is in column A, use the built-in First Column command. If you need A through C visible, use Freeze Panes and set the boundary after C. You cannot use the command to freeze only column A and column C while allowing B to scroll independently. If the columns you need are separated, consider rearranging the worksheet or using a separate summary sheet.
Select the cell just beyond the freeze boundary. To freeze columns A through C and no rows, click cell D1. To freeze only column A, click B1. In general, click the first cell to the right of the columns you want to retain. The selected cell is a boundary marker: Excel freezes the columns to its left. Do not select a cell inside the block you want to freeze, or the boundary will be in the wrong place.
Freeze the selected columns. On Windows, open the View tab, choose Freeze Panes in the Window group, then select Freeze Panes from the menu. In Excel for Mac, use View > Freeze Panes > Freeze Panes; the exact ribbon grouping may differ by release. In Excel for the web, open View and look for Freeze Panes. If the menu offers a choice based on the current selection, use that option after selecting the boundary cell.
Test the result by scrolling horizontally. Use the horizontal scroll bar at the bottom of the sheet, or hold Shift while using the mouse wheel if your mouse and Excel settings support horizontal scrolling. Columns to the right should move, while the frozen block stays in place. If you froze A through C, those three columns remain visible and the worksheet can scroll from D onward. A divider line near the freeze boundary can help show where the frozen area ends.
Freeze columns and a header row together, if needed. Select the cell one column to the right of the frozen columns and one row below the rows you want to keep visible. For example, to freeze row 1 and columns A through C, select D2, then choose View > Freeze Panes > Freeze Panes. The rule is that Excel freezes rows above the selected cell and columns to its left. This is useful when column headings are in the first row and you need them visible during both vertical and horizontal scrolling.
Use a preset for one simple case. To freeze just the first column, choose View > Freeze Panes > Freeze First Column without needing to select a cell first. To freeze the top row instead, choose View > Freeze Panes > Freeze Top Row. These presets are convenient for a single row or first column. For multiple columns, or for a combination of rows and columns, select the appropriate boundary cell and use Freeze Panes.
Save the workbook if you want to keep the view. Freeze Panes does not alter values, formulas, formatting, or the order of the data. Save the workbook normally if you want the worksheet to open with the view arrangement retained. If other people use the workbook, tell them that the pane setting is a viewing aid and that they can remove it from the same menu.

Common Mistakes

Selecting the column you want frozen instead of the next column. To freeze A through C, choose a cell in column D. Selecting C1 would freeze only the columns to the left of C, which means A and B. Think of the selected cell as the first unfrozen position.
Expecting Excel to freeze separate, non-adjacent columns. Freeze Panes always retains a contiguous area at the top-left of the sheet. It cannot pin column A and column D while column B and C scroll away. Rearrange columns so the important fields sit together, or create a compact report sheet containing the fields you need.
Using Freeze First Column when several columns are needed. This preset freezes only column A. For A through D, select E1 and use the general Freeze Panes command instead. A preset does not infer which columns matter based on their contents.
Forgetting that the active sheet matters. Freeze settings apply to the current worksheet. Clicking another sheet may make it seem as though the setting disappeared, when that sheet simply has a different view. Reopen the original sheet to check it.
Choosing a cell too far down or too far right. Freeze Panes also locks rows above the active cell. If you select D5, Excel freezes columns A through C and rows 1 through 4, not just the columns. Select D1 when you want columns only.
Confusing frozen panes with locked cells. Freezing is a display feature; it does not protect data from editing. To restrict edits, you would need worksheet protection, which is a separate feature.

Tips

Keep the frozen area narrow. A large block of frozen columns leaves less room for the scrolling data, especially on a laptop screen. Freeze only the fields that help identify each row, such as a record number and name.
Use a descriptive leftmost column where possible. If column A contains a unique ID and the rest of the identifying fields are farther across the sheet, moving those fields together at the left can make navigation easier. Make structural changes carefully, especially if formulas, charts, or other worksheets refer to those columns.
Combine a header row with columns for large tables. Keeping the column labels at the top and an identifier at the left makes it easier to interpret values far down and across a sheet. Select the cell at the intersection of the first unfrozen row and first unfrozen column; for row 1 plus columns A and B, select C2.
Remember the active cell when setting both directions. If you need two header rows and columns A through C, select D3. Excel freezes rows 1 and 2 and columns A through C. This boundary rule is more reliable than choosing a preset when the layout is customized.
Use Split only when you need independently movable panes. The Split command divides the worksheet view into sections that can scroll separately. It is not the same as keeping selected columns fixed while the rest scrolls, and it does not let you pin non-adjacent columns in the ordinary Freeze Panes sense.

Troubleshooting

The wrong columns stay visible: Remove the current freeze using View > Freeze Panes > Unfreeze Panes. Then select the correct boundary cell and apply Freeze Panes again. For A through C only, use D1. If the sheet also needs its first row fixed, use D2. Unfreezing and resetting is usually faster than trying to adjust an existing boundary.

The menu item is unavailable or the worksheet will not respond: Check whether the workbook is in a restricted state, such as being opened read-only, or whether the worksheet or workbook view is limited by its current environment. Try opening the file in the desktop Excel app if you are using a browser, and confirm that you can edit or change the view. Also check that you are looking at a normal worksheet rather than a chart sheet, which does not have the usual cell grid for setting a boundary.

The top rows are frozen when you wanted columns only: This usually happens because the selected cell was below row 1. Unfreeze the panes, select a cell in row 1 immediately to the right of the desired columns, and apply Freeze Panes. For instance, use D1 to freeze A through C without freezing any rows.

Frozen columns seem to vanish after switching sheets: Freeze settings belong to individual worksheets. Return to the sheet where you set them, or repeat the process on each worksheet that needs its own frozen columns. If the divider is hard to see, scroll horizontally and look for the point where the movable area begins.

You cannot freeze only the columns you picked: This is a built-in limitation, not a problem with the workbook. Excel freezes from column A through the selected boundary. Move the necessary columns together at the left, or create a separate view with only the desired fields. Avoid relying on hidden columns as a substitute if users need a clear, consistent layout; hidden columns may confuse navigation and references.

Frequently Asked Questions

Can I freeze only column C in Excel?
Not by itself with Freeze Panes. To keep column C visible, Excel must also keep columns A and B visible because the frozen area is continuous from the left edge. Select D1 to freeze A through C.

Can I freeze columns that are not next to each other?
No. Freeze Panes cannot keep separated columns fixed while columns between them scroll. Put the needed columns next to each other at the left of the worksheet, or build a separate sheet for the view you want.

How do I freeze columns and the top row at the same time?
Select a cell below the row or rows to freeze and to the right of the columns to freeze. To retain row 1 and columns A through C, select D2 and choose View > Freeze Panes > Freeze Panes.

How do I unfreeze columns?
Choose View > Freeze Panes > Unfreeze Panes. The frozen area will become part of the normal scrolling worksheet again. You can then set a different boundary if required.

Does freezing columns protect them from changes?
No. It only keeps the columns visible while navigating the sheet. It does not prevent someone from editing or deleting their contents; use worksheet protection separately if you need to limit edits.

Will frozen columns stay visible when I print?
Freeze Panes controls the on-screen view, not printed page layout. To repeat columns on printed pages, use the print-title settings under Page Layout > Print Titles and set the columns to repeat at the left.

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.