Sep 16 2022 06:38 AM
One sheet, in a workbook of many sheets, can longer scroll vertically with a mouse wheel. Keyboard arrows work. Dragging the scroll bar works. But the mouse wheel does not. Even more strangely, this only occurs on one sheet which leads me to believe it is a specific property with the sheet. This wasn't always the case for this but I can't seem to figure out what causes the change.
I tried all the suggestions here: https://www.exceldemy.com/vertical-scroll-not-working-in-excel/#1_Use_Keyboard_Shortcuts
But nothing worked. Looking for some help as this is quite frustrating. Thank you
Sep 16 2022 07:43 AM
While the problem sheet is the active sheet, press Alt+F11 to activate the Visual Basic Editor.
Has a range been entered in the ScrollArea property in the Properties pane on the left?
If so, clear this property.
Switch back to Excel.
Oct 26 2022 02:17 AM
I gave up trying to fix this. I had the same issue on one sheet in a spreadsheet on Excel (Mac v.16). I copied all columns onto a new sheet and that gave me the vertical scroll back.
Oct 26 2022 05:42 AM
@Hans Vogelaar , unfortunately, there was no range listed in the ScrollArea.
Oct 26 2022 06:06 AM