End of data
 

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.

End of data
 

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