ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   GoTo the cells in another worksheet that are linked (https://www.excelbanter.com/excel-worksheet-functions/7059-goto-cells-another-worksheet-linked.html)

ramudo

GoTo the cells in another worksheet that are linked
 
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)?

Harlan Grove

"ramudo" wrote...
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.




All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com