Locating a Data Validation table

Question

How can I locate a drop-down list in an excel document that someone else created?&nbsp; I've been given a document that was already set up and I need to make changes.

preagan · Answer

I apologize but I must be misunderstanding your question. Would you mind sharing your workbook so that I may be able to understand your question a little better?**Please omit any sensitive/confidential information

ddsmith52 · Answer

BenSchorr&nbsp; &nbsp;Thank you.&nbsp; The mystery has been solved.&nbsp; The author of the document had hidden a tab where the drop-down list was located.&nbsp; 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.&nbsp; A co-worker showed me how to unhide the tabs.&nbsp; &nbsp;

nabilmourad · Answer

ddsmith52&nbsp;HiFor situations like this (and MUCH more complicated) there is a Tool that comes for Rescue: The INQUIRE Tab of the Ribbon:This tool will enable you to find a Table, data Validation, a Formula, Errors, not only if the Sheet is Hidden but even if the Sheet is VERY Hidden (VBA Term)To add the INQUIRE TAB:File &gt;&gt; Options &gt;&gt; ADD InsManage (lower left corner) &gt;&gt; COM Add-ins &gt;&gt; GoCheck INQUIRE &gt;&gt; Save the File &gt;&gt; Click on WORKBOOK analysis report...&nbsp;Here is a short tutorial about the Magic of the Inquire Tabhttps://www.youtube.com/watch?v=yOHJJcXtQq4Hope that HelpsNabil Mourad&nbsp;

preagan · Answer

Under the home tab &gt; editing section &gt; magnifying glass &gt; "Go To Special" &gt; Data validation.This should highlight the cell that contains data validation for you.

ddsmith52 · Answer

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

Forum Discussion

Locating a Data Validation table

9 Replies

Resources