Debra Dalgleish does share some techniques for resetting that usedrange:
http://contextures.com/xlfaqApp.html#Unused

I don't speak the Unix.

Kevin wrote:

I have a spreadsheet that sorts through a lot of rows and ends up with way
fewer rows than what it started out with.

Is there a way to mark the last row as the end of data so that the page
scrool bar returns to normal?

There is also a unix script that looks at this and errors out on the blank
cells after the end of the data.

I know the unix script could be modified but I'd like to make the adjustment
in the spreadsheet if possible.

--

Dave Peterson