Forum Discussion

Copper Contributor

Nov 07, 2019

Drop down list data validation

Thanks for your assistance. I have created some new worksheets with the drop down list target choices and set up the drop down lists on the main worksheet. However, my drop down list choices are decr...

Drop-Down

Riny_van_Eekelen

Platinum Contributor

Nov 07, 2019

Howard_Jones

Suppose your list is in A1:A20. Make sure that the reference to this list in the Data validation is like

=$A$1:$A$20

Leaving the dollar signs out will cause the effect that you describe.

Howard_Jones

Copper Contributor

Nov 07, 2019

Hi Riny, Thank you. You have more $ signs in your string than were shown in the MS help section about this. I will try this out in the morning.

Regards,

Howard