EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Excel Freeze Panes
 

Excel Freeze Panes

Madhuri Thakur
Article byMadhuri Thakur

Updated August 11, 2023

Freeze Panes in Excel

 

 

Introduction to Freeze Panes in Excel

Freeze Panes in Excel are used to fix any frame, row, or section of the table to access the data located below so that the user can also see the header’s name. There is 3 type of Freeze Panes option available in the View menu tab under the Window section, Freeze Panes, Freeze Top Row, and Freeze First Column. Freeze Panes are used to freeze the worksheet from where we keep our cursor. This freezes both the row and column both. Then to freeze a Row and a Column, we have a separate option to freeze each of them. Once we do that, we will see some portion of the worksheet will only move once we unfreeze it.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • A Frozen top row to know which parameters we are looking at during a review:

Before Freezing Top Row:

Freeze Panes example 1-1

After Freezing Top Row:

Freeze Panes example 1-2

This shows how the same dataset looks with a frozen row. This makes it easy to know which parameter we refer to when analyzing data beyond the first few records in the workbook.

  • A frozen first column to know which record we are evaluating for a particular parameter.

Before freezing the first column:

Freeze Panes example 1-3

After freezing the first column:

Freeze Panes example 1-4

Freezing Panes allows us to split the dataset into multiple parts to ease analysis: The worksheet gets split into different parts, which can be browsed independently. The figure above compares the dataset with and without the first column frozen. The Grey Lines in the middle of the worksheet indicate where the rows and columns have been frozen.

How to Freeze Panes in Excel?

The Freeze Panes feature is not very complicated if we know the database we are working with. In the next few paragraphs, we will learn how to use the features associated with freezing panes and using them for analysis.

Here are a few examples of Freeze Panes in Excel:

You can download this Freeze Panes Excel Template here – Freeze Panes Excel Template

Freeze Top Row – Example #1

To do this, we have to perform the following steps:

  • Select View from the Excel toolbar. Select Freeze Panes from the view options; this will open a dropdown menu with options to select the rows or columns we want to freeze. Select Freeze Top Row; this will keep the active worksheet’s top row in place and allow us to browse the rest of the data without disturbing the top row.

Freeze Panes example 1-5

  • A Tiny grey straight line will appear just below the 1st row. This means the first row is locked or frozen.

Freeze Panes example 1-6

Freeze First Column – Example #2

Next, we look at the next most commonly used function in the Freeze Pane feature, freezing the first column. This can be done using the following steps:

  • Select Freeze Panes from the view options. From the dropdown menu, select Freeze First Column, and this would freeze the first column in place, allowing us to browse the rest of the data without disturbing the first column.

Example 2-1

A Tiny grey straight line will appear just below the 1st Column. This means the first column is locked or frozen.

Example 2-2

These features can be used simultaneously, making it easier for us to analyze data. As we have seen in the examples, knowing the table’s basic structure helps us decide what we want to freeze.

Freeze First Row and First Column – Example #3

Freeze the first row and first column.

Here is an example of the practice table with the frozen first row and first column.

Example 3-1

This brings us to the most useful function in the freeze panes feature, freezing multiple columns and rows.

I like to use this function the most because it enables the user to freeze rows and unfreeze rows and columns based on any number of parameters depending on the structure of the worksheet’s data.

To freeze the first row and first column, we need to perform the following steps:

  • Select Cell B2 from the worksheet.

Example 3-2

  • Now, from the view options, select Freeze Panes. From the dropdown that appears, select the first option, Freeze Panes.

Example 3-3

These actions freeze the first row and first column in place.

Freeze Multiple Columns – Example #4

We can use similar steps to freeze multiple rows and columns. The following steps illustrate this:

  • Select any cell above which the rows and columns have to stay in place:

Example 4-1

  • Repeat steps 2 and 3 from the previous illustration to freeze all rows and columns above and left of the selected cell.

The solid grey lines indicate that the rows and columns on the top left of the sheet have been frozen. We can also choose a whole row above which we need data to stay in place or a column.

Example 4-2

Unfreezing rows and columns to their default state are very simple. We have to go into the freeze panes dropdown and click on Unfreeze Panes, as shown below.

Example 4-3

Freeze panes in Excel are an option that makes it very easy for us to compare data in large datasets. In fact, freezing panes in Excel are so useful that software providers provide additional features based entirely on freezing panes in Excel. One such example is the ability to freeze and unfreeze multiple worksheets and tables simultaneously, which many software vendors provide as a product.

Things to Remember

  • Freeze Panes do not work while editing something inside a cell, so care must be exercised while selecting the cell we want as the frozen data boundary; never double click that cell before freezing the data.
  • Freeze panes in Excel are a default configuration that can freeze data to the left of the boundary column or above the boundary row, depending on what we choose as a boundary. There are add on available from various software providers to enhance these.

Recommended Articles

This has been a guide to Freeze Panes in Excel. Here we discussed how to freeze panes in Excel and different methods to freeze panes in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles to learn more –

  1. Excel Move Columns
  2. Freeze Columns in Excel
  3. Excel Freeze Rows

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Freeze Panes Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Freeze Panes Excel Template

EDUCBA

डाउनलोड Freeze Panes Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW