How To Freeze Panes in Excel 2007

You can Freeze panes in excel 2007. Freezing in excel sheet is very useful tool in excel 2007. when you excel sheet will be very large then you can Freeze your Top pane to view easily whole worksheet. Means of freezing is  heading will be remain at same place when you are scrolling down excel sheet. Suppose you have created large row lines in excel sheet, then when you scroll down at bottom. Then how you will identifies what is the heading of particular column. now to identifies it you will have to create freeze Heading row.    

Freeze Panes in Excel 2007

 

1. Open Excel worksheet on which you have to freeze panes. Then click on View tab and then click on Freeze Panes.
 
Freeze Panes in Excel 2007
 
 
 
 
 
 
 
 
 
 
 


 

2. Now click on Freeze Top Row to Remain heading in same place .
 
Freeze Panes in Excel 2007
 
 
 
 
 
 
 
 
 
 
 
3. Now if you will be Scroll down excel sheet heading will be remain at same place. Now it will easy to work on excel sheet. Its also very useful for save your time. 
 
Freeze Panes in Excel 2007
 
Related Post
Share This onShare on FacebookTweet about this on TwitterShare on LinkedInShare on RedditShare on StumbleUponShare on Google+Pin on PinterestBuffer this pageShare on Tumblr
Rakesh Kumar
at
Rakesh Kumar is a Network engineer and a Blogger. He is crazy for learn and write about Technology , Tech and Computer Tips and Tricks Blog.