How to Freeze Panes in Excel 2007 and 2010

Image Source : bankers-anonymous.com

What’s up guys? I’m here to teach you how to freeze panes in Excel using 2007 and 2010. Why should we learn what freeze panes are? What is its purpose and why do we need to freeze panes when working with data in excel?

Now let’s discuss what freeze panes are. Freezing panes does prevent data in the panes from scrolling as you move to different areas in your worksheet. It will really help a lot as your worksheet getting filled up with so many data for it will help you not to get confused later on your work.

With the help of freeze panes, you can scroll down your worksheet without worrying columns with the title or description would also be scrolled down. So that’s how powerful and useful freeze panes are. You will always be on the right track to fill cells up with data.

This is how Freezing Panes looks like :

1. Look at the information being shown in this image. This is like a database as you can see and at the top were column A, B and C in row one, those are your title or description about the Fruit namely “No.”, “Name”, and “Quantity”. In column A from row 1,it has a title of “No.” and there are numbers ranging from 1 to 5 which is the fruit’s corresponding number, in column B has a title of “Name” which stands for the fruits you’ve got and lastly is “Quantity” in column C which corresponds to amount of fruits you currently have.

2. In this image, the numbers from “No.” in column A, the names from the “Name” in column B, and the quantity from “Quantity” in column C changes as I scroll down also with the default numbers in excel from the left side changes but the panes which are frozen, isn’t change. Now you see the beauty of freezing panes.

And now guys, I’m gonna show you how this stuff works. Here are the screenshots and tutorials for Freezing Panes for 2007 :

Open Microsoft Office Excel 2007 then click View Tab.

Click Freeze Panes Tab.

Then select Freeze Top Row. All of the first rows in each columns will be frozen.

Then you will see like this in this image the outcome.

Try to scroll down and you have just done freezing panes.

This is really helpful guys when you are working at home. This will help you to encode or fill up cells without scrolling up if you’re in a hurry. It will really lessen the time you consume for every worksheet you’ve worked for. You’ll going to have more time to do your activities indoors or outdoors if you apply how to freeze panes in excel 2007 and 2010. Giving quality time for your family especially with your partner if you have one. Also with your kids, more time to bond for you are giving them the time they need.

And if you are working in a company and you were using excel, this is really helpful. You will be also having a time to relax as if you’re a boss if you will apply these steps on freezing panes. You may also teach this to your colleagues to help them lessen the time they consume by working with excel and a great help would to them if you let them read this tutorial about how to freeze panes in excel 2007 and 2010.

Here’s the tutorial video for 2010:

Now, anyone can use this information whether you are from home or at the office. With this article I made, you can do this all by yourself if you just follow the steps of freezing panes. Try this in your working pace and be amazed what could freeze panes do to your daily lives by applying this. A really great help for all excel users whether in home or in the office.

Visit here in arcalite to learn more about how to technology.

Cheers!