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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making drop down selection lists 2
Dependent drop down dynamic range formula, off sheet. 7
How to add entry in the list for drop down in excel? 1
Formatted cell column in drop down list 1
extend the range of cells for a drop down list 8
how do i create a drop-down list using workbooks? 1
drop down list 3
can I autopopulate from a long drop down list in Excel? 2

Top