how do I add another item to an existing drop down.

R

Reitanos

If you double-click on the drop down (or right-click and choose Format
Control) you will find that the drop down has an Input Range where it
pulls in the data. You'll have to edit the range in the sheet and the
range listed in Format Control.
Note that if it says a NAME (instead of a range) in the Input Range
field that it is using a range name that could be redefined with
Insert/Name/Define.
 

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

Formatted cell column in drop down list 1
How do I create a drop down box within a drop down box? 1
Filtered drop down list 2
Drop down box w/contents of different worksheet? is this possible 1
Date Range Drop Down Menu 1
How do I format the Font in an Active X Drop Down List? 0
can I define validation range by function? 1
Drop Down List Question 5

Top