How to Freeze Multiple Columns in Microsoft Excel

When working with extensive Microsoft Excel worksheets that span dozens of columns—such as annual financial reports, customer databases, or product inventory tables—scrolling to the right hides your identifying columns. Suddenly, you are viewing numbers in Column Z without knowing which employee name, account number, or product SKU that data belongs to.

While Excel includes a convenient “Freeze First Column” button, that preset strictly freezes Column A alone. If your identifying records span Columns A, B, and C (such as First Name, Last Name, and Employee ID), you need to freeze multiple columns at once. Here is how to freeze multiple columns in Microsoft Excel.


Step-by-Step: Freeze Multiple Columns Simultaneously

The secret to freezing multiple columns in Excel lies in selecting the cell immediately to the right of your target columns:

  1. Open your spreadsheet in Microsoft Excel.
  2. Determine which columns you want locked on screen (for example, Columns A, B, and C).
  3. Click to select the cell in the first unpinned column directly in row 1—in this example, click on cell D1 (or click the column letter D header).
  4. Navigate to the View tab on the Excel ribbon.
  5. In the Window group, click the Freeze Panes drop-down menu.
  6. Select the first option: Freeze Panes (do not click Freeze First Column).

Excel will place a distinct vertical border line between Column C and Column D. Now, scroll horizontally to the right across your sheet; Columns A, B, and C will remain permanently pinned to the left edge of your screen while the rest of your data scrolls smoothly underneath.


How to Freeze Multiple Columns AND the Top Header Row Together

In most professional workbooks, you want both your top header row and your left identifying columns locked at the same time:

  1. If you previously froze panes, go to View > Freeze Panes > Unfreeze Panes.
  2. Identify your target rows and columns (e.g. Row 1 for headers, and Columns A and B for names).
  3. Click the cell located immediately below your header row and to the right of your columns—in this case, click cell C2.
  4. Go to the View tab on the ribbon.
  5. Click Freeze Panes > Freeze Panes.

Excel will freeze both axes at once: scrolling downward keeps Row 1 visible, while scrolling rightwards keeps Columns A and B visible.


How to Unfreeze Columns in Microsoft Excel

To restore standard scrolling behaviour across your entire sheet:

  1. Click anywhere in the worksheet.
  2. Go to the View tab on the ribbon.
  3. Click Freeze Panes.
  4. Select Unfreeze Panes.

The divider lines will disappear immediately, restoring standard two-way scrolling across all rows and columns.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.