Forum Discussion
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 is to freeze the top row.
I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!
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.
22 Replies
Just adding, you must click on the row number for this to work properly. I wasn't doing that, and thus could not accomplish freezing the correct number of rows. Works now. Thx
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!
Unfreeze the rows/columns. Then if you want to freeze more than the top and more than the first column, go to the cell below the row you want to freeze and after the column you want to freeze and the select Freezes panes.
- Brilliant, Thanks
- I tried similar to this before, but selected the last line (which was the second in my case) to freeze. So it always freezed the first line, which was annoying. Didn't think about selecting the third line and freeze all above this.
In this case, I like the Google way better: there are 2 thick lines on the top left, where I can easily drag the frozen header lines. Pretty easy and intuitive.
