Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
How do you add to a pre-existing drop down list?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Select the cell that contains the list, and choose Data Validation
You may see a list typed in the source box. If so, you can add new items, then click OK If you see a range reference, e.g. =$A$1:$A$10 you can add items to that range. Then, in the Data Validation dialog box, change the reference to include the new rows. There's information in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Sara wrote: How do you add to a pre-existing drop down list? -- 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 | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |