how to find every cell that has a dependent

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
779
I love the "Trace Dependents" function in Excel but it has a significant limitation. I have to click on every single cell individually to see if it has a dependent.

Is there a way to select an entire range of cells and see which of them has one? I don't even need to know what the dependents are, just need to see which has one.

Btw I need to do this at work and VBA is disabled here, so a non-VBA solution would be nice, if it exists :)
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,441
Office Version
  1. 365
Platform
  1. Windows
Select all the cells on the sheet > Ctrl G > Special > Precedents > Ok
This will select all cells that formulae in that sheet depend on.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,181
Messages
5,527,278
Members
409,756
Latest member
punknwilly

This Week's Hot Topics

Top