Forum Discussion
Latest Microsoft365 Excel will not freeze panes properly
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.
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.