Update End of Col or End of Row Reference

B

Brent E

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.
 
S

Sean Timmons

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

Go back to cell A1

Save
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Data filteration based on multiple criteria 2
How to add columns to the end of a spreadsheet--(last col is IV)? 2
cell returning totals of 2 cols+ sending this value to another col 5
Scroll Bar question 2
End of document 3
Filling an empty row with the data in row above it 2
Use of Ctrl/end keys - Excel 2002 1

Top