Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I Select Multiple entries from Valid list for a Cell
I want to have the ability to select multiple entries from a Valid List of
predefined entries. I would like each data item on a separate line within the cell (much like doing an alt-Return. |
#2
|
|||
|
|||
You can do this with programming. There's a sample file here that lets
you select multiple items from a data validation list: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'Select Multiple Items from Dropdown List' WIDBIS wrote: I want to have the ability to select multiple entries from a Valid List of predefined entries. I would like each data item on a separate line within the cell (much like doing an alt-Return. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter list of text for unique entries using formulea | Excel Worksheet Functions | |||
Deleting duplicate entries in an Excel list | Excel Worksheet Functions | |||
Deleting duplicate entries in Excel list | Excel Discussion (Misc queries) | |||
Latest date from multiple list | Excel Worksheet Functions | |||
Select all data, multiple rows | Excel Discussion (Misc queries) |