Forum Discussion
Solved
Where is my drop down list to edit?
Hi there I'm working with a worksheet that has Data Validation on a column of cells - a drop down list of document types (e.g. News item, Article, Proposal) that only permits you enter to enter one ...
The screenshot shows that the source list is the range A2:A17 on the sheet RefData.
If RefData is hidden, you can try to unhide it:
- Right-click the sheet tab of any sheet, it doesn't matter which one.
- Select Unhide... from the context menu.
- Select RefData, then click OK.
The screenshot shows that the source list is the range A2:A17 on the sheet RefData.
If RefData is hidden, you can try to unhide it:
- Right-click the sheet tab of any sheet, it doesn't matter which one.
- Select Unhide... from the context menu.
- Select RefData, then click OK.
Member: HansVogelaar | Microsoft Community Hub
For Hans or anyone who can help...
I'm trying to edit a drop down list, as well, and I cannot find the source, as well. However, my Data Validation/Settings window is not showing any "Source", so I'm at a complete loss. Please see the 3 screenshots. One for each of three different choices of "Allow."
- Thanks Hans. It was the 'Unhide' part I didn't understand. Thank you so much. It's so easy when you know how!
