Fix cell selection misalignment (likely out of memory) issues on High Sierra
I have High Sierra and Excel version 16.14.1. The issue I describe below has been there in Sierra, and prior versions of Excel - at least last 6 months.
Basically, sometimes after just a few new entries, sometimes after multiple entries, I'm unable to select and enter data/edit the cell I want. The cursor lands on another cell, typically one or two above.
The only way to recover is to quit Excel, not just close and reopen file. That's why I think it's a memory leak...
The file is less then 200 rows with 15 columns. Most cells have a few words or numbers, and just one column has 1-4 sentences in its cells.
Quitting and restarting Excel after few interactions is super annoying.. Please fix.
Thanks for your feedback. Several issues have been fixed with regard to cell selection. Some have already been released and one fix will be available in the Oct. 2019 monthly release of Excel for Mac. Once you have version 16.30 or greater, you should no longer have an issue if you are using repeated rows at the top of your sheet and using Page Layout View. If you want to get the fix sooner, you can opt into the Insiders program and choose the Fast updates. To do so, just go to Help > Check for Updates. Then check the box to join the Office Insider Program and choose Office Insider Fast. Then press Check for Updates and install version 16.30×.