How to Freeze More than One Column in Excel

This wikiHow will show you how to freeze panes to lock columns in Excel. When you freeze a column, it will stay visible when you're scrolling through that worksheet.

Steps

  1. Image titled Freeze More than One Column in Excel Step 1
    1
    Open your project in Excel. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
    • This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019 , Excel 2016, Excel 2013, Excel 2010, Excel 2007.[1]
  2. Image titled Freeze More than One Column in Excel Step 2
    2
    Select a cell to the right of the column you want to freeze. The frozen columns will remain visible when you scroll through the worksheet.
    • You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.
    Advertisement
  3. Image titled Freeze More than One Column in Excel Step 3
    3
    Click View. You'll see this either in the editing ribbon above the document space or at the top of your screen.
  4. Image titled Freeze More than One Column in Excel Step 4
    4
    Click Freeze Panes. A menu will drop-down. You have options to freeze specific panes or freeze the first column and row.
  5. Image titled Freeze More than One Column in Excel Step 5
    5
    Click Freeze Panes. This will freeze the panes in the columns next to what you have selected.[2]
    6. Advertisement

You Might Also Like

Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
How Do You Write an if then Formula in ExcelHow to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
Use Google SpreadsheetsHow to Use Google Sheets: The Ultimate Guide for Getting Started
Add a Custom Field in Pivot TableHow to Add Custom Calculated Fields to Pivot Tables in Excel
Add Two Cells Containing the Sum of Other Formulas in Excel
How to
Add Two Cells Containing the Sum of Other Formulas in Excel
Add the Same Value to Multiple Cells in Excel
How to
Add the Same Value to Multiple Cells in Excel
Create a Form in a Spreadsheet
How to
Create a Form in a Spreadsheet
Show the Max Value in an Excel Graph
How to
Show the Max Value in an Excel Graph
Add Rows to a Pivot Table
How to
Add Rows to a Pivot Table
Create a Formula to Increase a Date by 1 Month
How to
Create a Formula to Increase a Date by 1 Month
Change X Axis Scale in ExcelHow to Change the X Axis Scale in an Excel Chart
Change an Excel Sheet from Read Only
How to
Change an Excel Sheet from Read Only
Make a Shared Spreadsheet
How to
Make a Shared Spreadsheet
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Advertisement

References

  1. ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-the-first-row-or-column-in-excel-for-mac-b8eb717e-9d3e-4354-8c02-d779a4b404b2
  2. ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

About This Article

Darlene Antonelli, MA
Written by:
Darlene Antonelli, MA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. This article has been viewed 48,585 times.
How helpful is this?
Co-authors: 2
Updated: January 20, 2020
Views: 48,585
Categories: Spreadsheets
Article SummaryX

1. Open your project in Excel.
2. Select cell to the right of the column you want to freeze.
3. Click View.
4. Click Freeze Panes.
5. Click Freeze Panes.

Did this summary help you?
Advertisement