Forum Discussion
Locating a Data Validation table
How can I locate a drop-down list in an excel document that someone else created? I've been given a document that was already set up and I need to make changes.
Under the home tab > editing section > magnifying glass > "Go To Special" > Data validation.
This should highlight the cell that contains data validation for you.
This should highlight the cell that contains data validation for you.
PReagan Correct, but I am looking for the source of the list? It is somewhere within the workbook, but I cannot locate it.
- Click on the drop-down list > under Data Tab click Data Validation > Under Settings you should see the Source of the list.
=Table!$A$2:$A$7 This is the area in which the drop-down list is used, not the source of the list. It is hidden somewhere in the workbook.
