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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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
> > >
> >
> >
>
>
>
>