Forum Discussion
Solved
How do I add a name to my drop down list in excel
Hello, I am looking for instructions on how to add a name to a drop down list on my spreadsheet
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.
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?
