Drop down list
 

Is there a way to edit and remove something from a drop down list?

Drop down list
 

hi,
yes. what kind of drop down lists. data validation, sheet combo box, form
combo box, other.......
if data validation,
on the menu bar....
datavalidation...
on the setting tab, at the bottom should list a range address where the
source data is at. edit the source data.

post back if that don't work.

Regards
FSt1


"Cheri" wrote:

Is there a way to edit and remove something from a drop down list?

Drop down list
 

There is no range address where the source data is at. It's a list that was
created automatically from data I've entered into a certain column.

"FSt1" wrote:

hi,
yes. what kind of drop down lists. data validation, sheet combo box, form
combo box, other.......
if data validation,
on the menu bar....
datavalidation...
on the setting tab, at the bottom should list a range address where the
source data is at. edit the source data.

post back if that don't work.

Regards
FSt1


"Cheri" wrote:

Is there a way to edit and remove something from a drop down list?

Drop down list
 

hi
then edit that column because that should be the source.

regards
FSt1

"Cheri" wrote:

There is no range address where the source data is at. It's a list that was
created automatically from data I've entered into a certain column.

"FSt1" wrote:

hi,
yes. what kind of drop down lists. data validation, sheet combo box, form
combo box, other.......
if data validation,
on the menu bar....
datavalidation...
on the setting tab, at the bottom should list a range address where the
source data is at. edit the source data.

post back if that don't work.

Regards
FSt1


"Cheri" wrote:

Is there a way to edit and remove something from a drop down list?

Drop down list
 

Try to edit the list in the column you created.
--
Richard


"Cheri" wrote:

Is there a way to edit and remove something from a drop down list?