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×.
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...
Janice Pickwell commented
In Excel: The LogiTech M310 mouse has a great deal of difficulty selecting columns on the Column Headings (A, B, C, etc), for columns I want to hide. The file is a download from the bank, they send a ton of extraneous info.
I'n in normal view. I'm in Compatibility mode, using Office 365
I'm pretty sure I am having trouble with the mouse using my online trading platform (TOS) selecting as well, just not quite as bad. and even typing this message it won't select, it starts and jumps around.
I tried using the mouse pad on the laptop, thinking it could be the mouse, but it was worse.
I'm running a Toshiba Intel Core, i7-6500U CPU 2.5Ghz. 64bit, x64 based processor. Windows 10 home.
I'm not sure how to look for conflicting mouse software, but will research more as this has become a time consuming problem
I am beyond frustrated in the inability to select cells from excel and copy them into word, email, etc. I was able to do this so easily "before". Not sure what's going on but I do NOT LIKE IT! Please fix asap!