Getting back to original cell after tracing precedents

msh0506 · May 7th, 2002, 08:50 AM

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.

Tom Schreiner · May 7th, 2002, 09:40 AM

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

msh0506 · May 7th, 2002, 11:20 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 08:50 AM	#1
msh0506 New Member Join Date: May 2002 Posts: 2	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.

May 7th, 2002, 09:40 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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

May 7th, 2002, 11:20 AM	#3
msh0506 New Member Join Date: May 2002 Posts: 2	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.