I want to insert a drop-down list in my Excel worksheet to provide a selection of options for a specific cell. What is the process for adding a drop-down list in Excel?
Vishalini.R Answered question April 19, 2023
The process for adding a drop-down list in Excel
1. Select the cells that will house the lists.
2. Select DATA > Data Validation from the ribbon.
3. Change Allow to List in the dialogue.
4. In Source, input the text or numbers (separated by commas for a comma-delimited list) that you want in your drop-down list, and then click OK.
Vishalini.R Answered question April 19, 2023