How do I use Named Ranges as Data Validation Lists?

[Chris Mitchell]

I have a spreadsheet in which I have three named ranges, NR1, NR2 & NR3. I
would like to be able to use these named ranges as data validation lists. I
have set up data validation lists by selecting the three ranges, but I
cannot see how to use the named ranges by name. I have tried typing the
names 'NR1' in the Source field of the Data Validation - Settings tab but to
no avail.

Do I have to precede the name with something in Source field of the Data
Validation - Settings tab?

Or can I somehow see and select from the named ranges with my spreadsheet?

 

[Guest]

Chris,

in Source: =NR1 (need the "=" sign)

 

[Chris Mitchell]

Thanks Toppers.

Chris,

in Source: =NR1 (need the "=" sign)