#1
|
|||
|
|||
Named range drop-down
I know this is a simple question/solution because I have done it before. I have a named range and I want to have a field reference that named range. I want it to look like a combo-box (See attached image). I have pulled my hair out trying to replicate this . I know it refers to a named range, but I don't know how it ties to that named range. I am using Excel 2010. Thank you.
|
#2
|
||||
|
||||
Hi,
On the ribbon go to the Data tab > Data Validation On the settings tab Allow: List and put your named range in as the source. |
Tags |
named range, range |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |
Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |
Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |
Range Formula | aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Printing a Page Range | cmc | Word | 0 | 04-20-2009 10:32 AM |