How do I delete blank rows at the bottom of a spreadsheet to get .

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!

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" <[email protected]> wrote in message
news:[email protected]...
>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!