+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Amber
    Guest

    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

  2. #2
    Max
    Guest

    Re: 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
    ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1