Freeze Panes broken in 15.19.1
Frozen rows and columns scroll into the unfrozen area at the top and left when scrolling to the top row or leftmost column. After scrolling into the frozen cells, clicking the the top or leftmost unfrozen cell selects multiple cells equal to the number of frozen rows and columns.
This is fixed as of 15.20, which was released in May (so if you haven’t updated, please do!)
We know that this broke in 15.19.1, and we’ve got a fix that will be in 15.20.
Sorry for the inconvenience. It should be that once you scroll down, so that the duplicated rows are no longer shown, they won’t be shown again.
Tarak Patel commented
I do have the same issue. It's really annoying and shall be fixed as early as possible.
Cannot wait for 15.20 this is very annoying. :)
Wow, I thought I was the only one having this. Was searching for "frozen cell duplication" or "frozen cell display issue"
This version of excel is definitely great looking but I keep going back to Excel 2011 (v14) from time to time due to the crashes/display issues.
Before this latest update this problem still occurred from time to time - I'd have to quit the program, then re-open the file and issue would go away.
Marcelo Lombardo commented
Actually, global spreadsheet auto calculate is also broken in 15.19.1. Select another tab and come back show correct values. Kind of unacceptable basic stupid bug.
YES! Need to freeze BOTH rows and columns, and the current version will not allow both, only one or the other. It was perfect when you could just drag the little box up and/or down to where you wanted to freeze, and then select freeze. I don't know why things get more complicated/harder as they're updated.
James Spotanski (Microsoft Excel) commented
This is fixed in the next version (15.20) that will make it to you all in March. In the meantime, you can "snap" the frozen content back into the freeze pane by clicking in any of the duplicated rows or columns.
Apologies for the inconvenience,
This problem is quite frustrating and defeats the purpose of freeze panes as the screen can taken up by the selected range. The 'frozen panes' are duplicated and display adjacent to the freeze panes view when scrolling and using worksheets. Please correct and freeze/lock the selected rows/columns from then displaying when scrolling.
I have some problems
My freeze panes does not work at all