Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

MS Excel issue

Killerbob

Killerbob

macrumors 68000
Original poster
Jan 25, 2008
1,946
728
Since upgrading to Ventura, though I just found this out, I have a funky issue in Excel;

In any spreadsheet, even a brand new one, all is fine until I scroll down. When I scroll down from the initial viewable spreadsheet cells, my mouse no longer will select the cell I point it at. so, I can select cell A1, H5, etc. just fine. But if I scroll down using swipe or the scroll bars, to for instance cell H100, and I click on it, the H100 cell will not be selected. Rather cell H50 will be selected - and that is how it is until I scroll back up to the top, and then I can select the right cell.

If I use the arrow keys to move down the spreadsheet, it works fine, and I can move down to cell H100, and then select it.

I know it sounds stupid, it is, and I hope the explanation makes sense…

Is this a Ventura problem, an Excel problem, or just my Mac?
 
I’ve had a similar issue on Excel recently using Monterey - it might not be a Ventura issue. The offset is only usually to the next cell though, so clicking on H50 would select J50. Makes using the auto fill really tricky as impossible to select the bottom corner of a range using the crosshair cursor. Minimising and restoring the window or going to a new sheet fixes it. It only tends to happen on my 5k external monitor though.
 
Killerbob said:
Since upgrading to Ventura, though I just found this out, I have a funky issue in Excel;

In any spreadsheet, even a brand new one, all is fine until I scroll down. When I scroll down from the initial viewable spreadsheet cells, my mouse no longer will select the cell I point it at. so, I can select cell A1, H5, etc. just fine. But if I scroll down using swipe or the scroll bars, to for instance cell H100, and I click on it, the H100 cell will not be selected. Rather cell H50 will be selected - and that is how it is until I scroll back up to the top, and then I can select the right cell.

If I use the arrow keys to move down the spreadsheet, it works fine, and I can move down to cell H100, and then select it.

I know it sounds stupid, it is, and I hope the explanation makes sense…

Is this a Ventura problem, an Excel problem, or just my Mac?
Click to expand...

Have had the same issue on both Monterey & Ventura, though it does seem to be a bit worse on 13.0.

I chalk it up to MSFT’s lack of quality throughout the Office 365 suite. Best solution I’ve found is to select all and then try reselecting the cell / column / row.
 
It's a compatibility issue with Excel and Ventura sadly. Mine does it too and it's infuriating. I haven't found any way of permanently fixing it so it's a case of either put up with it and wait it out until MS issue a fix, or downgrade back to Monterey. The issue used to appear every now and then in Monterey, but closing Excel and reopening would sort it and even then it only appeared every couple of weeks or so. In Ventura it's constant and makes Excel very difficult to use.
 
I am glad to hear it is a Ventura-prompted issue, not just my setup. It isn't enjoyable to me but not a show-stopper, as I can work around it using the arrow keys. If I use the arrow keys, or page down, I can then use the cursor for selecting the right cells.

I am on MS Excel 16.64 (22081401).
 
This is not a Ventura issue. I have this on Monterey every couple weeks. I'm sure there is a faster fix, but a reboot always resolves it for me.
 
I had it on Monterey from time to time, and as you said, a reboot solved it. On Ventura though, nothing solves it...
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back