Forum Discussion
ddsmith52
Jul 24, 2019Copper Contributor
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.
ddsmith52
Jul 26, 2019Copper Contributor
BenSchorr Thank you. The mystery has been solved. The author of the document had hidden a tab where the drop-down list was located. When opening the Data Validation dialog box it referenced "=Table!$A$2:$A$7, but I wasn't able to locate the word "table" in searching each tab. A co-worker showed me how to unhide the tabs.