Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighting linked columns
A co-worker asked me this:
when you are linking within the same doc but on diff tabs and you want the cursor to highlight the column you linked it to - how would you do that? -- ~ Cheri |
#2
|
|||
|
|||
Maybe this is close.
I can do this in xl2002: Tools|formula auditing|trace precedents then double click on that arrow near the tiny worksheet icon. You'll see the Edit|goto dialog. Select the range you want and hit ok. I'm not sure where this is hidden on earlier versions. Cheri wrote: A co-worker asked me this: when you are linking within the same doc but on diff tabs and you want the cursor to highlight the column you linked it to - how would you do that? -- ~ Cheri -- Dave Peterson |
#3
|
|||
|
|||
"Dave Peterson" wrote in message
... Maybe this is close. I can do this in xl2002: Tools|formula auditing|trace precedents then double click on that arrow near the tiny worksheet icon. You'll see the Edit|goto dialog. Select the range you want and hit ok. I'm not sure where this is hidden on earlier versions. For xl2k, very similar: Tools | Auditing | Trace Precedents --- Regards, Norman |
#4
|
|||
|
|||
Thanks.
Norman Jones wrote: "Dave Peterson" wrote in message ... Maybe this is close. I can do this in xl2002: Tools|formula auditing|trace precedents then double click on that arrow near the tiny worksheet icon. You'll see the Edit|goto dialog. Select the range you want and hit ok. I'm not sure where this is hidden on earlier versions. For xl2k, very similar: Tools | Auditing | Trace Precedents --- Regards, Norman -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) |