Forum Discussion
Solved
Freezing multiple rows
I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered...
Absolutely brilliant. Thank you so much. I've used Excel for more than 20 years and I'm pretty sure this method is new - or, at least, newish. But it's great to find out there really is a way. Thank you for pointing the way.
I have used excel for well over 40 years and I am advanced in excel and I use to be able to freeze what ever columns and rows I wanted and with my office 365 I have not been able to....I really think this needs a 2nd look at fixing the problem. My 365 will ONLY freeze the 1st row and that is a real problem for me. Can you take a 2nd look please.
Thank you, Patty
aaaaccountingnet Don't really know how to help you, as I can't replicate the problem.