On Excel, how can I tell which other worksheets dependents are on?

XLerate

New Member
Joined
May 12, 2020
Messages
1
Office Version
365
Platform
MacOS
When I click "Trace Dependents" for a cell on a given worksheet and the little arrow picture shows that it has dependents on other worksheets in the workbook, how can I find out exactly which other cells of which other worksheets are dependents of the original cell?
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,050
Office Version
365
Platform
Windows
Hi & welcome to MrExcel.
Double click the dotted line.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,701
Messages
5,470,280
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top