Hello everyone, just wondering if anyone can help...
There seems to be a years-old bug in Excel (many online posts refer to it, in successive versions going back to Excel 2007) whereby Excel selects multiple cells instead of one, when trying to select a new, single, target cell (or, sometimes, range).
From my experiments, the bug seems to be triggered somewhat randomly when the number of rows in a worksheet exceeds what can be displayed in a single screenful, and when Freeze Panes is on. It has nothing to do with whether Extend mode (F8) or Add/Remove mode (Shift F8) are on or off.
I'm attaching a small Excel workbook which I hope will demonstrate to anyone who's interested (Microsoft...????) an example of similar, probably related, and equally unexpected selection-change behaviour. In this workbook I suggest using Shift+PageDown which seems to fairly reliably show the bugginess in changing selection with extensive lists and frozen panes... at least it does on my system*. When the bug occurs it sometimes also seems to disable the operation of Shift+PageUp.
I've found this type of buggy behaviour in Excel 2019 and 2021, and to some extent in Microsoft 365.
The attached workbook was created in Excel 2021 and exhibits the bug in slightly different, but always unexpected, ways when opened and used in each of the above three Excel versions.
Excel single cell click, multiple cell selection - experiments.xlsx
If anyone knows why this happens or knows of a cure for it, that would be very interesting.
*HP laptop, 2020 vintage, Ryzen 5, Windows 11, Microsoft Office 2021