Excel: Using Data Validation for Accessible Drop-Down Lists

Overview

Drop-down lists improve data accuracy and accessibility.

Considerations

• Ensure list items are clear and meaningful.

Steps

1. Select the target cell.

2. Go to Data > Data Validation.

3. Under Settings > Allow, select List.

4. Enter list items into Source section. All items should be separated by comma (,) without any blank. 

5. Select OK.