Jan 19 2022 07:22 PM
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'm worried it'll screw everything up if I relocate the table. The duplicate row 1 in the picture below is always there no matter where I am in the sheet even though there is no active freeze being applied to the sheet. This error has happened when changing the freeze settings, but I'm not sure what other factors cause it.
Does anyone have a fix for this? I couldn't find any other posts about this issue. Thanks a lot!
Jan 19 2022 07:43 PM
Jan 19 2022 09:40 PM
Solution@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.
Jan 20 2022 05:26 AM
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!!
Jan 19 2022 09:40 PM
Solution@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.