Easy Explanation Notes with Examples

Create a drop-down list in Excel

Drop-down list in Excel is created to make sure that users select an option from a list instead of typing, hence chances of error may decrease and efficiency improve.

1- Type available options in another sheet.

2- On the first sheet, select B3 cell.

3- Go to the Data tab, in the Data Tools section, select Data Validation Or Alternatively, press Alt + A + V. The Data Validation box will appear.

4- In the Allow option select List then click in the Source box and select the range A1:A3 from Sheet2. Press OK.

5- Result. A drop-down list will appear in B3.

Previous Lesson: Data Validation in Excel

Next Lesson: Budget Limits

Copyright © 2016 - 2019 Explainry.com | All Rights Reserved