I need help to update drop down list on Microsoft Excel
OK, I've done this before but I can't update a drop-down list. If I click all the items in the drop down list, the name shows in the source box. I want to add more items to the list. I type them in below, and then I select the old ones plus the new ones, and I type in the drop-down list name, but then it just selects the old items. How can I add new items? Also, how can I delete drop down lists if I am not using it anymore? I don't see any sort of drop-down list manager or anything. Thanks
re: I need help to update drop down list on Microsoft Excel
All you need to do is click on Data > Validation > Select list, and adjust Source range or Delete All.
re: I need help to update drop down list on Microsoft Excel
It is certainly somewhere else, unfortunately I don't have Excel 2007, so I can't help to find it, but if you make a search for Data validation in Help, it certainly shall explain where to find it.
re: I need help to update drop down list on Microsoft Excel
For Excel 2007 it is Data tab > Data Validation. But what you really need to do is to create a dynamic list for your validation range. Suppose your list is on Sheet2, column A then Formula tab > Define Name > Name > myList > refers to > =OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A))