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×.
It's hit and miss. This is So Aggravating!
Fix this please, its so stupid. Cannot select cells randomly.
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.