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×.
Same problem here. Clicking in a cell does not make that cell active. Sometimes multiple clicking does? Makes using Excel a complete PITA. Never had this problem in ANY version of Excel - until V 15. I now hate this app.
I've been running into what I think is the same problem for many months now, and it's still there on 15.38. However,I don't believe (in my case at least) it's a Magic Mouse problem; it's something a bit more fundamental. I say that because: a. I'm so used to the Magic Mouse sensitivity issue that I've figured out how to hold it so that I no longer trigger that issue; b. I also use Excel in Windows under Parallels, still using Magic Mouse, and I don't see the cell lockup problem there; and most important, c. I am seeing a lot more than simple cell lockup.
I've realized over time that whenever I see the problem when I'm working with more than one open workbook file (which is most of the time), what has happened is not that selecting a cell is suddenly doing nothing; rather it is that the mouse click selects a cell on one of the other workbooks.
And, it is not actually restricted to simple cell selection. For example, as recently as about an hour ago I wanted to make a copy of a sheet in one of my workbooks. So I did the usual: Right-click on the sheet I wanted to copy, choose "Move or Copy...", check "Create a copy", highlight the sheet I wanted the copy to be placed before, and then hit "OK". I got a correctly positioned copy alright, but it was a copy of an entirely different sheet from another open workbook!
I'm used to this nonsense by now, so I clicked about on the other workbooks, to "shake it loose" as often works, but I couldn't do it this time. I made three attempts and then gave up and switched to Excel on Windows under Parallels. I'm hoping my Mac Excel will get jealous, realize it can't keep treating me like this, and plead with me to take it back amid promises that it's changed for the better and that it will never hurt me again.
There are other effects to be seen if watched carefully. For example, sometimes when I get the "cell won't select" symptom, if I look in the formula bar I may see a value. It's the value of that cell but again, in another sheet in another workbook. Or if I'm click-dragging a range, and one of the other workbooks is poking out behind the one I'm having problems with, I'll see the range selection happening -- again in the wrong workbook.
Bottom line: I believe Excel is getting confused about which window is in focus. By most indicators --- e.g. the fact that we're clicking on cells in workbook A (say), and that *most* of those clicks produce correct mouse events in that workbook A, and workbook A is the one "on top" --- it's leading us to believe that workbook A is in focus; but when it comes to the problem click events, Excel itself believes that workbook B has the conn.
That said, I cannot be sure that I've seen the non-selecting-cell symptom *only* with multiple Excel workbooks open. There's a possibility that what's getting itself in a fankle is not Excel per se, but rather OS X (I'm currently on El Cap 10.11.6 on a Mid-2015 MB Pro) and it's mouse subsystem. OTOH, I only ever see this with Excel, so even if OS X is partly to blame, I suspect the core issue is in Excel.
To begin with (months ago), I thought this was the problem of another tool I use with Excel. It's a billing system and it provides reports Excel Pivot Table format and is able to call Excel to open the files (rather than just saving them to disk). I was (and still am) able to reliably reproduce the craziness, and in fact I submitted a fairly extensive bug report video to that tool's developer.I used a video because the bug is so GUI intensive, it was hard to simply give a wordy description. However, they were unable to reproduce the bug despite my report (Professionally, I work in an area of software testing, so I'm used to giving developers what they need to be able to see what I saw.) After a bit of back and forth, I believe them. The problem is not with their tool, or their tool's interaction with Excel. It's Excel, or Excel's interaction with something else in the world. Until now I was open to it being Just Me, and I was waiting for time to strip my machine back and start again, but then I found you guys. So it's *not* Just Me after all!
Well, there's my story. I can see from others' plaintive cries that Microsoft don't really appear to bother with this forum, but maybe they'll pop in once a decade or so. If they, I'd be happy to send them that bug report video, although since it involved a billing system it does contain confidential information, so I'd need to get some formal reassurance that it would remain confidential. (I could also go back over the video and obfuscate details as needed, but that would take time and I don't have a lot of that right now, not least because Excel keeps wasting it by switching on my oven when I click to change font size, or telephoning my bank manager when I click to expand a column width... :-)
By the sounds of it, I've encountered the same issue. I recently upgraded to Excel 2016 (15.37) from Excel 2011 due to another technical issue. I'm running El Cap on a MacBookPro (2013). Magic mouse works for awhile, then quits. I've tried different versions of (non)Magic Mouse--both fail. I've found that clicking on a non-Excel window then clicking back to Excel can "jog" the mouse to resume. But what a pain! As a "work around" (haha!) I just ordered a new Logictech Master mouse. A colleague says he has no problem with that. This is a productivity killer!!
Steve A commented
I don't know of anyone who has more than one finger available for clicking when using Apple's magic mouse. This goes back to basic one-button mouse usage originating in 1984 - thumb on one side and 3 fingers on the other. So, that doesn't even qualify as a work-around for me.
I do know that changing the zoom setting works to get cell selection under control. That includes selecting just the cells your cursor is on and not adjacent cells, having the cursor consistently change to a hand when it hovers over any of the 4 outside edges of the group of selected cells, and being able to select an entire row when clicking on the row number.
FileMaker had a similar issue years ago where it misbehaved when the zoom setting was at 150%. Maybe Microsoft can ask Apple what they did to fix that problem.
Andrew Henley commented
Further research did reveal to me that the problem is entirely fixed if you just keep two fingers on the Apple Magic Mouse while using excel, even while left-clicking to select cells. This prevents it from recognizing your touch as horizontal or vertical scrolling. This definitely is a work-around rather than a solution, but it also shows that the solution for Microsoft could be making Excel's scrolling more sticky so that it requires more finger movement before it is actually recognized as scrolling.
Rick Lawrence commented
Yes, this issue is such a pain. And the thing about the pointer not showing the correct symbol is so annoying. Often the hand symbol does not appear which prevents me being able to drag cells to a different location. In this case I have to cut and paste. Such a time waste.
Andrew Henley commented
I can't believe that this hasn't been fixed. In addition to the selection issues, the pointer doesn't always change to the correct symbol (the skinny plus, the fat plus, the column height adjuster arrow, etc.). What is it about the Magic Mouse that Excel doesn't like?
It has been over a year since this issue was first posted and there is yet to be a response from Microsoft. Could someone please respond to this thread?
I have the same problem. Is there an answer to solve the problem?
(someone from the Microsoft team)
It has been over a year since this issue was first posted and there is yet to be a response. Could someone please respond to this thread?
V15.32 with the problem - VERY annoying.
Excel is completely useless now. When I go to select data to add to a chart, it *almost always* won't let me select the cells. Clicking does nothing! I've reproduced this on three different Macs (two Sierra, one Mountain Lion) all running Excel 15.35 variants. I've tried the slow and fast insider preview updates, and none of the versions works. This is a huge problem and I can't believe that Microsoft has allowed this bug to persist.
Same issue as Rick Lawrence and others here - clicking in cells doesn't work. Excel is *completely unusable*. I'm running 15.36 (170613) on OS 10.12.4. I looked for a way to turn the cell animations off, suspecting this to be the cause, but there doesn't seem to be one. Please fix urgently.
Will this be fixed in the next update?
David Swift commented
Love the smooth and fast scrolling in 16 but I have the same mouse focus issues as described below. Often unusable - but oddly not always!
As a solution I'm running office 11 and 16 concurrently. No conflicts so far under Sierra after several months.
Also using both versions because of lack of VBA in 16. Our design (therefore Mac) company and our main client uses VBA heavily...
I'm having the same exact issues in 15.34 (but I'm on Yosemite 10.10.5) that Rick Lawrence explained in detail below - thank you Rick for that clarification, you put it better than I did! When will this be fixed? Having to click a distant cell etc. as outlined by Anonymous below is not a solution, and the application is indeed basically unusable at times.
When will this bug(s) be fixed?
Yet another weird issue i Excel (now 15.33 and still not fixed). However, clicking a distant cell and scrolling back to the cell you want to edit, still works. Thanks for that solution!
Using version 15.34 and this issue is still constantly occurring. Please fix!!