| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picklists
Thanks, Elkar.
That did it! "Elkar" wrote: In the Source Field, did you precede the name of your range with an equal sign? =Your_Range HTH, Elkar "Darren" wrote: I'm trying to create a picklist of values to select from and running into issues. I defined the values I want to choose from on a separate worksheet in the some workbook and assigned it a name. When I go to the worksheet where I want to access the picklist, I did the following: Data Validation In the allow section, I selected "List" and in the source field, entered the name of the range I had defined. Excel is only displaying the name of the range that I entered, not the actual values I need. Any thoughts??? Thanks, Darren |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables Picklists | Excel Discussion (Misc queries) | |||
| Does excel support multi-value picklists? | Excel Worksheet Functions | |||
Threaded Mode
