How to the cell in the last entry in a work book?

  • Thread starter Thread starter Narnimar
  • Start date Start date
N

Narnimar

I have lost my track while working when power supply interrupted in a work
book which is having many sheets. Thanks to recovered file by which I can
continue the work. But I forgot that in which cell of the sheet I was typing.
How to go to the same cell or last cell to continue in the recovered file?
 
If you're using xl2002+ and are writing about Autorecovery (not autosave), then
I don't think you'll find an easy way to accomplish this.

Autorecovery saves a copy of the file every so often (user selectable) and then
sits back and waits until the next interval. You could have edited lots and
lots of cells since the last autorecovery file was saved.

In fact, if I were you, I wouldn't limit my review to the last cell I could
remember editing. I'd look back to see which of my changes were the last saved.

For instance, I have autorecovery creating a backup every 10 minutes. I surely
wouldn't just want to look for the cell I was editing when the power crashed.
 
Back
Top