3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel

PDF download Download Article
Quick ways to lock one or multiple columns and rows in place as you scroll
PDF download Download Article

Freezing rows or columns in Excel ensures that certain cells remain visible as you scroll through the data. If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier. You can do this whether you're using the desktop application or the mobile app. This wikiHow teaches you how to freeze specific rows and columns in Microsoft Excel using your computer, iPhone, iPad, or Android.

Things You Should Know

  • To freeze the first column or row, click the "View" tab. Click the "Freeze Panes" menu and select "Freeze Top Row" or "Freeze First Column".
  • To unfreeze, click "Freeze Panes" menu and select "Unfreeze Panes".
  • On mobile, tap "Home" → "View" → "Freeze Top Row" or "Freeze First Column". To unfreeze, tap it again.
Method 1
Method 1 of 3:

Freezing the First Column or Row (Desktop)

PDF download Download Article
  1. You can open an existing project or create a new spreadsheet .
  2. It's at the top of Excel. Frozen cells are rows or columns that remain visible while you scroll through a worksheet. [1] If you want column headers or row labels to remain visible as you work with large amounts of data, you'll likely find it helpful to lock those cells into place.
    • Only whole rows or columns can be frozen. It is not possible to freeze individual cells.
    Advertisement
  3. It's in the "Window" section of the toolbar. A drop-down menu will open with a set of three freezing options. [2]
  4. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row . To keep the first column in place as you scroll horizontally, select Freeze First Column .
  5. If you want to unlock the frozen cells and scroll normally, click the Freeze Panes menu again and select Unfreeze Panes . [3]
    6. Advertisement
Method 2
Method 2 of 3:

Freezing Multiple Columns or Rows (Desktop)

PDF download Download Article
  1. You can open an existing project or create a new one.
  2. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze. For example: [4]
    • If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it.
    • If you want columns A and B to remain still as you scroll sideways through your data, click column C to select it.
    • Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.
  3. It's at the top of Excel. [5]
  4. It's in the "Window" section of the toolbar. A drop-down menu will open with a set of three freezing options. [6]
  5. It's at the top of the menu. This freezes the columns or rows before the one you selected. [7]
    • When you scroll, those columns or rows will be frozen in place.
  6. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes . [8]
    7. Advertisement
Method 3
Method 3 of 3:

Using Mobile

PDF download Download Article
  1. The app looks like an x on top of a green rectangle.
    • Microsoft Excel is available on iOS and Android.
  2. If you don't see the menu, tap the icon of the A in front of a pencil.
  3. This is at the bottom of the pop-up menu.
  4. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row . To keep the first column in place as you scroll horizontally, select Freeze First Column .
  5. If you want to unlock the frozen cells, tap Freeze Top Row or Freeze First Column again to remove the checkmark.
  6. If the data you want to keep stationary takes up more than one row or column, tap the column letter or row number after those you want to freeze. For example:
    • If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, tap row 4 to select it.
      • If you want columns A and B to remain still as you scroll sideways through your data, tap column C to select it.
      • Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.
    • Once selected, tap Home .
    • Tap View .
    • Tap Freeze Panes . This freezes the columns or rows before the one you selected.
    • To unfreeze, tap Freeze Panes again to remove the checkmark.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I freeze the top two rows?
    Community Answer
    Select the row directly under the rows you want to freeze (in this case, the third row). Go to View, Freeze Panes, and select "Freeze Panes." Everything above the row you have selected will be frozen.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 11 Helpful 27
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
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      wikiHow Video: How to Freeze Panes in Excel

      Watch


      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      The Best Ways to Make & Format Lists in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
      2. ↑ https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
      3. ↑ https://support.microsoft.com/en-us/office/unfreeze-locked-panes-4230b27b-a5a0-41ae-9a58-7d7fb9e05a8e
      4. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      5. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      6. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      7. ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
      8. ↑ https://support.microsoft.com/en-us/office/unfreeze-locked-panes-4230b27b-a5a0-41ae-9a58-7d7fb9e05a8e

      About This Article

      Article Summary X

      1. Click View .
      2. Click Freeze Panes .
      3. Select Freeze Top Row or Freeze First Column .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 239,376 times.

      Reader Success Stories

      • Paramesh Periyakani

        Jan 11, 2018

        "It helped to finish my task with in the stipulated time."
        Rated this article:
      Share your story

      Is this article up to date?

      Advertisement