Forum Discussion
Mouse wheel not working on some sheets
One user reported this morning that the scroll wheel on her mouse would not let her scroll vertically on some sheets in multiple workbooks. These same workbooks work on most other computers.
Two more users this afternoon have also reported the same issue that was not present yesterday.
Have tried:
- Repairing Excel
- Reinstalling Excel
- Restarting Computer
- Replaced mouse
- Logged in as another user on affected machine, issue still present
- Unfreezing panes, as suggested in Google search results
- Scroll lock is turned off
Is there an issue with a new update that i'm not aware of? I can't see any mention of it.
mweaver77 I've found the reason for the issue i have been facing but i haven't found out why this has suddenly become a problem. Obviously an update of some kind as more and more users have been reporting this issue.
The issue for me is down to hidden rows and their row heights.
I found that the hidden rows at the bottom of the worksheets all had a height of 0px. Un-hiding these rows and changing their height fixed the issue.
These spreadsheets are generated from a template and nothing has changed with them for several months but suddenly the hidden rows are causing an issue.
I am also experiencing a very specific new issue with my mouse:
- I can't scroll "multiple lines" with the mouse wheel in Excel
- I can scroll "one screen at a time"
- It only affects Excel
- It only affects previously created sheets - a newly created sheet was not affected
- Scroll lock, freeze panes and other known issues are NOT at fault
- I can scroll horizontally using shift control
- It's not the mouse or drivers - I re-installed both
- I have searched extensively for an answer to no avail - it has to be a previously undocumented problem
- Looking forward to an answer!!!
- Sounds slightly different to my issue as i was not able to scroll at all, and you were able to scroll one screen at a time. I assume you have checked the mouse setting that can be switched between "Multiple lines" and "One screen at a time"?
- Yes, tried it all, short of uninstalling and reinstalling. I'm currently 1 line at a time. This means no scrolling in Excel. If I switch to "one screen at a time" , the rapid scroll of course applies to all programs. This is something that changed overnight beyond my settings. It's really frustrating and hope it gets fixed soon!
My problem started Friday 11/4/22 after a MicrosoftApps update. I just spent about 5 hours looking for a fix. The mouse scroll wheel would not navigate on a specific sheet. I tried this in about 30 different workbooks which contained the same sheet name and discovered the same issue. Some of the workbooks were created two months ago. The top row of this sheet was frozen and toggling the 'freeze top row' on and off did not fix the issue.
This is what worked for me:
1) Unfreeze top row
2) Reset row height for all rows (about 275) to the same value
3) Created a macro to then re-reset the row heights back to the original heights
4) Freeze top row
Good luck!
typicalalex1 This is also an issue for a number of our users on specific excel workbooks and sheets, where cells are not frozen and where the issue was not present before.
mweaver77 I've found the reason for the issue i have been facing but i haven't found out why this has suddenly become a problem. Obviously an update of some kind as more and more users have been reporting this issue.
The issue for me is down to hidden rows and their row heights.
I found that the hidden rows at the bottom of the worksheets all had a height of 0px. Un-hiding these rows and changing their height fixed the issue.
These spreadsheets are generated from a template and nothing has changed with them for several months but suddenly the hidden rows are causing an issue.
- Thank you - this fixed the problem. We had same issue in a template file.
- Thanks for the solutions, unfortunately this does not work with tables that have a sheet protection. I can't expect my customers to give me the password for the sheet protection. Can anyone tell me where I can create a bug ticket?
- Same issue. Couldn't find a proper solution.
What I did is copy and paste the data to a new sheet. But there should be a solution to it. typicalalex1The unhide/ row height solution does work, but just to let everyone know there doesn't seem to be an issue at all when using Office 2013 - scroll works just fine.
Looks like something changed in newer verions of Office (I'm using 365).- When I had this problem, Unfreezing Panes corrected it.
