Forum Discussion
BCR8TV
Dec 31, 2022Copper Contributor
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
Dec 31, 2022Gold Contributor
If you have already performed updates and the problem persists,
the next thing I would ask is, does this only happen in this workbook/worksheet?
If it happens to all Excel workbooks, I recommend running a repair as well.
If that doesn't help either, try starting in safe mode and see if the problem persists there too.
If not, deactivate all AddIns first and see if everything works as it should again in normal start mode.
Have you recently added new software such as antivirus?
If none of this helps, I recommend inserting a file (without sensitive data) to be able to view the problem.
Riny_van_Eekelen
Dec 31, 2022Platinum Contributor
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.
- BCR8TVDec 31, 2022Copper ContributorThank 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!
- NikolinoDEDec 31, 2022Gold Contributor
You're probably right, but according to the text, some things have been done by the user, as well as updates. This actually means that the knowledge is available to be able to carry out the basics. Maybe my translation was wrong. It would be nice if the user would give us feedback.
- BCR8TVDec 31, 2022Copper Contributor
As you can see - the 'panes' are frozen - I thought it was row 12 but not even as nice as that - freezes at the grayed lines which means row 17. no matter what I try this is how it comes out.
You can't see it, but my cursor is in row 3 which is below the rows I want to freeze. I just wanted to make a simple budget for home, but now it's a big deal. Not really though I won't need to scroll at home--but I AM worried about the one at work. However, one of my bosses literally went to Harvard so she might know how to fix it, yet somehow I'm thinking this shouldn't need a Harvard graduate to figure it out. I should just be able to highlight row 1 & 2 and hit Freeze Panes and wah-lah...scroll happily along. Thank you for your help!!
- Patrick2788Dec 31, 2022Silver Contributor
I recommend re-reading Riny_van_Eekelen's solution. Selecting multiple rows or columns prior to Freezing Panes is not recommended. I thought I'd chime in because I've worked with plenty of people in person and through remote and many of them will select multiple rows more often than not (It's one of my Excel pet peeves!).
I've included a gif of this. Freezing panes is all about active cell.