Uploaded February 2024 | Updated September 2026, 2 days ago

---

Creating a drop-down list in Excel is like giving someone a menu instead of asking them what they want to eat without any options. It makes entering data faster and easier because you can just pick from a list of choices you've already set up. This is super helpful because it:

📣 Below you will find a step by step guide to How to create a drop-down list in Excel.

First of all select the cell where you want to set the drop down list , under the data , you will find Data Validation .
click data validation . Once click data validation , You will see a popup window .

- from allow section select List
- click source field and type there your text and separate them by coma.
For a long list you can use a different sheet . where you will write the list items. Select all the cells and click ok.
so it was super easy to add a drop down list in excel .

#Excel #microsoft #tutorial
❤️
--------------------------------------
✅ Watched the video!
🔲 Liked & Shared ?
🔲 Subscribed?
--------------------------------------
❤️ Follow Us
↗️ Facebook - facebook.com/brimitech