How to Create a Drop-Down List in Excel

A drop-down list restricts data entry to a specific set of predefined options.

Creating a Drop-Down

1. Select the cells where you want the drop-down.
2. Go to the Data tab and click Data Validation.
3. Change “Allow” to List.
4. In the Source box, type your options separated by commas (e.g., Yes, No, Maybe) and click OK.