--- title: "How do you create dropdown lists in excel?" description: "How do you create dropdown lists in excel?" author: "Steilla Mitchel" published: 2022-03-25 canonical: https://answers.mindstick.com/qa/96518/how-do-you-create-dropdown-lists-in-excel category: "troubleshooting" tags: ["troubleshooting", "excel"] reading_time: 1 minute --- # How do you create dropdown lists in excel? How do you create [dropdown](https://www.mindstick.com/articles/263/ajax-toolkit-dropdownextender-in-asp-dot-net) [lists](https://www.mindstick.com/articles/126273/books-commonly-found-on-college-reading-lists) in excel? ## Answers ### Answer by Hitesh Vohra ![How do you create dropdown lists in excel?](https://answers.mindstick.com/questionanswer/bb15036b-bb2b-48b8-980a-498dcfe8bd1d/images/7d3587c4-8bf4-4cee-b3f5-1bb7b9e12f48.jpeg)\ - When you utilise a drop-down list to limit the entries users can make in a cell, data entry is faster and more accurate. When a cell is selected, the down-arrow of the drop-down list displays, and the user can click it to make a selection. - **Make a drop-down menu.** - Drop-down lists can help you make a worksheet more efficient. Someone who is using your worksheet clicks an arrow, then a list entry. - Choose the cells in which you want the lists to appear. - Select **DATA > Data Validation** from the [**ribbon**](https://answers.mindstick.com/qa/96529/what-is-the-use-of-comment-how-to-add-comments-to-a-cell-in-excel). - **Set Allow** to List in the dialogue. - Click on Source, type the text or numbers you want in your drop-down list (separated by commas for a comma-delimited list), and then **click OK.** \ **Read More: [What is ribbon, and where does it appear in excel?](https://answers.mindstick.com/qa/96517/what-is-ribbon-and-where-does-it-appear-in-excel)** --- Original Source: https://answers.mindstick.com/qa/96518/how-do-you-create-dropdown-lists-in-excel Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.