Forum Discussion
Latest Microsoft365 Excel will not freeze panes properly
Operations: Selected rows 1 & 2 Attempted to freeze panes Latest Microsoft365 Excel disregarded selection and froze panes beginning at row 12?! Googled issue & attempted suggested fixes: ...
NikolinoDE Am pretty sure it has nothing to do with updating, repairing or add-ins.
Did some more testing and it seems that as soon as you include the entire row 1 in your selection and then press Freeze Panes, the grid will be frozen both horizontally and vertically, exactly in the middle of your visible grid.
Selecting entire row 3 and then Freeze Panes will have the same effect as selecting A3 and then Freeze Panes.
Thank you Riny_van_Eekelen - I can easily freeze row 1, but I can't get any multiple rows to work. I have a top row that is merged across 6 columns, then a 2nd row that has the titles of each column and I should be able to select just row 1 & 2 and freeze panes - that simple, but the program isn't allowing it so I'll just squish up rows 3-12 - it shouldn't even be this hard 🙂 Thank you so much!
