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 was having major problems too, but I just worked it out! aaaaccountingnet. You only need to select one cell below the row and after the columns eg. I want A-C columns to stay, and 1-2 rows to stay. I first of all Unfreeze everything, then select D3 and Freeze frame. This worked thank goodness!
Thank you!