View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How does one ADD to a dropdown list?

Did you create the drop-down using Data Validation? If so, select the
cell and click on Data | Validation | Settings tab. Under Allow: you
should have List, and then check that the Source box references your
amended data.

Hope this helps.

Pete

On Sep 22, 12:45*am, Paralegal
wrote:
I created a dropdown list. I tried to add another item to the list, but the
list does not seem to want to include it. I've blocked the list, go into the
name field, use the same name, but it defaults to my original list and does
not include my additional rows/items.