Forum Discussion
Solved
Excel Freeze Panes error permanently freezes part of sheet even when unfrozen.
I've seen this issue before and never knew how to fix it. Normally I would just copy whatever I need into a new sheet and scrap it, but this table is linked to a PowerApps form I'm working on, and I'...
tjryan35 Looks like you accidentally activated "Split screen" in stead of "Freeze Panes". It just creates two or more viewing areas of the shame sheet. So you could create a view like this (just an example):
Press "Split" again to switch it off.
I actually figured out a solution. If you open a new window, then close the first one, the problem disappears. Still don't know what causes it, though...
tjryan35 Looks like you accidentally activated "Split screen" in stead of "Freeze Panes". It just creates two or more viewing areas of the shame sheet. So you could create a view like this (just an example):
Press "Split" again to switch it off.
Yep, you nailed it. I've done splits before, but I didn't recognize it on just the top row like that. That's happened to me inadvertently before when using freeze panes in a macro. Now I know how to easily fix it. Thank you!!