This looks like it could do the trick. Of course now I've gone back into
excel the problem has gone away, it's been with me for weeks, there you go
that's Microsoft for you... hopefully next time it happens the ASAP software
will come into play. Thanks very much for that. Sheila.


"Brad" wrote:

ASAP has its ubiquitous (and free) mega utility and among them is a delete
all unused rows command. There are so many useful utilities on this add-in,
I can't imagine not having it available for quick requirements like the one
you have. Google it up and take a look. Brad



"Frustrated Excel User" <Frustrated Excel
wrote in message ...
My table has 1000 rows but the right hand scroll bar keeps on going down
beyond 10,000 rows, can anyone tell me why or how to get rid of them?
Thanks.