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.
- Thanks Hans. It was the 'Unhide' part I didn't understand. Thank you so much. It's so easy when you know how!
