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 Rows
 

Excel Freeze Rows

Madhuri Thakur
Article byMadhuri Thakur

Updated August 11, 2023

Freeze Rows in Excel

 

 

Freeze Rows in Excel

In Excel, we have a function for freezing the rows as well. With the help of Freeze Row, we can fix the pane or row we select to go beyond the certain limit worksheet. Freeze Row can be accessed from the View menu tab’stab’s Window section from the drop-down list of Freeze Panes. First, to freeze the column, select the column we want to freeze, put the cursor anywhere in that column, and then select the Freeze Column option from the list. We will be able to see the selected column is now frozen.

Watch our Demo Courses and Videos

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

The freeze option is located under the View tab in Excel.

View Tab

Here we have 3 options. Freeze Panes, Freeze Top Row, and Freeze Top Column. I will show you examples of Freeze Rows in this article.

How to Freeze Rows in Excel?

We use Freeze Panes in Excel to keep an area or heading of a worksheet visible while scrolling to another part of a worksheet. This is very useful and convenient when working on a large table. So we select Freeze Panes from the View tab and keyboard shortcuts to lock that area.

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

Let’s understand how to Freeze Panes in Excel with some examples.

Freeze or Lock Top Row – Example #1

Usually, our header is located in each column, i.e., horizontally. When scrolling down, we need to lock or freeze our first or top row, enabling us to see the first or top row at any given time.

Now look at the below image of sales data in the sheet.

It isn’t easy to see all the headers when scrolling down. So, in Excel, we have an option called Freeze Top Row, which holds onto the top row when scrolling down and helps us see the heading all the time.

Let’s look at the below steps to understand the method.

Step 1: Select the worksheet where you want to freeze your top row.

Step 2: Go to VIEW tab > Freeze Panes > Freeze Top Row.

Freeze Top Row

We have a shortcut key as well. Press ALT + W + F + R.

Shortcut Key

Step 3: Ok, done. It is as easy as you eat pizza. You have frozen your top row to see the top row while scrolling down.

Frozen Top Rows

Even though I am in the 281st row, I can still see my headers.

Excel Freeze Rows

Freeze or Lock Multiple Rows – Example #2

We have seen how to freeze the top row in the Excel worksheet. I am sure you found it a walk-in-the-park process; you did not have to do anything special to freeze your top row. But we can freeze multiple rows as well. So here, you need to apply simple logic to freeze multiple rows in Excel.

Step 1: Identify how many rows you need to freeze in the Excel worksheet. For an example, take the same data from the above example.

Excel Freeze Rows

Now I want to see the data of the product Carretera, i.e., from C2 cell to C7 cell all the time. Remember that I don’t just want to see the row but to see the product and compare it with others.

Place a cursor on the A8 cell. This means I want to see all the rows above the 8th row.

Step 2: Remember we are not only freezing the top row, but we are freezing multiple rows at a time. Do not press ALT + W + F + R in a hurry; hold on momentarily.

After selecting cell A8 under freeze panes, again select the option Freeze Panes under that.

Freeze Panes

Now we can see a tiny grey straight line below the 7th row. This means the above rows are locked or frozen.

Frozen Rows

You can keep seeing all 7 rows while scrolling down.

Things to Remember

  • We can freeze the middle row of the Excel worksheet as your top row.
  • Make sure the filter is removed while freezing multiple rows at a time.
  • If you place a cursor in the unknown cell and freeze multiple rows, then you may go wrong in freezing. Make sure you have selected the right cell to freeze.

Recommended Articles

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

  1. Freeze Columns in Excel
  2. Excel Rows and Columns
  3. Excel Freeze Panes
  4. Add Rows in Excel Shortcut

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 Rows Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Freeze Rows Excel Template

EDUCBA

डाउनलोड Freeze Rows Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW