| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How can I add a value to a list that was set up by someone else?
Spreadsheet cell will accept certain valid cell entries and I would like to
add one more value to complete that list |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How can I add a value to a list that was set up by someone else?
Select the cell then DataValidationSettings
What is in the "Source" dialog? That will be the list...............either a range of cells like =A1:A10 Or a named range like =TheList Or comma-separated values like dog,cat,elephant,mouse Which ever the case you would add to the list. Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 11:50:03 -0700, Doug B <Doug wrote: Spreadsheet cell will accept certain valid cell entries and I would like to add one more value to complete that list |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Linear Mode
