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×.
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
has there been any update on when this issues is going to be fixed?
For everyone else i've found a helpful work-around is to unmaximise the screen and maximis again, seems to reset it for a period of time. Still annoying tho!
it makes working quickly impossible!
Frustrated In SEA. commented
Same issue. I try clicking on a cell and it opens a different cell. When I type, it deletes/replaces cell contents. Esc. Even when I miraculously get a curser into the correct cell, the cell opens and appears a couple of rows about so I am never confident what I'm typing is going into the correct cell.
cannot just highlight a group of cells with my mouse to print...excel use to be my go to will switch to something else, very disappointed....
Same problem. Very frustrating. Makes working with this software so hard, but I have no choice but to keep trying. Fix it please...