Freeze Columns in Excel: Shortcut Keys and Steps

How-to basics · Updated November 20, 2026

To freeze columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right of the columns you want to keep visible, then press Alt, W, F, F in sequence. For example, select B1 to keep column A visible while you scroll. You can also use View > Freeze Panes > Freeze Panes. There is no single dedicated Ctrl-key shortcut for this command; the Alt sequence uses Excel ribbon key tips.

What You’ll Need

  • A workbook open in the Excel desktop app for Microsoft 365 on Windows.
  • A worksheet with at least one column you want to keep visible, and a clear idea of how many columns should stay in place.
  • For the keyboard method, an English-language Excel ribbon or familiarity with the key tips shown on your own screen. Key-tip letters can vary by language and version.

You do not need to select the whole column or change a workbook setting first. Freeze Panes uses the active cell to decide which rows above it and columns to its left remain visible. If you only want column A, Excel also has a simpler First Column command.

Step-by-Step

  1. Open the worksheet and check its layout. Click the worksheet tab that contains the data. If you are working in a filtered or formatted table, identify the columns by their headings before you choose a freeze point. Freezing a pane changes how the sheet scrolls on screen; it does not change the data, print layout, or saved values.
  2. Choose the first column that should scroll. Excel freezes all columns to the left of the active cell, not the column that contains the active cell. To keep only A visible, select B1. To keep A and B visible, select C1. The row number does not need to be 1 if there are rows you also want to freeze, but using row 1 makes the column-only setup easy to understand.
  3. Use the Windows key sequence, if preferred. With the correct cell selected, tap Alt, then W, then F, then F. Press each key one after another rather than holding the whole sequence down as a chord. The sequence opens View, opens Freeze Panes, and chooses Freeze Panes. If Excel displays different key-tip letters on screen, follow those letters instead; the ribbon interface may use different tips in another language or build.
  4. Or use the ribbon. Select View on the ribbon, choose Freeze Panes, then choose Freeze Panes from the menu. This applies the same rule as the shortcut: columns left of the selected cell stay fixed, while columns to its right can scroll. The ribbon is useful the first time because the menu makes the available choices visible.
  5. Test the result by scrolling sideways. Use the horizontal scrollbar at the bottom of the worksheet, or a trackpad or mouse with horizontal scrolling. The frozen columns should remain in place while the other columns move. If the selected cell was C1, for instance, A and B should stay visible as you move to later columns.
  6. Use the single-column option when appropriate. If column A is the only column to retain, choose View > Freeze Panes > Freeze First Column. This avoids selecting B1 manually. The command is intended for the first column only; it is not a way to freeze a chosen column farther to the right while allowing earlier columns to scroll.
  7. Remove the freeze when you no longer need it. Choose View > Freeze Panes > Unfreeze Panes. In Windows, the ribbon key-tip sequence is commonly Alt, W, F, F to toggle the Freeze Panes command when a pane is already frozen, but the most dependable approach is to check the menu and select Unfreeze Panes. Unfreezing removes the current frozen rows and columns together.

Example: Suppose a worksheet has an ID in column A, a name in B, and monthly figures from C onward. If you want the ID and name to remain visible, select C1 and apply Freeze Panes. When you scroll to later months, both identifying columns stay on screen. Selecting B1 instead would freeze only the ID column, which may not be enough to identify each row.

Freeze Panes can freeze rows and columns at the same time. The rule is based on the active cell: Excel keeps the rows above it and the columns to its left. For example, selecting C4 freezes columns A and B, plus rows 1 through 3. If your goal is strictly to freeze columns, select a cell in row 1 so that you do not unintentionally freeze rows as well.

Common Mistakes

  • Selecting the column you want frozen. Excel freezes the columns before the selected cell. Selecting A1 therefore freezes no columns to its left. To freeze A, select B1; to freeze A through C, select D1.
  • Choosing Freeze First Column for a different column. That option always targets column A. To keep a middle set of columns fixed, select the first cell to the right of the desired set and use Freeze Panes.
  • Selecting a cell below the top row by accident. If you select C4, the result includes three frozen rows as well as columns A and B. This can look like Excel has frozen more than requested. Unfreeze, select C1, and apply the command again for columns only.
  • Expecting the frozen area to move with the worksheet. Frozen columns stay anchored at the left edge of the worksheet window. If you need to compare a different group of columns, unfreeze the panes and set a new boundary.
  • Using Split instead of Freeze Panes. Split creates separate worksheet areas that can scroll independently. It is a different feature and may not keep the identifier columns fixed in the way you expect. Check View > Freeze Panes for the specific freeze commands.
  • Trying to freeze several separate columns but not the ones between them. Freeze Panes retains a continuous block from column A to the selected boundary. It cannot pin A and D while allowing B and C to scroll independently.

Tips

  • Keep labels and identifiers together. When reviewing wide reports, freezing a row ID and a description column can be more useful than freezing only the first field. Select the first cell after the complete block you want to keep visible.
  • Use a visible boundary. After freezing, Excel shows a line marking the edge of the frozen area. Check that line before scrolling far across the sheet. If it sits in the wrong place, unfreeze and reset the selection rather than trying to drag the boundary.
  • Combine a header row with columns when useful. Select the cell below the rows to retain and to the right of the columns to retain. For example, selecting C2 freezes row 1 and columns A:B. This is handy for a table with headers, but it is not a columns-only setup.
  • Remember that the setting belongs to the worksheet view. A freeze applied on one sheet does not automatically freeze the same columns on every other sheet. Repeat the steps on each worksheet where you need the same scrolling behavior.
  • Use the ribbon when key tips do not match. The Alt sequence depends on Excel’s displayed key tips and can differ with the interface language or application version. The View menu works without memorizing those letters.
  • On Mac, use the menu rather than the Windows sequence. Excel for Mac does not use the same Windows Alt key-tip sequence. Select the target cell, then use View > Freeze Panes and choose the relevant freeze option. In Excel for the web, use the View tab and its Freeze Panes menu; the Windows desktop key sequence may not be available in the browser.

Troubleshooting

Nothing seems to happen after the shortcut. Confirm Excel is the active application and that you are in the worksheet, not editing text in a cell or typing in the formula bar. Press Esc once to leave cell-edit mode, click the intended cell, and try the ribbon path. On a laptop, function or system-key settings do not usually affect this Alt sequence, but key-tip letters can vary; follow the letters Excel shows after you press Alt.

The wrong columns remain fixed. First choose View > Freeze Panes > Unfreeze Panes. Then click the first cell to the right of the exact columns you want to keep, ideally in row 1 if you do not want any rows frozen. Apply Freeze Panes again and check the boundary line. Remember that selecting D1 freezes A through C, not only column C.

Rows are frozen too. Excel likely used a cell below row 1 when Freeze Panes was applied. Unfreeze, select the needed boundary cell in row 1, and repeat. The exception is when you intentionally want the header row fixed as well; then select a cell below that header and to the right of the columns to retain.

The Freeze Panes menu is unavailable or the sheet behaves unexpectedly. Check whether the workbook or worksheet is protected, whether you are in cell-edit mode, and whether another window or dialog is active. If the command is disabled, leave editing mode and inspect the Review tab for protection controls; only remove protection if you are authorized and have the password or permission. Also check that you are not confusing a split view with frozen panes. Use View > Freeze Panes > Unfreeze Panes if that option is available, then set the freeze again.

You are using Excel for the web or Mac. The Windows key-tip sequence is not a universal shortcut. Use the View menu in the app you have open and look for Freeze Panes or its equivalent. If the menu offers only first-row or first-column freezing, check that you are in the desktop app or consult the current options for that Excel version; browser and Mac interfaces can differ from Windows desktop.

Frequently Asked Questions

Is there a direct keyboard shortcut to freeze columns in Excel?
On Windows desktop Excel, use Alt, W, F, F in sequence to apply Freeze Panes to the selected cell. It is a ribbon key-tip sequence, not a single Ctrl shortcut. Use the View menu if the displayed key tips differ.

How do I freeze only column A?
Select View > Freeze Panes > Freeze First Column. You can also select B1 and use Freeze Panes. Both approaches keep A visible while you scroll horizontally.

How do I freeze columns A and B?
Select C1, then choose View > Freeze Panes > Freeze Panes, or use the Windows key-tip sequence. Because the active cell is C1, all columns to its left, A and B, remain fixed.

Can I freeze columns and the top row together?
Yes. Select the cell below the row or rows you want frozen and to the right of the columns you want frozen. To retain row 1 and columns A:B, select C2 and apply Freeze Panes. Excel freezes everything above and to the left of that cell.

Can I freeze a column that is not the first column?
You can freeze a block that ends at any column, but the block always starts at A. To keep columns A through D, select E1. Excel cannot freeze just column D while columns A through C scroll away.

How do I undo or change a freeze?
Choose View > Freeze Panes > Unfreeze Panes, then select a new boundary cell and apply the command again. Unfreeze Panes clears the current frozen rows and columns together, so reapply any row freeze you still want afterward.

Related

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.