I have a spreadsheet that is very long. Most of the data has been filtered
and deleted; however, the file still seems to have numerous blank lines
associated w/ it in the rows below the last data line.

Is there a way to reset or update the End of Col value so that the
spreadsheet no longer thinks these deleted rows still contain data?

For example if there are 4000 rows of data in a sheet, and 3000 are deleted,
is there a way to get the file to recognize that the data ends after row 1000
now instead of 4000?

Thanks.