|
|
#1
04-08-2011, 06:26 AM
|
|||
|
|||
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
04-08-2011, 03:08 PM
|
||||
|
||||
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 |
Windows XP 
Office 2010 32bit
Linear Mode
