excel deleting rows last cell does not change. How to change?
 

I Delete rows in excell and save the file. I bring the file back up but the
last cell is still where it was (several rows below the last row with data).
I do I get excel to change the last cell value?

-Mark

Sounds like you're deleting cell contents instead of deleting entire rows.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"mrubey" wrote in message
...
I Delete rows in excell and save the file. I bring the file back up but
the
last cell is still where it was (several rows below the last row with
data).
I do I get excel to change the last cell value?

-Mark

more likely missing the last step described on your webpage -- saving the file.


"Anne Troy" wrote in message ...
Sounds like you're deleting cell contents instead of deleting entire rows.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"mrubey" wrote in message
...
I Delete rows in excell and save the file. I bring the file back up but
the
last cell is still where it was (several rows below the last row with
data).
I do I get excel to change the last cell value?

-Mark

Dave,

Thanks. The solution was to turn off the auto filter and freeze pane, save
the file, close the file, then open the file again and reset the auto filter
and freeze pane.

-Mark


"David McRitchie" wrote:

more likely missing the last step described on your webpage -- saving the file.


"Anne Troy" wrote in message ...
Sounds like you're deleting cell contents instead of deleting entire rows.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"mrubey" wrote in message
...
I Delete rows in excell and save the file. I bring the file back up but
the
last cell is still where it was (several rows below the last row with
data).
I do I get excel to change the last cell value?

-Mark