GoTo the cells in another worksheet that are linked

R

ramudo

How can I go directly to the cells in another worksheet that are linked to a
specific cell (so as to not navigate a large spreadsheet to find them)?
 
H

Harlan Grove

ramudo said:
How can I go directly to the cells in another worksheet that are linked
to a specific cell (so as to not navigate a large spreadsheet to find
them)?

Use Tools > Auditing > Trace Dependents to display arrows to cells linked to
the active cell, then double click on such an arrow to display a Goto dialog
that lists the cells linked to the active cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top