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?
|