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 highlight columns to delete in excel and then I go to delete the columns excel reverts back to selecting one column to delete...this problem has stated about a month ago and it is the most frustrating thing. I pay for this version of excel on a monthly basis so I believe I have the latest version. Help!!!
Patrik Pukančík commented
The same problem can be simply reproduced in v 16.12 (180410) and many previous versions. Simply take some text (e.g. in word document) and try to copy-paste sentence by sentence (chose longer sentences which would spread more lines in one cell) into excel cells (e.g. 5 cells in row formatted to break long lines). Continue copy-pasting row by row. You will soon get in troubles with misaligned cells. Then the only solution how to align mouse click right back is to scroll table (sheet) up and down and then back to cell.
Val Tess commented
I do not always get the arrow selection and when I select a cell it pops to another cell 2 over and 2 up for editing.
Gary Woodruff commented
In the past two years we have moved all of our office applications into Azure and also into the Office 365 platform. My functionality of Excel has become very difficult to use, (drag and drop does not work, cell highlight is hit and miss, copying a cell sometime wipes out the formula and drops in another cell into the function). The application has slowed me down when ever i use it by at least a 25% decrease in efficiency. I have been using Excel since the beginning way back in the 1990's. Along with terrible pastel colors, hard white background, cute little people faces and other garbage Microsoft has cluttered their applications with, i now have to struggle with Excel which has had poor performance. . .
High Sierra; Excel 16.11 Highlighting a single cell doesn't work. It highlights half of one cell and half of the one above, which equals the correct size of the cell. Help!
Using a Magic Mouse 2 with Mac Excel 15.41 (171205) and High Sierra 10.13.2, I still regularly experience this frequently reported and annoying problem of the mouse click not selecting the cell. "Solutions" (really non-ideal work-arounds) that have worked for me include:
- selecting another sheet then going back to the desired sheet
- losing my temper so that I pound my mouse on the mouse pad (no doubt bad for the mouse but does solve the problem and releases my anger).
Cell selection was not a problem in 20 plus years of using earlier versions so why can't MicroSoft get it right now?
I fixed this issue on my excel by select all cells and columns, right click in one of the cells, goes to format cells, protection Tab, remove the locked and hidden tick, save it and put it back if you need too.
Hi. I have the lastest version for mac and i was working away. Suddenly, i stop being able to select any cell. I can click between tabs, I can save and use all File menu options and go between menus, but i can't select anything within the spreadsheet. Did i select/click on something?!?!
1- Activate your sheet.
2- then go to vba (by pressing [Alt + F11] keys)
3- properties window
4- remove the value of "ScrollArea" property
This is pretty annoying, and makes the application close to useless.
The latest update has not solved the problem for me. I am using:
Excel for Mac Version 15.40 (171108)
macOS High Sierra Version 10.13.1
This continuing problem effectively means that I cannot use Excel. Perhaps it's time to do the full switchover to Libre or Google Sheets !!!!!!!!
Last Excel update, PROBLEM SOLVED !!!!!
I just updated to the last version and the glitch was corrected. Now I can select cells with my mouse. Finallyyyyyyy!
Had the same problem, using
pressed control + page up / page down to switch between sheets, and after that I could select cells all of a sudden.
Alfons Geurts commented
By the way my versions:
Alfons Geurts commented
Same issue since Sierra upgrade, which required an update from 2011 to 2016 office. It seems to be less when telling sierra to always show side-sliders and changing the zoomfactor, but it is pretty weird that such an error appears and takes so long to get solved.
I've got the same problem as everyone else here. My old 2009 Mac running old versions of Excel always worked just fine, but since I got a new Mac (High Sierra 10.13 now) and new Excel (15.39) last year, I have to use the arrows half the time just to select a cell. Why is Microsoft ignoring this issue?!
I have been struggling with this problem for months, not being able to click on some cells. I can always find a nearby cell, make it active with a click, and then move to the desire cell using arrows, but that is a real pain. Today, I accidentally found a way to make cells accessible by clicks that were not before. I an using Excel for Mac 15.31. I found that by changing the display scaling that cells become click accessible. I've only tried reducing the scale.
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... :-)