![]() |
How to the cell in the last entry in a work book?
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? |
How to the cell in the last entry in a work book?
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. Narnimar wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com