• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Freeze Columns in Excel

May 23, 2021 by Andrew Childress
Freeze columns Excel

If you’re working with a multi-column spreadsheet, you might want to keep certain columns in view at all times. Here's how to freeze columns in Excel.

If you’re working with a multi-column spreadsheet, you might want to keep certain columns in view at all times. This is especially useful if you have a column containing row labels, for example. This is easy to set up in a spreadsheet. Let’s learn how to freeze columns in Microsoft Excel.

How to Freeze the First Column in Excel

Consider a spreadsheet with multiple columns of data. Column A contains a User ID number that you want to keep visible, even if you scroll out of view of column A to the right. Your solution? Excel’s built-in Freeze Panes feature.

To freeze the first column in any spreadsheet, click into any cell on your worksheet. Then, go to the View tab on Excel’s ribbon. On the right side, you’ll see the option to Freeze First Column. Click on the button.

Freeze columns Excel

Now, when you scroll to the right, column A will remain in view on the left. In essence, Excel places it above your other data, so you’ll always be able to see the data contained inside it, no matter how far you scroll.

Freeze columns in Excel

To undo this, simply click Unfreeze Panes on the View tab.

How to Freeze Multiple Columns in Microsoft Excel

Now, imagine that you want to freeze the first three columns, with the User ID, First Name, and Last Name. With Excel, you can freeze as many columns as you want.

There’s a quick rule of thumb to use. To freeze multiple columns, always select the column to the immediate right of the last column that you want to freeze.

Here, click on column D‘s header to select the column. Then, on the View tab, click Freeze Panes.

How to freeze columns in Excel

When you scroll, columns A, B, and C are now frozen, always remaining in view.

How to freeze columns in Excel

As you can see, it’s easy to freeze columns in Excel so that you can always see data that’s important to your work.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to filter in ExcelFilter in Excel
Next Post:Move Cells in ExcelMove cells Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top