Forum Discussion

Peter_Stobierski's avatar
Peter_Stobierski
Copper Contributor
Sep 16, 2022

Vertical Scroll with Mouse Not working

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 

 

  • TartanFeet's avatar
    TartanFeet
    Copper Contributor

    Peter_Stobierski 

     

    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.

    • Peter_Stobierski's avatar
      Peter_Stobierski
      Copper Contributor
      TartanFeet, this worked with some variation. For others having this issue, I first copied the whole sheet and pasted formulas. I then did the same thing and pasted formatts. I then used find and replace for the original sheet name and new sheet name becuase this sheet linked to a bunch of other sheets. After that you can simply rename the new sheet back to the old sheet name.
      Thanks for the help
  • Peter_Stobierski 

    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.

Resources