Forum Discussion

lowrain7's avatar
lowrain7
Copper Contributor
Apr 23, 2020

Scroll Bar Excel

My scroll bar on the right is jumping to the end of the worksheet.  If I move the scroll bar with my mouse 1 cm it jumps to row 6543. Can you help me fix this?  thanks

 

4 Replies

  • deepkya's avatar
    deepkya
    Copper Contributor

    lowrain7 Check if there is any formatting beyond your data. Press CTRL+END or CTRL+DOWN arrow which will take you to the last row with your scroll bar at the end. Delete blank rows which will increase size of your scroll bar.

    • lowrain7's avatar
      lowrain7
      Copper Contributor

      deepkya   Thank you very much!  I appreciate your help.  The worksheet is fixed.  It had over a million rows and there was a value in row 1048575.

       

      WOW!  Thanks again!

  • redheadfsa's avatar
    redheadfsa
    Copper Contributor

    lowrain7 I have a scroll bar problem too! Windows 10, Office 2016. I  have a sheet that has 300 or so records. The 'bar' remains at the top. If i tri to move it, it jumps to row 5000 or higher. I can click inside the scroll section and the page moves down, but the bar doesn't move. It's only on this one sheet in the workbook!

Resources