How to Freeze a Column in Excel So It Stays Visible When Scrolling Right

When you scroll right in a wide Excel sheet, your header column disappears. This makes it hard to know which row of data you are viewing. The Freeze Panes feature locks specific rows or columns in place. This article explains how to freeze the first column or any column to keep it visible.

Understanding the Freeze Panes Feature

The Freeze Panes command is part of the View tab in Excel. It splits the worksheet window into separate panes and locks specific ones. You can freeze the top row, the first column, or a custom selection of rows and columns. The frozen section stays visible while the rest of the sheet scrolls normally. This is essential for working with large datasets where row or column headers provide critical context.

How Freezing Affects Scrolling and Selection

When you freeze a column, a thin solid line appears to its right, indicating the split between frozen and scrollable areas. You cannot scroll the frozen pane. However, you can still select cells, edit data, and apply formatting within it. The feature works in all current versions of Excel for Windows, including Microsoft 365, Excel 2021, and Excel 2019. It is also available in Excel for the web and Mac, though menu locations may differ slightly.

Steps to Freeze the First Column

Use this method when you want to lock only column A, which often contains row labels or identifiers.

1. Open your Excel workbook
   Navigate to the worksheet containing the data you want to work with.
2. Click the View tab
   Find the View tab on the Excel ribbon at the top of the window.
3. Click Freeze Panes
   In the Window group of the View tab, click the Freeze Panes button.
4. Select Freeze First Column
   From the dropdown menu, click the “Freeze First Column” option. A gray line will appear between column A and column B.

Steps to Freeze Multiple Columns

Use this method to freeze more than one column, such as columns A and B. The rule is that Excel freezes all columns to the left of your selected cell.

1. Select the cell to the right of the last column you want to freeze
   To freeze columns A and B, select cell C1. This tells Excel to freeze everything to the left of column C.
2. Go to the View tab
   Click the View tab on the ribbon.
3. Click Freeze Panes
   In the Window group, click the Freeze Panes button.
4. Select Freeze Panes
   Click the top command in the dropdown list, which is also named “Freeze Panes”. A line will appear to the left of your selected cell.

Common Mistakes and Limitations

Freeze Panes Option is Grayed Out

If the Freeze Panes command is unavailable, you are likely in cell editing mode or the worksheet is protected. Press Escape to exit cell edit mode. To remove worksheet protection, go to Review > Unprotect Sheet. The feature is also disabled if the workbook is shared or if you are viewing it in Page Layout view. Switch to Normal view via View > Workbook Views > Normal.

Frozen Column Disappears in Print Preview

The Freeze Panes setting only affects the on-screen view. It does not repeat columns on every printed page. To print column headers on each page, you must set print titles. Go to Page Layout > Print Titles. In the Sheet tab, under “Rows to repeat at top” or “Columns to repeat at left”, specify the columns you want to print on every page.

Accidentally Freezing the Wrong Panes

A common error is selecting the wrong cell before using Freeze Panes, which locks unintended rows and columns. Always remember the rule: Excel freezes rows above and columns to the left of the active cell. If you make a mistake, immediately use View > Freeze Panes > Unfreeze Panes to clear all locks and start over.

Freeze First Column vs Freeze Panes: Key Differences

Item	Freeze First Column	Freeze Panes
Primary use	Lock only column A	Lock multiple columns or rows based on cell selection
Selection required	No, works from any cell	Yes, requires selecting the correct cell
Flexibility	Fixed, only one column	Customizable for any number of columns
Menu path	View > Freeze Panes > Freeze First Column	View > Freeze Panes > Freeze Panes
Visual indicator	Solid line between column A and B	Solid lines above and to the left of the selected cell

You can now keep your key data visible while navigating wide spreadsheets. Use Freeze First Column for simple locking or the custom Freeze Panes command for more control. Try combining frozen rows and columns by selecting a cell below and to the right of the area you want to lock. For large datasets, also consider using the Split command on the View tab to create two independently scrollable panes within the same window.