![]() |
How do I get an xls to open from the last cell that data is enter
Hi
I need some help with this problem. I use an excel spreadsheet to enter data and when I go into the file it opens down the page past all the data and I would like it to open at the last cell where the data was entered. If anyone could help me it would be great! Thanks |
How do I get an xls to open from the last cell that data is enter
"Amber" wrote:
I need some help with this problem. I use an excel spreadsheet to enter data and when I go into the file it opens down the page past all the data and I would like it to open at the last cell where the data was entered. If anyone could help me it would be great! Just some thoughts .. Try saving/closing the book at that point: ".. the last cell where the data was entered" When you next re-open the book, Excel remembers and should bring you right there You could also try this quick navigation in the data entry sheet: Press CTRL+End, then press CTRL+left arrow -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com