Forum Discussion
Freezing multiple rows
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.
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. Tanya Denton That response works fine if you want to freeze rows and columns. But I can't find any way to freeze a specific row, no columns. I use data sheets with headings on the second row and I need them visible when I scroll down. Used to be so easy in old Office. Please help me as this is crucial in my work. thanks!
Just select cell A3 and select Window, Freeze Panes. Then, row 1 and 2 will be frozen but no columns. Has been like that for many years.
- Many thanks! It worked for me!
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.
