Uploaded March 2025 | Updated September 2026, 2 weeks ago
How to Create a drop-down list in Excel
Creating a drop-down list can make your work easier, faster, and more efficient.
Let’s dive into it and simplify your data management like a pro!
Method-1
1. Open the Excel workbook.
2. For this method-1, I list vegetables and fruit names in the second worksheet.
3. Select the cell where you want the drop-down list.
4. For example, I am selecting this blank cell of B1 for the Product Names List.
5. Click on the Data tab in the Ribbon.
6. Select Data Validation from the Data Tools group.
7. In the Data Validation dialog box, go to the Settings tab.
8. Under Allow, choose List from the dropdown options.
9. In the Source field, click the range icon on the right side.
10. Now, click on Sheet2 at the bottom, and select the range of product names.
11. Click on the range icon again in the Data Validation, and click on the OK button.
12. This will create a list of Product Names.
13. Now, select the next blank cell of B2, Click on the Data Validation in the Ribbon.
14. Under Allow, choose List from the dropdown options.
15. In the Source field, type the items for your list, separated by commas (e.g., Fruits, Vegetables).
16. Click OK to save and apply the drop-down list to the selected cell.
17. Similarly, we will create a list of Stock Status in the blank cell of B3.
18. This time, we will type the status in the Sources field (In Stock, Out of Stock)
19. Test the drop-down list by clicking the arrow in the cell.
Method-2
1. Convert your list of items into a Table by selecting the range and pressing Ctrl + T.
2. Click OK to create the dynamic drop-down list.
3. Let’s try and see how this drop-down will behave.
We hope this tutorial made creating drop-down lists in Excel easy and fun
Please Like this video and subscribe to our channel for more helpful tech tips on Windows.
Thanks for watching!
How to Create a drop-down list in Excel
Creating a drop-down list can make your work easier, faster, and more efficient.
Let’s dive into it and simplify your data management like a pro!
Method-1
1. Open the Excel workbook.
2. For this method-1, I list vegetables and fruit names in the second worksheet.
3. Select the cell where you want the drop-down list.
4. For example, I am selecting this blank cell of B1 for the Product Names List.
5. Click on the Data tab in the Ribbon.
6. Select Data Validation from the Data Tools group.
7. In the Data Validation dialog box, go to the Settings tab.
8. Under Allow, choose List from the dropdown options.
9. In the Source field, click the range icon on the right side.
10. Now, click on Sheet2 at the bottom, and select the range of product names.
11. Click on the range icon again in the Data Validation, and click on the OK button.
12. This will create a list of Product Names.
13. Now, select the next blank cell of B2, Click on the Data Validation in the Ribbon.
14. Under Allow, choose List from the dropdown options.
15. In the Source field, type the items for your list, separated by commas (e.g., Fruits, Vegetables).
16. Click OK to save and apply the drop-down list to the selected cell.
17. Similarly, we will create a list of Stock Status in the blank cell of B3.
18. This time, we will type the status in the Sources field (In Stock, Out of Stock)
19. Test the drop-down list by clicking the arrow in the cell.
Method-2
1. Convert your list of items into a Table by selecting the range and pressing Ctrl + T.
2. Click OK to create the dynamic drop-down list.
3. Let’s try and see how this drop-down will behave.
We hope this tutorial made creating drop-down lists in Excel easy and fun
Please Like this video and subscribe to our channel for more helpful tech tips on Windows.
Thanks for watching!
