Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Getting back to original cell after tracing precedents

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    After jumping to another spreadsheet using 'Trace precedents' tab, is there a way to get back to the original cell from where the precedents are linked.

    Same question for dependents.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What version of office are you using?
    I'm using 2000 and just the references are shown. The selection does not change.
    Am I doing something differently than you?
    Tom

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To reply to your question TSTom, when the precedent is in another sheet, an icon pops up on the screen. You can click on it and it tells you where the cell is being referenced from. you can then chose to be taken to that sheet. My issue is that I want to come back to my original sheet i.e. from where I started, without manually having to come back.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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