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.
Honestly this should be the top answer. Simple, easy, and strait forward.
The following works for me.
1. Unfreeze Panes (View ribbon).
2. Select the entire row BELOW the last row you want frozen.
3. Freeze Panes (NOT Freeze Top Row).
done.