ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get an xls to open from the last cell that data is enter (https://www.excelbanter.com/excel-discussion-misc-queries/88568-how-do-i-get-xls-open-last-cell-data-enter.html)

Amber

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

Max

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