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.
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!
- 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.
that doesn't work in y 365. Riny_van_Eekelen
dennisdugan Not sure why it doesn't work for you. Has worked like that for decades. Also on MS365.
Note: Screenshots taken on a Mac, but it's similar on a PC.
I have used excel for well over 40 years and I am advanced in excel and I use to be able to freeze what ever columns and rows I wanted and with my office 365 I have not been able to....I really think this needs a 2nd look at fixing the problem. My 365 will ONLY freeze the 1st row and that is a real problem for me. Can you take a 2nd look please.
Thank you, Patty
Riny_van_Eekelen I had tried that but somehow it didn't work. But now it does! Thanks so much for confirming that! (this is my first year using Office 365, so adapting to more sophisticated program.)
