Scrolls too fast.

[Jul]

I have a document that scrolls down much further than it
should. What I mean is that the document is only 600
entries, but when the little scroll marker is at the very
bottom, it goes all the way down to 14495.

Normally scroll markers do not go down this far. For
example, another file that has 332 entries, goes to 340
when the scroll marker is at the bottom.

This makes the scroll bar virtually useless since every
tiny movement takes the spreadsheet several hundred
entries down instead of going down slower, like in sets of
10ish.

I would really appreciate it if someone could help me with
this problem. I already checked and there is no invisible
(white) data that is located near the bottom of the
spreadsheet. All the data is in the top 600 rows.

Thanks!

 

[Debra Dalgleish]

There are some instructions here, that may help you reset the used range:
http://www.contextures.com/xlfaqApp.html#Unused

 

[pfsardella]

Debra Dalgleish provides an explanation of what may be occurring along
with a variety of methods for handling the situation.

Basically, Excel thinks that your 'Used Range' extends further down
than 600 rows. You need to delete the excess rows.

http://www.contextures.com/xlfaqApp.html#Unused

HTH
Paul