Forum Discussion
Spin Control only increments
I have a sheet that I use for tracking statistics. Each cell contains a simple number with 0 decimal places. I have added a spin controls in my sheet to simply increment and decrement the value o...
I am encountering the same exact issue (M365 Excel + Windows 11).
I found that when you resize the spin control significantly (like 3x larger), the 'click zone' of the down arrow is enlarged enough for you to hit it successfully and it will de-increment as expected.
Of course the problem is that I don't want to resize the 12 spin controls I have on this sheet and the hundreds I have in other workbooks.. And I definitely don't want them all to be 3 times larger just to get them to work!
I'm encountering the same issue. I confirmed that when you resize the control larger it will allow you to click the down button, but then restoring the size to original goes back to only increasing. This wont be a good workaround for the end user, but it does help troubleshoot and confirm the problem.