How to Freeze a Column in Excel: 8 Methods (Plus Troubleshooting)

Method 1: Freeze the First Column (The Quickest Option)

This is the go-to method when only the leftmost column needs to stay visible, usually a list of names, IDs, dates, or labels that the rest of the row depends on.

Steps:

1. Open the Excel spreadsheet.

2. Select the View tab at the top of the Excel window.

3. In the Window group, click Freeze Panes to open the drop-down menu.

4. Select the Freeze First Column option.

A faint vertical line is displayed to the right of column A. Scrolling right keeps the first column locked in view. No cell selection is required ahead of time. Excel always freezes column A regardless of cursor position or which cell is active.

Method 2: Freeze Multiple Columns at Once

When the goal is to freeze multiple columns, such as a customer ID and a customer name together, the cell or column selection step matters.

Steps:

1. Click the column letter of the column directly to the right of the last column to freeze. For example, to freeze the first two columns (columns A and B), select column C. To freeze the first three columns, select column D. The third column from the left becomes the boundary in that second case.

2. Navigate to the View tab.

3. Click Freeze Panes, then select Freeze Panes from the drop-down menu.

The first two or three columns now stay anchored as the rest of the worksheet scrolls horizontally. The faint freeze line appears to the left of the selected column.

A common mistake here is clicking inside a single cell rather than selecting the full column header. Excel uses the cell selection to determine the freeze point, and freezing happens above and to the left of the selected cell. Selecting cell C1 produces the same result as selecting column C in this case, but selecting C5 freezes the first four rows as well, which may or may not be the goal.

Method 3: Keyboard Shortcut for Freeze Panes

Excel does not assign a single key combo to Freeze Panes, but the ribbon shortcut sequence works fast once memorized.

Windows shortcut: Press Alt, then W, then F, then F again.

The sequence breaks down as:

• Alt activates the ribbon shortcuts.
• W selects the View tab.
• F opens the Freeze Panes drop-down menu.
• F selects Freeze Panes, the first option in the menu.

To freeze the first column instead, the sequence is Alt > W > F > C. To freeze the top row, it is Alt > W > F > R. These shortcuts work regardless of cursor position in the sheet.

Mac shortcut: Excel for Mac does not include a dedicated keyboard shortcut for Freeze Panes by default, but a custom shortcut can be assigned through Tools > Customize Keyboard in some versions. Otherwise, the View menu approach takes about the same number of clicks.

Bonus tip: Newer versions of Excel include a "Tell me what you want to do" search box at the top of the window. Type "freeze panes" into that search bar and Excel surfaces the same options without needing to navigate the ribbon at all.

Method 4: Freeze Both Rows and Columns at the Same Time

This is the most powerful version of the feature, useful for spreadsheets where you need to freeze rows and columns to keep headers or key data visible during scrolling. It freezes a top row and a left column together so both stay visible during scrolling.

Steps:

1. Select the cell that sits below the row and to the right of the column that should remain visible. For example, to freeze the first row and the first column, select cell B2. To freeze the first three rows and the first two columns, select cell C4.

2. Navigate to the View tab.

3. Click Freeze Panes > Freeze Panes.

Two faint lines now appear: a horizontal one below the last frozen row and a vertical one to the right of the last frozen column. Scrolling in any direction keeps the chosen rows and columns visible. This is the standard setup for dashboards, financial models, and reports where both row and column headers are the key to reading the data.

To freeze multiple rows on their own without locking any columns, click the row number directly below the last row to freeze, then choose View > Freeze Panes > Freeze Panes. Excel treats rows or columns the same way, so the same menu handles both. To freeze the top row specifically, go to the View tab, select the Freeze Panes dropdown, and choose Freeze Top Row.

Method 5: Unfreeze a Column When the Job Is Done

Frozen panes stay frozen until told otherwise, even after closing and reopening the file. To clear them:

1. Navigate to the View tab.

2. Click Freeze Panes.
3. Select Unfreeze Panes from the top of the drop-down menu.

The faint freeze lines disappear and the sheet scrolls freely again. The same Unfreeze Panes option releases both frozen rows and frozen columns at once. There is no separate "unfreeze rows" or "unfreeze columns" command, because Excel stores the freeze point as a single setting per worksheet. The unfreeze option appears in the same spot where "Freeze Panes" normally sits, replacing the first menu item whenever a freeze is already active.

Method 6: Add a Magic Freeze Button to the Quick Access Toolbar

For spreadsheets where freezing and unfreezing happens often, adding a one-click button to the Quick Access Toolbar saves time and removes the drop-down menu trip.

Steps:

1. Click the small drop-down arrow at the right end of the Quick Access Toolbar (the strip of icons above or below the ribbon).
2. Select More Commands.

3. In the Choose commands from drop-down, select All Commands.

4. Scroll down to Freeze Panes, select it, and click Add.
5. Click OK.

A Freeze Panes icon now appears on the Quick Access Toolbar. One click toggles the freeze on or off based on the current cell selection. This is especially helpful for accountants and analysts who switch between views many times in a single session.

Method 7: Freeze Columns in Excel for the Web and Excel for Mac

The web and Mac versions of Excel handle freeze panes slightly differently from the Windows desktop app.

Excel for the Web (Microsoft 365 online):

1. Click the View tab in the browser ribbon.

2. Click Freeze Panes.
3. Choose Freeze First Column, Freeze Top Row, or Freeze Panes to freeze multiple columns or multiple rows.

The online version supports the same three options as the desktop app, although a few advanced features like Quick Access Toolbar customization stay limited to the desktop release.

Excel for Mac:

1. Click the View tab.

2. Click Freeze Panes.
3. Choose the appropriate option.

On older versions of Excel for Mac, the Freeze Panes button sometimes appears as a single toggle button rather than a drop-down. Clicking it freezes based on the current cell selection, mirroring the Windows behavior.

Method 8: Freeze Columns with a VBA Macro

For repeating the same freeze setup across dozens of spreadsheets, a short VBA macro automates the process. This method assumes some comfort with the Developer tab, but the code itself is short.

Steps:

1. Press Alt + F11 to open the VBA Editor.

2. Click Insert > Module.
3. Paste the following code:

Sub FreezeFirstColumn()
    With ActiveWindow
        .SplitColumn = 1
        .SplitRow = 0
        .FreezePanes = True
    End With
End Sub

Sub FreezeFirstColumn()
    With ActiveWindow
        .SplitColumn = 1
        .SplitRow = 0
        .FreezePanes = True
    End With
End Sub

Sub FreezeFirstColumn()
    With ActiveWindow
        .SplitColumn = 1
        .SplitRow = 0
        .FreezePanes = True
    End With
End Sub

1. Close the editor and run the macro from View > Macros > View Macros, or assign it to a button.

Change SplitColumn = 1 to a larger number to freeze more columns. For example, SplitColumn = 3 freezes the first three columns. Setting SplitRow to a value other than zero freezes that many rows at the top as well, so SplitRow = 3 would freeze the first three rows alongside the columns.

Common Issues and Troubleshooting

Even though Freeze Panes is a simple feature, a few situations trip people up regularly.

When to Use Freeze Panes vs Other Options

Freeze Panes is one of three related features that solve overlapping problems:

• Freeze Panes keeps rows and columns visible during scrolling.
• Split creates independently scrollable views of the same sheet.
• New Window opens a second window of the same workbook, allowing two different views side by side.

For most everyday work, Freeze Panes is the right tool. Split panes work well for comparing two distant parts of the same sheet without scrolling back and forth, and New Window helps with comparing two sheets in the same workbook at the same time.

For Developers: Freezing Columns Programmatically

For teams that generate Excel files from code rather than by hand, the same freeze pane settings can be applied through a library. IronXL is a C# library from Iron Software that reads, writes, and manipulates Excel files without requiring Microsoft Office or Excel Interop. Freezing a column with IronXL takes a single line of code:

using IronXL;
WorkBook workbook = WorkBook.Load("report.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Freeze the first column
sheet.CreateFreezePane(1, 0);
workbook.SaveAs("report-frozen.xlsx");

using IronXL;
WorkBook workbook = WorkBook.Load("report.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Freeze the first column
sheet.CreateFreezePane(1, 0);
workbook.SaveAs("report-frozen.xlsx");

Imports IronXL

Dim workbook As WorkBook = WorkBook.Load("report.xlsx")
Dim sheet As WorkSheet = workbook.DefaultWorkSheet
' Freeze the first column
sheet.CreateFreezePane(1, 0)
workbook.SaveAs("report-frozen.xlsx")

The first argument is the number of columns to freeze from the left, and the second is the number of rows to freeze from the top. Passing (2, 1) would freeze the first two columns and the top row together. Full code samples for the two-parameter and four-parameter versions of the method can be found out in the C# Freeze Panes code example guide.

Wrapping Up

Freezing a column in Excel takes a single click for the most common case and a single menu trip for almost every other case. The View tab handles all of it: Freeze First Column to freeze the first column, Freeze Panes to freeze multiple columns or multiple rows, Freeze Top Row for the top row, and Unfreeze Panes to clear the setting. Keyboard shortcuts, the Quick Access Toolbar, and VBA macros offer faster alternatives for power users, and the troubleshooting steps above cover the handful of cases where the option appears greyed out or behaves unexpectedly.

This guide was written by the creators of IronXL and other .NET libraries that handle Excel files programmatically. Teams that need to freeze panes, format cells, or generate spreadsheets from code can follow the step-by-step tutorial for creating Excel files in C# without Office for a full walkthrough of these operations.