How do I use Named Ranges as Data Validation Lists?
 

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?

How do I use Named Ranges as Data Validation Lists?
 

Chris,

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

"Chris Mitchell" wrote:

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?

How do I use Named Ranges as Data Validation Lists?
 

Thanks Toppers.


"Toppers" wrote in message
...
Chris,

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

"Chris Mitchell" wrote:

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?