Forum Discussion
Mouse wheel not working on some sheets
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.
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.
- Thank you. It works.
typicalalex1 Thanks very much. I discovered that when I unhid the rows at the bottom of my sheet the issue was fixed. Thanks...
THANK YOU - I selected the entire page and adjust the height of my rows. This seemed to fix the issue. typicalalex1
typicalalex1 It worked for me! Thank you! I selected all the lines and changed the height. After that, the hidden lines where shown, and I could scroll up and down. Then I hidded the lines again.
- Appreciate it! It Worked.
In 365. This worked. Thanks. Multiple sheets in one workbook decided to not vertically scroll with mouse. I had hidden rows, so highlighted each sheet then unhide. I noticed that the full number of rows was not available / visible. Should be 1,048,576.
I then clicked the top left box to highlight the entire sheet and scaled all the rows with the mouse. Now all 1M plus rows are visible and vertical scrolling works.
Thanks for the "fix". Nicely done.
No reason or logic behind why it happened. One day all sheets would vertically scroll with Logitech M705. The next some would not. Anyway, it all works now. Thanks again and hope this helps others.
Perfect fix! Thank you so much!
- Thank you! This problem has been a thorn in our side for quite some time, glad I finally stumbled upon this post!
- This worked for me with the only adjustment. I had to select all rows and move the height on all of them not just the rows that were previously hidden. Thank you very much.
