Forum Discussion

ddsmith52's avatar
ddsmith52
Copper Contributor
Jul 24, 2019

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.
excel
PReagan's avatar
PReagan
Bronze Contributor
Jul 24, 2019
Under the home tab > editing section > magnifying glass > "Go To Special" > Data validation.

This should highlight the cell that contains data validation for you.
  • ddsmith52's avatar
    ddsmith52
    Copper Contributor
    Jul 24, 2019

    PReagan   Correct, but I am looking for the source of the list?  It is somewhere within the workbook, but I cannot locate it.

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Jul 24, 2019
      Click on the drop-down list > under Data Tab click Data Validation > Under Settings you should see the Source of the list.
      • ddsmith52's avatar
        ddsmith52
        Copper Contributor
        Jul 24, 2019

        =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.

         

Resources