How to Update drop-down list?

[db]

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 I am not using anymore? I don't see
any sort of drop-down list manager or anything...?

Thanks.

 

[Stefi]

Data>Validation>Select list, and adjust Source range or Delete All!

Regards,
Stefi

„db†ezt írta:

 

[db]

Stefi

Thanks for the quick response - I forgot to mention I am using Excel 2007.
I do not see any Validation -> Select List option in the Data tab ... is it
somewhere else?

thanks

dan

 

[Stefi]

It is certainly somewhere else, Unfortunately I don't have XL2007, 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, or if you send a new post in this
forum with subject "Where is Data Validation in Excel2007?", somebody
certainly will response.

Stefi


„db†ezt írta:

 

[Roger Govier]

Hi

For XL2007 it is Data tab>Data Validation.

But what you really need to do is create a dynamic list for your validation
range.
Supposing 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))

In your DV, set the list Source=myList

 

[db]

Hi Roger

Name Manager - that it is... I remember I used it a few months ago but I
couldn't find it... thanks for your help.

dan