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.