Home > DeveloperSection > Articles > Dropdown Control in Excel

Dropdown Control in Excel


Excel Excel 
Ratings:
0 Comment(s)
 2266  View(s)
Rate this:

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 that you want. To create a drop-down list from a range of cells, use the Data Validation command in the Data Tools group on the Data tab.

Steps are given below

Step 1: Open your excel sheet. Select excel sheet where you define drop down list e.g. If your main sheet is 1 then open sheet 2. On this page insert drop down list item as below image.

Dropdown Control in Excel

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

 

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

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

Step 5: Check dropdown menu on your main page as below image.

Dropdown Control in Excel

Step 6: Follow same steps for including dropdown for Language column and see output as below image.

Dropdown Control in Excel


Don't want to miss updates? Please click the below button!

Follow MindStick