One sheet is scrolling 3500 per inch moved

[Guest]

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

 

[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

--

 

[Guest]

Im not sure if this will fix it. It sounds like your worksheet may have some
data in a cell around the 65536th cell. Try highlighting a cell below any
data you have and highlight all the data down to row 65536 and hit delete.
That probably wont have an effect right away, but if you save and close
reworkbook and reopen it it may reset the scrollbar back to normal. Does
anyone with more experiance in excel have any thoughts on that idea?

If that fails perhaps you can just copy all your data from that worksheet
and put it into a new worksheet. If you do try this make sure you highlight
the data manual and dont use Ctrl A or the button that highlights everything.