Trending Article

  • How to activate YouTube on your device via tv.youtube.com/start?

    1459 shares
    Share 584 Tweet 365
  • How many devices can be connected with Plex TV account using plex.tv/link?

    1424 shares
    Share 570 Tweet 356
  • How to Activate McAfee Antivirus | Mcafee.com/activate

    710 shares
    Share 284 Tweet 178
  • How to Setup Canon Printer | Canon.com/ijsetup

    663 shares
    Share 265 Tweet 166
  • How to Delete an Instagram Account Permanently?

    586 shares
    Share 234 Tweet 146
  • How To Delete Hulu Account?

    575 shares
    Share 230 Tweet 144
  • About
  • Advertise
  • Contact
Saturday, February 27, 2021
  • Login
Zone Desire Logo
Contact Us
  • News
  • Tech
  • Entertainment
  • Lifestyle
No Result
View All Result
Zone Desire Logo
No Result
View All Result
Home Office Microsoft Excel

How to freeze and unfreeze rows or columns in an Excel sheet

February 3, 2021
in Microsoft Excel, Office
0
to freeze and unfreeze rows or columns in an Excel sheet
Share on FacebookShare on Twitter

In the industry, everyone uses Microsoft excel to manage their data. Most of us found ourselves in a situation where we have to scroll back and forth so that we can compare specific information available in different rows and columns with other data that feels a mile away. Thankfully Microsoft excel makes it easy for the users to freeze multiple rows and columns at one time so that they can lock different rows and columns at one place and move to the different locations in the spreadsheet. This will help the users to compare data easily and quickly. In this post, we will learn how to use the freeze rows and columns option available in Microsoft excel and the steps you can follow to do the same.

Steps to freeze Microsoft excel rows or columns

The following are the steps that you can recommend if you want to compare rows and columns in an excel sheet available on different locations in one spreadsheet.

Step 1: Turn on your computer and open the Microsoft excel workbook or worksheet on which you want to use the freeze column feature.

Step 2: In the worksheet locate the rows and columns that you want to freeze. Click on the particular row or column to highlight them. It is important to keep in mind that if you freeze row in excel it will show above everything. But if you freeze a column everything will shift to the left of that particular column.

Step 3: Once you highlighted the specific row of all columns click on the view option available in the menu of the excel sheet that is available on the top of the screen. From the explode menu options click on the freeze panes to open further options.

Step 4: Once you click on the freeze panes button a thin line will appear under the selected row. If you have selected the root then it will be directed to the top of all the rows but if you selected columns then it will be shifted to the left.

Step 5: Now you can navigate up and down in the same excel spreadsheet. All the cells above or to the left of the thin line will remain in the same place and the rest of the cells keep moving as per your commands.

Step 6: It is important to remember that if you freeze a row then it will show above and if you freeze a column then everything will go to the left of that particular column.

Step 7: Once you are done with the editing you want to do it’s time to unfreeze the freeze columns or rows. For the same click on the view option from the menu bar again

Step 8: Now select freeze panes and you will see unfreeze panes will appear on the screen. Click on the unfreeze panes option at the freeze rows or column will unfreeze automatically.

We hope that the above instructions help you to make your work with Microsoft excel easier and quicker. If you want to know more of these quick fixes then keep connected with us.

Share198Tweet124Pin46

Related Posts

remove Duplicate rows or columns on excel
How To

How to remove Duplicate rows or columns in excel

January 28, 2021
Load More
0 0 vote
Article Rating
Subscribe
Login
Notify of
guest
guest
0 Comments
Inline Feedbacks
View all comments
  • Trending
  • Comments
  • Latest

How to activate YouTube on your device via tv.youtube.com/start?

October 28, 2020

How many devices can be connected with Plex TV account using plex.tv/link?

November 18, 2020
mcafee com activate

How to Activate McAfee Antivirus | Mcafee.com/activate

April 13, 2020
How to Setup Canon Printer

How to Setup Canon Printer | Canon.com/ijsetup

April 13, 2020
mcafee com activate

How to Activate McAfee Antivirus | Mcafee.com/activate

38
How to Setup Canon Printer

How to Setup Canon Printer | Canon.com/ijsetup

15
PSD to WordPress Conversion

PSD to WordPress Conversion: Can it Increase Your Conversion Rate?

4
restaurant reservation system

Accelerate the sales or your restaurant with On demand apps during COVID phase

4
web hosting services

Top 5 web hosting services 2021

February 23, 2021
Kaspersky vs McAfee

Kaspersky vs McAfee: which antivirus suite is best

February 23, 2021
VPN hosting servers

Top VPN Hosting Service 2021

February 19, 2021
lose weight

The Best Foods To Eat To Lose Weight

February 17, 2021

Most Popular

How to activate YouTube on your device via tv.youtube.com/start?

October 28, 2020

How many devices can be connected with Plex TV account using plex.tv/link?

November 18, 2020
mcafee com activate

How to Activate McAfee Antivirus | Mcafee.com/activate

April 13, 2020
How to Setup Canon Printer

How to Setup Canon Printer | Canon.com/ijsetup

April 13, 2020
How to Delete an Instagram Account Permanently?

How to Delete an Instagram Account Permanently?

April 9, 2020
How To Delete Hulu Account

How To Delete Hulu Account?

April 16, 2020
Load More
Zone Desire Footer Logo

Copyright © 2019-2020 Zone Desire.

Navigate Site

  • About
  • Advertise
  • Contact

Follow Us

No Result
View All Result
  • Home
  • News
    • Politics
    • Business
    • World
    • Science
  • Entertainment
    • Gaming
    • Music
    • Movie
    • Sports
  • Tech
    • Apps
    • Gear
    • Mobile
    • Startup
  • Lifestyle
    • Food
    • Fashion
    • Health
    • Travel

Copyright © 2019-2020 Zone Desire.

Welcome Back!

Login to your account below

Forgotten Password?

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
wpDiscuz
0
0
Would love your thoughts, please comment.x
()
x
| Reply
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.