How do I get an xls to open from the last cell that data is enter

A

Amber

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
 
M

Max

Amber said:
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!
Click to expand...

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
 
Top