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.
David_Townsend_Jones If anyof you is still facing hte issue, here is the tricke. Go to view, and change teh layout to page layout and then revert back again. Now you will see the option Freeze panes.
Very useful. To clarify, you go to Page Layout, then go back to Normal layout. Thanks!
