How do i add a new entry to an existing drop-down list in Excel?
 

I've named the list of options in a new sheet in the same workbook. When I
try to add a new option to the existing list, it will not let me rename the
new list (which includes the new entry) the old name.

How do i add a new entry to an existing drop-down list in Excel?
 

Insertnamedefine, select the name and change the cell reference in the
refers to box and click add or use a dynamic range


http://contextures.com/xlNames01.html#Dynamic



--
Regards,

Peo Sjoblom


"ABD" wrote in message
...
I've named the list of options in a new sheet in the same workbook. When
I
try to add a new option to the existing list, it will not let me rename
the
new list (which includes the new entry) the old name.

How do i add a new entry to an existing drop-down list in Excel?
 

Would you be interested in using a Dynamic Range Name, which would
automatically expand and contract to match the data volume?
(no vba programming necessary)

See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ABD" wrote:

I've named the list of options in a new sheet in the same workbook. When I
try to add a new option to the existing list, it will not let me rename the
new list (which includes the new entry) the old name.