MS EXCEL - Microsoft Community

is there way or command identify   cell/ cells not have dependents range of cells ? 

[moved from: office / excel / other/unknown / office 2016 ]

to check single cell, follow these steps:

1. select cell want check.
2. go home >> formulas >> formula auditing >> trace dependents.

to check range of cells, select it, , use vba code:

sub showcelldependents()
    each cell in selection
          cell.showdependents
    next
end sub

if cell or range of cells has dependents, see arrows pointing them.

Office / Excel / Microsoft Office Programming / Office 2016