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.
|