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.
R Mora
shared this idea
We are working on a known issue where selection is not aligned correctly if you are using Page Layout View and you have some rows set to repeat on all pages. If you scroll down beyond page one, sometimes the selection becomes misaligned. If you are seeing problems in other scenarios, it would be helpful to provide a more detailed description of what you’re seeing and the steps that lead up to the issue.
You can submit feedback including screen shots by clicking the Smiley face button near the top right corner of the Excel window. You could also ask a question on https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel, which may help determine exactly what steps cause the issue.
Steve K [MS Excel]
73 comments
-
Anonymous
commented
Been having this problem for a while. Still happening - makes working extremely frustrating
-
Dommshippr
commented
Same issue here. March 19!!
-
Anonymous
commented
Having the same issue, I have to click multiple times or click something else first in order to select something. It's very frustrating when you are trying to be accurate inputting data! Sometimes first few numbers/letters of what I type does not appear as well.
-
rene van Erk
commented
I am on Win10 (on surface laptop) and since a few days I have the exact same problem.
Office16, Excel version 1902, build 11328, build 20146.
Freeze/Unfreeze briefly resolves the issue.
No updates available
Only happens in 1 sheet of a workbook with 6 sheets. Workbook does contain quite a bit of data.
Interestingly it happens in the sheet that does <NOT> have panes frozen. All other workbooks - for now - do not have problems.
Please help, makes Excel unworkable -
Anonymous
commented
March 12th, 2019 - This is still happening (Mac Version 16.22). So frustrating. Please fix! Or bring back 2011, that at least was free of this bug.
-
Anonymous
commented
March 10th, 2019 - This is still happening (Mac Version 16.22)
-
[Deleted User]
commented
This is still happening. March 2019, starting to wonder why I bothered upgrading.
-
Steve Johnston
commented
This is happening AGAIN in 16.16.6. Please fix this up. And don't suggest unfreezing panes, that's not a solution.
-
Peter
commented
I have exactly same problem with excel for Mac version 16.19. Is there any progress? Thank you.
Peter
-
Erik
commented
I fixed my version of this problem by unFreezing Panes.
-
Reid Hart
commented
Yep, this is a real problem. Occurs all the time. Both on my work computer with xl 2016 and on my personal computer with 365.
Seems to occur after xl has been up and running for a while, with multiple workbooks open.
Cannot click inside cell to edit. work around is to go to another tab or workbook and click in another cell, then come back.
Once this starts happening, seems to happen about every 5th to 10th cell selected.
Closing all open workbooks and reopening will give relief for a while.Please fix this - makes google docs look worthwhile!
-
imiehulu
commented
error is simple: while dragging across say 10 cells to copy them, when the left button is released selection of those 10 disapears and only last cell is active. Sometimes it works ok when repeated slowly second or third time
In other cases selection of a cell jumps several cells away. Really anoying. I start searching after this problem when could not select a row five times. -
DAVID HULINGS
commented
SAME PROBLEM IN 16.16.4
I have to click multiple times in a cell for the cell to become active. It does the same thing on multiple computers and mice. -
Anonymous
commented
I have been encountering the same issue as Dorelle Rawlings and Rick Lawrence. This is a new problem for me, though I have been using Excel 2016 for a few years.
-
Rick Lawrence
commented
I have the same issue (among many associated with selecting cells) as Dodelle Rawlings. More often than not, if I want to copy a formula to a column of cells that is longer than the window, I cannot do it because I cannot drag beyond the bottom of the window. The same thing happens if I want to fill a row wider than the window. Just one of a zillion time wasters in this awful version of Excel.
-
Dorelle Rawlings
commented
Having trouble selecting cells and then dragging down to lines past the bottom of the window to select an area to print. Sometimes it does it, sometimes the selection bounces back to the initial line selected. And once it completely screwed up the file, corrupting all the rows that were past the bottom of the window - good thing I could go get a backup. What's with 2016? 2011 Excel worked fine.
-
Anonymous
commented
I have this problem, too. Excel for the Mac 2016 is extraordinarily buggy. In short, it sucks. I had no problems with Excel 2011 for the Mac.
-
Kibru Mamusha
commented
I have experienced an awkward Ms Excel and word behavior. I start selecting cells or texts in word with a mouse. The selection keeps going endlessly until I click it again. It is annoying to click twice first to start the selection and the second click to end the selection. Why it keeps selecting when I wanted to stop it and do some other commands on the selections?
-
Anonymous
commented
I'm having the same issue, cells wont select properly with a single left click; single left clicking an already selected cell instantly opens the cell for data entry; left click & dragging, frequently doesn't select the correct range of cells or opens the fist cell for data entry. Please fix this NOW, or I'm going back to Open Office, at least they address user issues!
-
Albo
commented
Hey, I am using Page Layout View in an excel document (v 15.35) on a Mac (10.13.4) and I have set rows to repeat on all pages.
Sometimes, while working the selection becomes misaligned.
If I select cell C60 for example (using the mouse), the active cell is actually the cell C64, and it’s getting frustrating to make sure I am using the correct cell before getting work done.For now, I am copy pasting the whole document into a new worksheet and working on it on a normal layout view, and then I plan on refining it later to a page layout view and making the rows appear on each page, then rearranging the beginning of each page to report balances correctly, which is quite a hassle.
Please let me know if this bug has been fixed, or if there is an easier way to deal with this issue.. so I can keep getting some work done.