Update End of Col or End of Row Reference
 

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.

Update End of Col or End of Row Reference
 

start at the first blank row. Highlight to bottom of workbook
(Shift/CTRL/Down Arrow) Edit/Delete

Go back to cell A1

Save

"Brent E" wrote:

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.

Update End of Col or End of Row Reference
 

Thanks Sean.

"Sean Timmons" wrote:

start at the first blank row. Highlight to bottom of workbook
(Shift/CTRL/Down Arrow) Edit/Delete

Go back to cell A1

Save

"Brent E" wrote:

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.