How do I update a drop down box in Excel?

B

Brandy

I have an existing workbook with drop down boxes in specific cells. I need
to update the information contained in the the drop downs. Can anyone tell
me how to do that?

Thanks!
 
U

ufo_pilot

Inset > Name> Define
check to see where the data is that makes up the list ( could be hidden or
white font on white background if you do not see anything)
 
D

Duke Carey

Select the cell containig the drop down. Now go to the Data menu and choose
Validation... On the Settings tab, adjust the Source range so it contains
only the elements you want in the list
 
Top