Forum Discussion
TeeGoodwin
May 08, 2024Copper Contributor
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
- May 08, 2024
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
May 08, 2024Iron Contributor
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.
TeeGoodwin
May 08, 2024Copper Contributor
- Martin_AngostoMay 08, 2024Iron Contributor
Below Erika Olis, write the name of the employee you wish to add to the list. Theoretically, it will automatically appear in the dropdown list.
- TeeGoodwinMay 08, 2024Copper ContributorIf I type the name under Erika’s name, it changes the source? Do I type anything in the source area?
- Martin_AngostoMay 08, 2024Iron Contributor
As you can see already typed in your "source", the formula is taking the range H4:H22 to generate the dropdown list. As your name list are only from H2:H20, you still have 2 more spaces in order to write additional employees before needing to change anything in the "source" part.
Please just write the name of the employee you want to add below Erika's and do not even modify anything in the data validation settings. You should be able to see this new name in the dropdown list directly.