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: ...
Riny_van_Eekelen
Dec 31, 2022Platinum Contributor
Freeze Panes will freeze the rows above and towards the left of the active cell. Select cell A3. Then freeze panes and the first two rows will be frozen.
And, as an example, select C4 and then Freeze Panes will freeze columns A and B and rows 1,2 and 3.
- BCR8TVDec 31, 2022Copper ContributorDid this but it still is taking from row 12? I've a mind to just squish up rows 3-12 and start my calcs from row 13 - I really don't see any other solution?