---
title: "Dropdown Control in Excel"  
description: "In this article I’m going to describe, how to use dropdown control in excel."  
author: "AVADHESH PATEL"  
published: 2013-03-04  
updated: 2019-11-27  
canonical: https://www.mindstick.com/articles/1156/dropdown-control-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 2 minutes  

---

# Dropdown Control in Excel

In this article I’m going to describe, how to use dropdown control in excel.\

To make data entry easier in Excel, you can create a drop-down list. When you create a drop-down list for a cell, it displays an arrow in that cell. To enter information in that cell, click the arrow, and [select option](https://www.mindstick.com/forum/12881/select-option-generate-value-from-ajax-on-change) that you want. To create a drop-down list from a range of cells, use the [Data Validation](https://www.mindstick.com/forum/160109/how-to-handle-exceptions-caused-by-data-validation-errors-in-api-input-parameters) command in the [Data Tools](https://yourviews.mindstick.com/view/83849/top-big-data-tools-for-data-science-and-machine-learning-projects) group on the Data tab.

Steps are given below

Step 1: Open your [excel sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database). Select excel sheet where you define [drop down](https://www.mindstick.com/forum/287/how-to-add-data-in-drop-down-list) list e.g. [If your](https://yourviews.mindstick.com/view/83528/what-to-do-if-your-eye-glasses-don-t-fit) main sheet is 1 then open sheet 2. On this page insert drop [down list item](https://www.mindstick.com/forum/12843/how-to-force-user-to-select-drop-down-list-item-first-before-continue-next-in-c-sharp) as below image.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/7cd1d9a6-a895-4b27-b99b-0f7b9e28e101.png)

Step 2: Now, go to your main page and select cell where you put dropdown. If you put single dropdown then select single cell. For multiple dropdown select multiple cells as below image. First select cells then click on Data Validation option.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/6e8303c5-0950-4180-8d89-3ee433a1c2d7.png)

Step 3: When you select Data Validation option, one popup window will be appeared as below image. In opened window select list option then click within Source textbox.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/cee8ab4e-2a6d-4ec9-a303-511c5ef2e03a.png)

Step 4: After selecting Source textbox, go to excel sheet 2 and select list item as below image. After selecting list item press ok button for comeback your main page.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/2eb65553-43bd-4668-b53e-f3aca72a08c9.png)

Step 5: Check [dropdown menu](https://www.mindstick.com/blog/708/css3-animated-dropdown-menu) on your main page as below image.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/3137210f-8e79-4b85-8a21-b0885d02aff5.png)

Step 6: Follow same steps for including dropdown for [Language](https://yourviews.mindstick.com/view/81607/hindi-language-in-pakistan-is-getting-killed) column and see output as below image.

![Dropdown Control in Excel](https://www.mindstick.com/mindstickarticle/abfd302d-8612-4dea-953b-d337ab6da48b/images/2b45caa5-5c3f-4cc9-a3da-75988b7f0767.png)

---

Original Source: https://www.mindstick.com/articles/1156/dropdown-control-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.