This tutorial explains how to make a drop-down list in Excel.
Boost your productivity at unbelievably low costs with our 100% legal Microsoft licenses! Explore super affordable deals, unlock powerful features, and transform your digital experience today. Upgrade now for legitimate value!
- Enter some values in single cells (f.e. H3:H7)
- Click on the Data menu and navigate to Data Validation
- Click Data Validation…
![](https://usercontent.one/wp/www.ict-pedia.com/wp-content/uploads/2023/03/dd1-1024x208.jpg?media=1679149463)
- In the Data Validation form, on the Settings tab
- Allow: List
- Source: select the cells where you declared the values
- Click OK
![](https://usercontent.one/wp/www.ict-pedia.com/wp-content/uploads/2023/03/dd2.jpg?media=1679149463)
- Now, you have a drop-down list
![](https://usercontent.one/wp/www.ict-pedia.com/wp-content/uploads/2023/03/dd3.jpg?media=1679149463)