How to Freeze More than One Column in Excel

PDF download Download Article
PDF download Download Article

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

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Freeze-More-than-One-Column-in-Excel-Step-1.jpg\/v4-460px-Freeze-More-than-One-Column-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/b\/bc\/Freeze-More-than-One-Column-in-Excel-Step-1.jpg\/aid11642930-v4-728px-Freeze-More-than-One-Column-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/93\/Freeze-More-than-One-Column-in-Excel-Step-2.jpg\/v4-460px-Freeze-More-than-One-Column-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/9\/93\/Freeze-More-than-One-Column-in-Excel-Step-2.jpg\/aid11642930-v4-728px-Freeze-More-than-One-Column-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Freeze-More-than-One-Column-in-Excel-Step-3.jpg\/v4-460px-Freeze-More-than-One-Column-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/2\/22\/Freeze-More-than-One-Column-in-Excel-Step-3.jpg\/aid11642930-v4-728px-Freeze-More-than-One-Column-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this either in the editing ribbon above the document space or at the top of your screen.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Freeze-More-than-One-Column-in-Excel-Step-4.jpg\/v4-460px-Freeze-More-than-One-Column-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/3\/3d\/Freeze-More-than-One-Column-in-Excel-Step-4.jpg\/aid11642930-v4-728px-Freeze-More-than-One-Column-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A menu will drop-down. You have options to freeze specific panes or freeze the first column and row.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Freeze-More-than-One-Column-in-Excel-Step-5.jpg\/v4-460px-Freeze-More-than-One-Column-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/4\/49\/Freeze-More-than-One-Column-in-Excel-Step-5.jpg\/aid11642930-v4-728px-Freeze-More-than-One-Column-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will freeze the panes in the columns next to what you have selected. [2]
    6. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to Make a Google Spreadsheet: Beginners Guide
      3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel
      How to
      Add the Same Value to Multiple Cells in Excel
      How to
      Add Rows to a Pivot Table
      How to Add Custom Calculated Fields to Pivot Tables in Excel
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      3 Simple Ways to Create a Shared Spreadsheet
      How to Change the X Axis Scale in an Excel Chart
      How to
      Add a Row to a Table in Excel
      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

      Article Summary X

      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?
      In other languages
      Thanks to all authors for creating a page that has been read 58,605 times.

      Is this article up to date?

      Advertisement