How to Freeze Rows and Columns in Excel

When we have lots of data to work on, it becomes really difficult to differentiate or compare between rows as we scroll down to the bottom of Excel workbook.

So in order to solve this problem there is a feature called Freeze panes in Excel which helps us to know exactly which  row we are working at.

This feature simply let us lock a specific row so that they are always visible to us whenever we scroll down through the excel sheet.

So before we go ahead, let me inform you that this post is going to get updated in future based on content updates.So don't forget to subscribe to my email list and bookmark this post for future reference.

In this post I will show you how to freeze rows in Excel. In my earlier post I have written about how to turn on spell check in Word.

How to Freeze Rows and Columns in Excel?

Follow the steps mentioned below in order to freeze rows in excel:-

1. Select the rows you want to freeze

First you have to select the rows which you want to freeze. In the example below I have selected row 6 to freeze rows 1 to 5.


See the green line in the image above at row 5, this line divides the excel workbook in 2 panes. Row 1 to 5 gets locked and you can scroll from row 6 onward.

2. Go to View and click Freeze Panes command

Go to View tab as shown below in the image and click on Freeze Panes. A drop down menu will appear with three option Freeze Panes, Freeze Top and Freeze First Column. 

As I want to select a custom row, that is row 6. I will select the first option Freeze Panes. Make sure that you have selected the row which you want to freeze first before clicking on Freeze Panes.


You can also select Freeze Top Row command or Freeze First Column command as per your requirement

3. Once you clicked on Freeze Panes row 1 to 5 gets locked:-

See below image rows 1 to 5 gets locked when freeze panes is active. When I scroll the mouse I see all upcoming rows are scrolling after the 5th row as shown below in the image.


4. Same way you can Unfreeze Panes:-

In the same way you can Unfreeze panes to remove the lock, for that you will have to again visit the View tab and click on Freeze Panes command. A drop down menu will appear with an option to Unfreeze Panes. You have to simply click on this option to unlock the rows again back to normal position.


Conclusion on How to Freeze Rows and Columns in Excel?

So these were the steps involved in order to freeze certain rows in Excel sheet. In the same way you can freeze a column also like you have down with rows. 

Apart from this there is an option to Freeze Top Row in order to lock the first row of the workbook. You can also lock the first column  if you want by clicking on Freeze First Column.

Do let me know through comments how this post has helped you in learning how to freeze rows in Excel. Don''t forget to subscribe to my email list to get useful tips of this blog directly in your email.

If you like this post do give us a G+ and a Facebook like below. You can also share this post to your friends or relatives from the social network buttons mentioned below.

No comments:

Comment Moderation Policy:
All comments on this website are strictly moderated. Comments with non relevant links to external websites are considered as Spam and deleted immediately.

However we do recommend good comments and love to publish it on our website.

Powered by Blogger.