Forum Discussion

sandipgumtya365's avatar
sandipgumtya365
Brass Contributor
Sep 16, 2021
Solved

Excel sheet not Scrolling

Dear Excelers,

                      I am facing a scrolling issue in a particular sheet. This sheet doesn't scroll with the mouse (but scrolls with arrow keys) although all other sheets in the workbook are functioning as usual. Only the "sizing" sheet seems to have this issue. There are a lot of linked data in the "sizing" sheet. Can someone help me out?

 

NB: For security, I have wiped out all the data and kept the sheets only.

 

Thanks

Sandip Gumtya

 

  • sandipgumtya365 

    If scrolling by mouse means scrolling by mouse wheel staying on any cell, not clicking by mouse on scroll bar - yes, it doesn't work in my case as well.

     

    In 'sizing' sheet rows starting from 9000 or so till end are hided. If unhide them mouse wheel scrolling works, please check in attached. Not sure what is behind this effect.

7 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    sandipgumtya365 

    If scrolling by mouse means scrolling by mouse wheel staying on any cell, not clicking by mouse on scroll bar - yes, it doesn't work in my case as well.

     

    In 'sizing' sheet rows starting from 9000 or so till end are hided. If unhide them mouse wheel scrolling works, please check in attached. Not sure what is behind this effect.

    • sandipgumtya365's avatar
      sandipgumtya365
      Brass Contributor

      Hi SergeiBaklan ,

                                     Unhiding the rows from 9000 did the trick but still unclear what was causing this. Anyway, thanks for your inputs.

       

      Thanks

      Sandip.

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        sandipgumtya365 , you are welcome. I can't reproduce that on new file and not sure what's the reason exactly, will try to investigate some later.

  • sandipgumtya365 

    Hmm... I have no problem scrolling the sizing sheet with the mouse.

    Does the problem persist if you completely quit Excel then reopen the workbook?

    If so, does it persist if you restart your computer?

    • sandipgumtya365's avatar
      sandipgumtya365
      Brass Contributor

      Hi HansVogelaar thanks for your reply. Yes, I have tried to use the same file in a different system but I am facing the same issue. Are you able to scroll all three sheets with the mouse?  If so, what might be the issue at my end?

       

       

      Sandip.

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        sandipgumtya365 

        Yes, I can scroll all sheets in that workbook with the mouse.

        I have also looked at the properties of the sheets in the Visual Basic Editor and didn't find anything special. So I have no explanation for the behavior that you experience, sorry.

Resources