Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post

    Smooth Vertical Scrolling in Excel

    Is there a way to get Excel (2000) to do vertical scrolling like Word where the screen view moves as the scroll bar is dragged up and down? I really hate the way it has always worked for me where you move the scroll bar and the screen doesn't reposition until you release it.

    Thanks, Bill

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I believe that all versions of Excel scroll one row at a time, although I don't have a copy of Excel 2000 on which to test this.

    I think the behaviour you are seeing is a Windows display setting, not one of Excel's.

    I'd Google for "smooth scrolling" in whatever version of Windows you are using, and take it from there.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post
    I'm not worried about the 1 row at a time. My problem is that when I move the scroll bar a little ways -- say 1 inch -- the sheet display does not move until I release the mouse button. Scrolling in Word or IE does not do that; it moves the display in the window as I move the scroll bar. My Excel has always been this way and it occurred to me that surely there is a way to fix this 'problem'. I did your suggested search on google and it came up with discusions of the one cell at a time situation but I didn't find anything on my situation.

    Thanks,
    Bill

  4. #4
    Super Moderator
    Join Date
    Jun 2011
    Location
    New England
    Posts
    4,746
    Thanks
    171
    Thanked 649 Times in 572 Posts
    You could try switching off "Provide feedback with Animation": Very Slow Scrolling in Excel 97, 2000

    Bruce

  5. #5
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post
    Bruce,
    That setting was already unchecked so that didn't help. In case there is any confusion, when I start to scroll, the current row number is display right beside the scroll bar slider when I press the mouse button and as I move the slider that number keeps changing to show where the screen will update to when I release the mouse button. It is certainly a designed-in feature. Does Excel not work that way for the rest of you?

    Thanks,
    Bill

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Bill,

    In Excel 2010 it scrolls w/o releasing the mouse button and displays the row number in the upper right of the screen just below the column numbers.
    In Excel 2003 it scrolls w/o releasing the mouse button but does NOT display the row number.
    Sorry, that's the oldest copy I have to test with.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post
    Thanks for the info. Maybe my Excel 2000 just doesn't have any other choice.

    Bill

  8. #8
    New Lounger
    Join Date
    Apr 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That may be a Windows setting. In Win 7 it's under System > Advanced System Settings > Advanced > Settings. Make sure "Smooth-scroll list boxes" is checked.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post
    Thanks for the suggestion, Slim.

    Bill

  10. #10
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Bill,

    Interestingly, you can place a scrollbar active X control on a form with the form ShowModal proprerty set to false. Set the Max to around 200. Sheet scrolling is very smooth and you can position the scroll bar where you want. May not be a solution in your version of Excel (done in 2010) but you can try. Tried placing the scrollbar on the sheet (active X and Form control) but does not work smoothly at all and you have to adjust the position or else it scrolls of the page as well.

    scrollbar2.png

    Code:
    Private Sub ScrollBar1_Change()
    If ScrollBar1.Value < 1 Then Exit Sub
    ActiveWindow.ScrollRow = ScrollBar1.Value
    TextBox1.Value = ScrollBar1.Value
    End Sub
    
    Private Sub ScrollBar1_Scroll()
    If ScrollBar1.Value < 1 Then Exit Sub
    ActiveWindow.ScrollRow = ScrollBar1.Value
    TextBox1.Value = ScrollBar1.Value
    End Sub

  11. #11
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post
    Interesting! I like that idea. Thanks for the info.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •