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
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.
Then you go to "View" on the top menu, then click "Freeze Panes" to get the drop down box and hit Freeze Panes
You will now see 2 solid lines which indicates that anything to the left and above those lines are frozen.
Hope this helps and happy scrolling
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
just want to let you know that this worked perfectly thank you again.
It's working fine as per your information. and its very useful tips for us.
Thank you for solving my problem
Thanks ... Thats was very clear and simple explanation....
I can think of a dozen times I wanted to do this and got frustrated when I couldn't, finally googled it - I can't believe it was this easy! Thanks a lot!
This is so helpful. Thank u so much
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
Thanks a million....very good instructions!!