How do I freeze rows and columns at the same time in Excel 2007 ?
How do I freeze rows and columns at the same time in Excel 2007 ?
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 
Help us share the love?
- 6214 reads
Re: How do I freeze rows and columns at the same time in ...
#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 
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.