How do I delete existing data from a drop down menu list?

[Tasneen]

I am trying to update data in a spreadsheet that has a drop down menu list. I
need to update the data in the menu list. How do i go about doing that? can
it be done?

 

[Max]

Assuming the dropdown is data validation (DV), you have to change it at
source. Select any cell with the dropdown, click Data > Validation > Settings
tab. Look at the "Source" box which will reveal where the source list is.
Edit the source as required, then extend the source range as required. If the
source is a defined range (a named range), click Insert > Name > Define to
find out where it is, then edit/extend as required.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik