• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Freeze or Unfreeze Panes, Columns, and Rows in Excel

Freeze or Unfreeze Panes, Columns, and Rows in Excel

By Mitch Bartlett 7 Comments

In Microsoft Excel 2019, 2016, and , you can freeze rows and columns so that when you scroll, those panes stay in place. This can be handy for header sections so that you can see your headers no matter where you scroll to in the spreadsheet.

Freezing a Row

  1. Select the row below the row you want to freeze. To select a row, you need to select the entire row on the left side.
  2. With the row selected, click on the “View” tab at the top, select “Freeze Panes” and you’ll see several different options you can choose:
    • “Freeze Panes” will freeze all rows above your selected row.
    • “Freeze Top Row” will freeze only the top row no matter what row you currently have selected.

Note: If you don’t see the “Freeze Panes” option, it might be because you already have panes frozen. Select “Unfreeze Panes” to start over.


Freezing a Column

  1. To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze.
  2. With the column selected, click on the “View” tab at the top, select “Freeze Panes” and you’ll see several different options you can choose:
    • “Freeze Panes” will freeze all columns to the left of your selected column.
    • “Freeze First Column” will freeze only the left most column no matter what column you currently have selected.

Freezing Columns and Rows

Freezing a column and a row at the same time is a bit trickier unless you only want to freeze the left column and the top row, since those options are there all the time.

  1. To freeze a set of columns and rows at the same time, click on the cell below and to the right of the panes you want to freeze. For example, if you wanted to freeze column A and row 1, you would select cell B2 since it’s below and to the right of these columns and rows.
  2. With the proper cell selected, select the “View” tab at the top and click on the “Freeze Panes” button, and select the “Freeze Panes” option in the drop-down.

Unfreeze Panes

To unfreeze your panes at any time, just click on the “View” tab and click the “Freeze Panes” button, then select “Unfreeze Panes“.

You Might Also Like

  • Excel 2016: Unhide Rows or Columns
    Excel 2016: Unhide Rows or Columns
  • Hide and Unhide Rows and Columns in Google Sheets
    Hide and Unhide Rows and Columns in Google Sheets
  • How to Erase Multiple Excel Rows Simultaneously
    How to Erase Multiple Excel Rows Simultaneously
  • Word 2016 & 2013: Divide Page Into Columns
    Word 2016 & 2013: Divide Page Into Columns
  • How to Add a PDF to Excel
    How to Add a PDF to Excel
  • Excel: Shade Every Other Row
    Excel: Shade Every Other Row
  • Excel: Add Watermark
    Excel: Add Watermark
  • Fix Excel Freezing or Slow
    Fix Excel Freezing or Slow
  • Excel Calculations Are Wrong
    Excel Calculations Are Wrong

Filed Under: Office Tagged With: Excel 2016, Excel 2019, Office 365

Reader Interactions

Comments

  1. Oleksandr says

    May 5, 2021 at 1:57 pm

    That was very helpful for me. Now I can continue tracking my sleep & workout & productivity info and have the describes on top, thank you for this post

  2. Kim Wilson says

    May 4, 2021 at 10:57 am

    Thank you so much! It’s so easy to click the first cell below the row and to the right of the column
    I really liked the older Excel when you could drag it to where you wanted it, but now that I know this, it’s much easier.

    :-)

  3. Beth says

    September 25, 2020 at 10:19 am

    Fixed my issue – thanks for the help!

  4. Alison M says

    August 29, 2020 at 10:45 am

    Did not help; sorry. In a large spreadsheet, the row you wish to place at the top (i.e. right under the header row) can be many hundreds or thousands of rows down. For example, you want to ‘collapse’ previous years’ figures and have the current year start at the top. But you still want to be able to page or scroll up into last year if you need to. ** That is what I need help with, ** yet no-one seems to consider the possibility. One used to be able to do with with Excel 2003 and I’m assuming it’s still possible, somehow.

  5. SLM says

    November 8, 2019 at 12:09 pm

    Excellent, thank you for this tip on freezing BOTH row & column!

  6. R says

    December 6, 2018 at 4:27 pm

    I am having the same problem – I type and Excel just Freezes the Cells so nothing can be entered and then – under the view – there is no unfreeze button – P8Ss Poor Software .

  7. William Marchesani says

    November 17, 2018 at 2:55 pm

    Absolutely NOT.
    I’m using Excel for Android, on my Note 4. Froze panes, and now, NOWHERE does it show Unfreeze.
    I should have never used a computer like device to track my workout.
    Back to pencil and small notepad.

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: How to Add Clocks with Different Time Zones
  • Google Assistant: How to Never Miss a Birthday
  • Windows 11: How to Disable Notifications and Ads
  • How to Use Oculus Quest 2 Air Link
  • How to Create an Avatar in the Oculus Quest 2
  • 5 Free and Fun Math Apps for Kids
  • Windows 11: How to Discover What Graphics Card You’re Using
  • How to Change Display Resolution on Windows 10 and 11

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy