Drop-down list in Excel is created to make sure that users
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