Data Validation Audits

  • Thread starter Thread starter Randy Numbers
  • Start date Start date
R

Randy Numbers

Hi all...

Is there a way to trace where a range of cells that represent a picklist is
used? The range has not been named. Thanks../Randy
 
Hi Randy,

Presume you have a pick-list but do not know where is the SOURCE use
for the pick-list - right?

If so, pls click in the cell where there is a pick-list > Then click o
Data > Validation > Settings tab. Look at the "Source" option.

Cheers/cskg
 
Back
Top