drop down list
 

How do you add to a pre-existing drop down list?

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