| 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? |
| 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) | |||
Threaded Mode
