One sheet is scrolling 3500 per inch moved

  • Thread starter tearingoutmyhair
  • Start date
T

tearingoutmyhair

How do I adjust the amoutn of rows the scrollbar goes in ONE sheet? There are
multiple sheets and there is only one that scrolls about 3500 rows with a one
inch movement of the scrollbar whereas the other sheets move about 20-25. Can
I change that?

Thanks
 
B

Bryan Hessey

I think that you will find scroll bars are a system feature rather than
an Excel problem. The scroll bar is set proportional to the amout of
data there is to traverse, thus a scroll bar that covers 60,000 rows
shows a different movement to a scroll bar that covers only a few more
than what is displayed.

To govern your movement you can single-click within the scroll bar to
either side of the slider to move to the next screenful in that
direction, or use the arrows at the end of the bar to 'smoothscroll'.

HTH

--
 
Top