Forum Discussion
How do I add a name to my drop down list in excel
You should close the Data Validation settings. You do not have to change anything there for now. Once closed, just type the name below Erika's as if you were simply writing a simple cell value in your spreadsheet.
Martin_Angosto hello and thank you for your reply. I am trying to add an employees name
to the current drop down menu on my spreadsheet and I cannot figure out how to do it
If you want to edit the dropdown list of a previously created dropdown menu, select the cell containing the list, go to Data Validation and on "Source" space, you will see the source of this dropdown menu.
It is possible that the source is directly written there, for instance:
In that case, just directly add the employee name by separating it with a comma or a semicolon (depending on the language settings of your Excel).
It is also possible that the source of the list is referenced through a range:
In that case, go to that range and add a row/column with the new employee name and then edit the written range on the "Source" space.
- My source is referenced through a range. In the source box, there is a formula there, do I type the employee name after the formula in the source box? I have tried this and I get an error message that the formula is not valid?
Can you please share at least a screenshot of the formula and the range that it references? As long as it doesn't disclose sensitive information.
