How to Freeze Selected Columns in Excel Without Scrolling

To keep columns visible while you scroll across a worksheet, select the cell immediately to the right of the columns you want to keep, then choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of that cell, not just a column you click. This is useful for keeping names, dates, or other identifying details in view when a wide sheet extends beyond your screen.

Before you begin, decide whether you need to keep a continuous block of columns starting at column A visible. Excel’s built-in Freeze Panes feature freezes columns from the left edge through the column before your selected cell; it cannot freeze separate, non-adjacent columns while leaving the columns between them scrolling. The instructions below are for Excel for Microsoft 365 on Windows, with notes for Mac and the web version.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
A clear idea of which columns should remain visible. Freeze Panes keeps a continuous block from column A, such as A through C.
A cell to select just to the right of that block. You do not need to select or highlight the full columns.

Step-by-Step

Open the worksheet and identify the columns. Click the worksheet tab containing your data. Decide the last column you want to remain visible as you move horizontally. For example, if columns A through C contain an ID, customer name, and status that you need to reference, column C is the last column to freeze. The columns to the right can then scroll while A through C stay on screen. If the worksheet has several sections, make sure you are working on the tab where you want the setting to apply: frozen panes are set per worksheet.
Choose the cell just to the right of the last column to freeze. For columns A through C, select a cell in column D. If you only want column A frozen, select a cell in column B. The row of the selected cell matters if you also want to freeze rows: choose row 1 to freeze no rows, or choose the row immediately below the rows you want to keep visible. For example, select D2 to freeze columns A through C and row 1 together. Excel uses the selected cell as a boundary: everything above it and to its left is held in place.
Open the Freeze Panes menu. On the Windows ribbon, select the View tab. In the Window group, choose Freeze Panes. Depending on the width of the Excel window, the group or command may appear compact, so look for the View tab’s Freeze Panes button. Do not choose Freeze First Column unless column A alone is what you need; that preset does not use the boundary you selected.
Apply the custom freeze. From the menu, choose Freeze Panes, usually the first option in the menu. Excel freezes the rows above and columns to the left of your selected cell. In the example, selecting D1 and choosing Freeze Panes keeps A:C visible while allowing you to scroll through the rest of the columns. Selecting D2 instead keeps A:C and row 1 fixed. The menu choice and the selected cell work together, so choosing the correct cell before applying the command is essential.
Check that the freeze is working. Use the horizontal scroll bar at the bottom of the worksheet, or hold Shift while scrolling with a mouse wheel if your mouse supports that action. Move to columns farther to the right. The frozen columns should remain visible while the unfrozen columns move. If you froze a row as well, scroll down and confirm that it stays at the top. A thin line at the boundary between frozen and scrolling areas is a visual indicator that panes are frozen.
Adjust the result if you chose the wrong boundary. If too many or too few columns remain fixed, return to View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply Freeze Panes again. Excel does not provide a drag handle for changing the frozen boundary after the panes are set; unfreezing and reapplying is the straightforward way to revise it. Recheck both the horizontal and vertical behavior if you are freezing rows and columns at the same time.
Save the workbook. Freeze settings are part of the worksheet view and are saved with the workbook. Save the file after confirming the result, especially if other people will use it. If a coworker opens the workbook and sees a different position, ask them to check whether panes are frozen and whether they are on the intended worksheet tab.

Example: Suppose a report has Region in column A, Account in B, Owner in C, and monthly figures from D onward. To keep the three identifying columns visible while comparing later months, select D1 and choose View > Freeze Panes > Freeze Panes. If the report’s headings are in row 1 and should also stay visible while scrolling down, select D2 before applying the command instead.

In Excel for Mac, select the boundary cell and use View > Freeze Panes, then choose the Freeze Panes command. Menu wording or placement can vary slightly by release, but the same boundary rule applies. In Excel for the web, open the View tab and use Freeze Panes; if the options or behavior differ in your account, use the desktop app for the most predictable control over a custom row-and-column boundary.

Common Mistakes

Selecting the column to freeze rather than the cell after it. Clicking column C and then choosing Freeze Panes does not mean “freeze C.” Excel interprets the active cell as the boundary. To freeze A:C, select a cell in D; to freeze A alone, select one in B.
Expecting Excel to freeze isolated columns. Freeze Panes works from the top-left corner in one continuous block. You can’t keep A and C fixed while allowing B to scroll independently. If an important field is farther right, consider moving or copying it into a visible column, or use a separate view or worksheet layout.
Choosing Freeze First Column by habit. That preset freezes only column A. It will not freeze several columns based on your selected cell. Use the main Freeze Panes command after selecting the correct boundary for a custom block.
Forgetting the selected row also controls frozen rows. Selecting D2 keeps row 1 and columns A:C frozen. If you select D5, Excel also freezes rows 1 through 4. When you only mean to freeze columns, select a cell in row 1.
Trying to use the command while another mode is active. Excel may disable Freeze Panes while you are editing a cell, working in some page layout views, or using certain protected or shared configurations. Finish editing with Enter or Esc, switch to View > Normal if needed, and try again.

Tips

Keep the frozen block narrow. Frozen columns reduce the space available for scrolling data. Freeze only the fields needed to identify each row; if A:C already take up most of the screen, consider widening the worksheet window or reducing unnecessary column widths.
Use a header row and frozen columns together. Select the cell below the header row and just to the right of the last column you need fixed. This is particularly handy for long lists where you scroll both down through records and across through periods or measures.
Check the active cell before opening the menu. If you are unsure where Excel will draw the boundary, look at the column letters and row numbers around the selected cell. The frozen area extends above and to the left, not including the selected cell itself.
Remember that freezing affects viewing, not data. It does not lock cells against editing, protect formulas, or change what prints. Use worksheet protection for editing restrictions and print-title settings for repeated printed headings; those are separate features.
Use the matching preset for simple cases. If you only need row 1, choose View > Freeze Panes > Freeze Top Row. If you only need column A, choose View > Freeze Panes > Freeze First Column. For a combination or a wider block, select the boundary cell and use Freeze Panes.

Troubleshooting

The wrong number of columns stays visible. Unfreeze the current panes, then check the column letter of your boundary cell. For three frozen columns, the boundary must be in D; for four, it must be in E. Reapply using View > Freeze Panes > Freeze Panes. Also check the selected row, because a cell below row 1 freezes rows above it too.
The frozen columns do not seem to move or the sheet will not scroll. Test with the horizontal scroll bar rather than relying on the mouse wheel, which often scrolls vertically. If you are in a narrow window, the remaining scrollable region may be small. Maximize Excel or reduce the widths of frozen columns, then try again.
Freeze Panes is unavailable or greyed out. Press Enter or Esc to exit cell editing, switch to View > Normal, and check that the worksheet is not in a mode that blocks the command. If the workbook is protected or opened in a restricted state, ask the owner for permission or save an editable copy if you are authorized to do so.
Existing panes behave unexpectedly. Excel allows one frozen-pane setup per worksheet at a time. Choose View > Freeze Panes > Unfreeze Panes first, then create a new setup. Do not try to add a second independent frozen region; the new boundary replaces the old arrangement.
The setting is missing after reopening or sharing. Confirm that the workbook was saved after you applied the freeze, and that you reopened the same worksheet. If it was saved in another format or opened in a different spreadsheet program, view settings may not transfer exactly. Reapply the freeze in Excel and save as an Excel workbook if appropriate.

Frequently Asked Questions

Can I freeze columns that are not next to each other?
No. Excel’s Freeze Panes command holds a continuous block from column A through the column immediately before the selected cell. To keep separated fields visible, rearrange the columns so they are together, or create a separate view or summary layout.

How do I freeze columns and the top row at the same time?
Select a cell in the row immediately below the headings and just to the right of the last column to freeze. For example, select D2 to freeze A:C and row 1. Then use View > Freeze Panes > Freeze Panes.

Can I freeze columns without freezing any rows?
Yes. Select a cell in row 1 just to the right of the last column to freeze. For example, select D1 to keep A:C fixed without freezing a row. Selecting a cell lower down will freeze the rows above it too.

Does Freeze Panes work when I scroll vertically?
Frozen columns remain visible as you scroll horizontally. They are not an extra set of rows, and the feature does not keep arbitrary rows visible while scrolling vertically unless you also set a row boundary. You can freeze rows and columns together with one selected cell.

How do I unfreeze columns?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen boundaries on the active worksheet. You can then select a new boundary cell and apply Freeze Panes again.

Why can’t I freeze column B by itself?
Excel freezes from the left edge, so freezing through column B also keeps column A visible. The built-in command cannot hold B in place while A scrolls. If you need B visible, freeze A:B by selecting C1, or reorganize the sheet so the fields you need are in a continuous block.

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.