Selecting a cell with Mouse doesn't always work
I have a great deal of trouble with the mouse click in Excel (Version 15.22). I have to move the mouse out of the cell I'm working in, click on a cell far away from it several times, and then come back and try it again.
This is never an issue with Excel (Version 14.6.4). I'd like to use the later version but it's too difficult to use with the cell selection issue.
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×.
We've all been there - you know you're on cell A100, but the magical mac-Excel-brain wants you to believe you're actually on cell A999 and highlights a crazy variation of cells ----- I've found the quickest way to resolve this is to open a new sheet, click in any cell, and then go back to my original sheet and continue along. After my nonmagical brain learned to just accept this as a quick remedy, since this issue has not been fixed since 2010, my sanity has been returned.
just updated to High Sierra, and the latest mac office 365, it was totally usable before now i've updated it terrible, so much for progress
I am using V16.30 and it is ridiculous. I feel like every second click doesn't work. How can this STILL be an issue?? I can't even use Excel anymore it's so frustrating!!!
Noticed the mouse select problem 1-14-20 for the first time with Excel v 14.7.3. I went to help>updates and after 2 updates, updated to v 14.7.7 (Mac os 10.13.6 High Sierra) and the mouse issue seems to have resolved.
You Don't Need My Name commented
The upgrade has made this issue the worst it's ever been! Is this a sike joke?
Anthony Rosenberg commented
Running Excel 16.30 on Mac and this is STILL a major problem. Almost making Excel unusable as it happens every 10 or so clicks and then takes another 10-15 clicks to get back to normal.
It happens in Normal view, resizing does help, but as I said, close to unusable.
When I am not at full screen, I clicked on the ribbon to highlight the cell in yellow but it doesnt work! Only when I am on full screen then I can highlight it in yellow.
I hate this "upgrade" to Excell. Sometimes it works, then other times I cannot enter date in a cell.
I've found in tables with odd cell shapes that using the keyboard shortcut works best to select individual cell for formatting.
TAB forward to cell, or SHIFT TAB backward into cell, then right click for TABLE PROPERTIES.
I tried for an Oct. 2019 update but there is none. My version is Excel 16.29, the latest.
My cell selection always indicates 1/2 of each of 2 adjoining cells. This is a ridiculous problem that has been going on since 2015 according to online posts.
The problem disappears if I jump around and select different page views until it goes away.
Surely Microsoft can overcome a glitch in less than 4 years!
Eric Russell commented
I am a long-time MAC user (since 1990) and currently using Excel V16.16 (190909) on Mac Book Pro (Retina, 15-inch, Early 2013) on OS Mojave 10.14.6 and I constantly need to click 2-3 times for the cell, formula bar, etc to be selected. This is extremely frustrating and has been doing so for several versions. Just exactly WTF is the problem here that can't be fixed?
The dragging of a cell's values does not work. The cursor does not change into + sign when I bring it to the right-hand bottom corner of the cell.
I have the same problem with many of my spreadsheets. REALLY frustrating. So many people are reporting this. Isn't there a way to fix it?
I restart the computer and it works. Very annoying.
Fabiola R. commented
Same recently, I've opened this file for at least thrice before and it's the first time it happened. It depends how far away of the cells you're working in for it to work, sometimes I zoom in and out for it to work too. These methods work for a little time.
Same problem. I click on a cell and "halves" of two adjacent cells are highlighted. If I type my info in this "two halves" of one cell, the information appears in a random cell elsewhere in the document. I have never had a problem with excel until this new version on this new iMac and it's frustrating. PLEASE FIX IT.
Having the same problem, I click on a cell and it selects a different one. Super frustrating.
nigel smith commented
Same problem with magic mouse and iMac,
Excel v15.28, Mac OS 10.11.6
Sometimes takes 2 or more clicks to activate a cell.
Same issue in Mac! I can't believe that the Microsoft didn't fix the problem for three years. Please! It is very annoying.
check your display resolution if it is scaling to another monitor of different size. Needs to be set as the default resolution for that display and NOT scaled