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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I add another item to an existing drop down. (https://www.excelbanter.com/excel-worksheet-functions/185831-how-do-i-add-another-item-existing-drop-down.html)

Rosalie Andrews

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

Reitanos

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

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.

On May 1, 11:33 am, Rosalie Andrews <Rosalie
wrote:

All times are GMT +1. The time now is 03:43 PM.