excessive rows when scrolling down

on one wkst i'm only using rows 1-284,
but when i use the scroll bar it goes all the way down to like 700 something,
i want it just so when i move the scroll bar to the bottom it only goes to my
last line...any clues?

Posted this reply to you in the other thread
a couple of minutes ago ..

Try the steps outlined in Debra's page at:
http://www.contextures.com/xlfaqApp.html#Unused
"To manually reset the used range"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Chantel" <[email protected]> wrote in message
news:[email protected]...
> on one wkst i'm only using rows 1-284,
> but when i use the scroll bar it goes all the way down to like 700
something,
> i want it just so when i move the scroll bar to the bottom it only goes to
my
> last line...any clues?
>