Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function with Named Lists in Data Validation | Excel Discussion (Misc queries) | |||
Data Validation and named lists | Excel Worksheet Functions | |||
Validation protection with named ranges | Excel Worksheet Functions | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |