How do I freeze rows and columns at the same time in Excel 2007 ?
Fri, 01/22/2010 - 4:19pm (2 years 16 weeks ago)
im hoping someone can help me with this, i have been trying to freeze the 3 top rows and the first column of a spreadsheet, but everytime i freeze the top rows and then i try to freeze the first column the top rows unfreeze, im going crazy 
- 8557 reads
Sat, 01/23/2010 - 8:32pm (2 years 16 weeks ago)
#2
Re: How do I freeze rows and columns at the same time in ...
thank you so much missb you're right that is easy, well it is once you know how. problem solved, i wish i had seen this yesterday. thanks again 
Wed, 03/21/2012 - 7:40pm (8 weeks 2 days ago)
#4
Re: How do I freeze rows and columns at the same time in ...
Eish this was so handy, this was the second time I tried to do this with no joy, until I saw this solution from miss b. thank you so much, i feel great
Single & Not Looking
Ah, been there done that Autumn, but it's easy peasy!
First of all instead of trying to freeze each one individually you actually do it simultaneously as follows:
Assuming that you want to freeze the "EMPLOYEE" column and the first 3 rows.
You will go to the cell that is directly to the right of the column you want to freeze and in this case the 4th row down (you said you wanted to freeze the top 3 rows) you always go to the row directly under the rows you want to freeze.
You will now see 2 solid lines which indicates that anything to the left and above those lines are frozen.