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.