Have a look here on how to reset the used range
http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Miklaurie" wrote in message
...
I have a spreadsheet that has been edited, expanded, edited. etc...
Now, it' is down to about 1500 rows, yet the slider bar on the right is
very
tiny. When I hit Control+End to get to the end of the worksheet, it takes
me
to Column AA, Row 7569.
I have selected all the rows betwee 1600 and 8000 and deleted them, but
the
vertical scroll bar and Control+End still takes me to 7569.
What can I do to fix this?
Thanks!