Select and Delete the undesired Rows, then Save the file to reset the
"last cell".

Laura wrote:

Hey y'all,

Somehow my spreadsheet, which contains about 350 rows of populated data,
includes rows all the way down to 2500. This makes the scroll bar very small,
and it's just plain annoying. I've tried deleting, hiding, setting print
area, doing the edit-go to-special-blank-delete thing, and nothing works.
This doesn't affect data quality or even print range, but it makes the
scrolling hard to do, and it's bugging me. How do I fix this?