Forum Discussion

Brass Contributor

Feb 28, 2019

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...

excel

David_Townsend_Jones
Feb 28, 2019
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.

Riny_van_Eekelen

Platinum Contributor

Feb 26, 2020

brigsby

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.

dennisdugan

Copper Contributor

Dec 19, 2020

that doesn't work in y 365. Riny_van_Eekelen

Riny_van_Eekelen
Platinum Contributor
Dec 19, 2020
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.
- aaaaccountingnet
  Copper Contributor
  Feb 08, 2021
  Riny_van_Eekelen
  
  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
  - tollarchet
    Copper Contributor
    Oct 02, 2022
    aaaaccountingnet this is very late, but I have found a way to freeze multiple rows of columns. If you hide all the rows up to the one you want to freeze, and then do freeze top row, when you unhide these rows they will all be frozen 🙂