Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to freeze rows and columns in Excel 2010
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

How to freeze rows and columns in Excel 2010

Great function which u can use to make big Excel sheets with lots of entries more transparent and easier to handle.

 
  Author: mat | Version: 2010 | 23rd August 2012 |  
 
 
1.
 

Open an Excel document.

Freezing rows or columns usually comes in handy when you have big amount of entries in your sheets, so when you scroll up or down you can still see the name of your rows or columns.

 
 
2.
 

Click View in the menu.

 
 
3.
 

Now select the cell bellow the row you want to freeze and next to the column you want to freeze.

In my case I want the most upper column with names and the most left column to freeze while I'm scrolling. Basically all the rows above the cell and/or all the columns left to the cell you choose are going to "freeze".

 
 
4.
 

Click the Freeze Panes button and choose Freeze Panes if you want to freeze columns and row.

If you want to freeze only rows than choose Freeze Top Row, if you want to choose only columns, choose Freeze First Column.

 
 
5.
 

You will notice dark borders that represent the freeze area.

 
 
6.
 

Now try scrolling to the right and down and observe the rows or columns you chose to freeze.

 
 
7.
 

Pretty neat feature I would say.

 
 
8.
 

To unfreeze columns and cells, just click the Freeze Panes button again and choose Unfreeze...

 
 
 
   
  Please login to post a comment
  Click to open user profile  
yousuf, 1st Jun 2024, 3:04 PM
You should take part in a contest for one of the best blogs on the web. I will recommend this site!

 
 
  Click to open user profile  
yousuf, 2nd Jun 2024, 9:29 AM
I’d constantly want to be update on new content on this website, bookmarked!
8us

 
 
  Click to open user profile  
geggfv90, 2nd Jun 2024, 9:30 AM
Slot games can be highly profitable, especially when played
on a trusted platform like ALEXISTOGEL. Featuring top-tier
games from Slot88, ALEXISTOGEL offers a safe and rewarding
gaming experience.
https://shorter.me/fkkI3
 
 
  Click to open user profile  
yousuf, 3rd Jun 2024, 10:48 AM
Love the variety of free webtoons available here. It's my go-to for 웹툰 무료보기!

 
 
  Click to open user profile  
yousuf, 4th Jun 2024, 8:06 AM
Wow! This could be one particular of the most helpful blogs We’ve ever arrive across on this subject. Basically Excellent. I’m also an expert in this topic therefore I can understand your effort.

 
 
  Click to open user profile  
yousuf, 4th Jun 2024, 8:19 AM
i have some small garden of herbs at home, i use them for baking foods and as herbal medicines.
Thiên Đường Trò Chơi

 
 
  Click to open user profile  
yousuf, 8th Jun 2024, 8:28 PM
Some really superb info , Sword lily I found this.
68 game bài

 
 
  Click to open user profile  
fhfg6946, 9th Jun 2024, 8:21 AM
Discover the ultimate hub for content creators across platforms with Fanscout.com , the premier search engine for OnlyFans Search, Patreon, Twitch, and more. Explore diverse profiles effortlessly using advanced filters for gender, age, and location.
 
 
  Click to open user profile  
yousuf, 16th Jun 2024, 6:57 AM
I have been exploring for a little for any high quality articles or blog posts in this kind of area . Exploring in Yahoo I ultimately stumbled upon this web site. Reading this information So i¡¦m glad to show that I have an incredibly good uncanny feeling I came upon exactly what I needed. I such a lot indubitably will make certain to don¡¦t forget this web site and give it a look a relentless basis.
game bài đổi thưởng


 
 
  Click to open user profile  
yousuf, Thursday, 20th Jun 2024, 12:28 PM
Hello, Neat post. There is an issue along with your site in web explorer, could test this¡K IE still is the marketplace leader and a huge portion of other people will miss your magnificent writing because of this problem.
thể thao kubet

 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO