SOLVED

Where is my drop down list to edit?

%3CLINGO-SUB%20id%3D%22lingo-sub-2802231%22%20slang%3D%22en-US%22%3EWhere%20is%20my%20drop%20down%20list%20to%20edit%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802231%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3EI'm%20working%20with%20a%20worksheet%20that%20has%20Data%20Validation%20on%20a%20column%20of%20cells%20-%20a%20drop%20down%20list%20of%20document%20types%20(e.g.%20News%20item%2C%20Article%2C%20Proposal)%20that%20only%20permits%20you%20enter%20to%20enter%20one%20of%20the%20options%20from%20the%20list%20in%20that%20cell.%3C%2FP%3E%3CP%3EI%20need%20to%20add%20a%20couple%20more%20entries%20to%20this%20list%2C%20but%20I%20can't%20find%20where%20it%20is%20located!%20There%20are%20no%20other%20worksheets%20showing%2C%20so%20I%20presume%20it%20is%20'hidden'%20somewhere.%20How%20do%20I%20find%20it%3F%20I've%20tried%20using%20the%20Data%20Validation%20menu%20option%20(screenshot%20attached)%2C%20but%20it%20doesn't%20seem%20to%20tell%20me%20the%20location%20of%20the%20list.%20Can%20anyone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EGareth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2802231%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2802248%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20is%20my%20drop%20down%20list%20to%20edit%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172120%22%20target%3D%22_blank%22%3E%40GarethChadwick%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20screenshot%20shows%20that%20the%20source%20list%20is%20the%20range%20A2%3AA17%20on%20the%20sheet%20RefData.%3C%2FP%3E%0A%3CP%3EIf%20RefData%20is%20hidden%2C%20you%20can%20try%20to%20unhide%20it%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ERight-click%20the%20sheet%20tab%20of%20any%20sheet%2C%20it%20doesn't%20matter%20which%20one.%3C%2FLI%3E%0A%3CLI%3ESelect%20Unhide...%20from%20the%20context%20menu.%3C%2FLI%3E%0A%3CLI%3ESelect%20RefData%2C%20then%20click%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
New Contributor

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 of the options from the list in that cell.

I need to add a couple more entries to this list, but I can't find where it is located! There are no other worksheets showing, so I presume it is 'hidden' somewhere. How do I find it? I've tried using the Data Validation menu option (screenshot attached), but it doesn't seem to tell me the location of the list. Can anyone help?

 

Thanks

Gareth

2 Replies
best response confirmed by GarethChadwick (New Contributor)
Solution

@GarethChadwick 

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!