Can we make a dropdown list in Excel?

Asked By kate harry 10 points N/A Posted on - 03/08/2012

Is it possible to create a drop down list like in Ms.

Access in Excel?

• Status: Open
• Question Views: 1086
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Hoting Gracia

Go To Solution

Best Answer

Best Answer

Answered By Hoting Gracia 5 points N/A #91308

Can we make a dropdown list in Excel?

Hi, 

 

Kate hope the following steps will guide you in fixing this issue.

 

• Yes we can create the drop down in an excel sheet never think that we can't use in excel suppose consider a grocery store in which each item is noted for each and every purchase about the name and type of product.

 

• Drop down list in Excel works as if that it takes values from one place on excel sheet and uses them as a drop down list.

 

 

• Consider the above figure In cells from A1 to A7 you enter the type of product that will be used as in your drop down list.

 

 

 

 

• Drop down list creation is so easy and simple by selecting the cells from E2 to E9.

 

 

• Now Click on the Data menu and select Data Validation then select List from the given Allow drop down menu.

 

 

• Now click on the Source button that appears on the textfield.

 

• Select our source cells from A1 to A7.

 

 

• Now Click Enter and then Ok.

• This is the way of creating the drop down lists.

Thank you.

 

About Hoting Gracia

Questions
0

Answers
154

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 03/08/2012
• Question Category: MS Excel

Answered By theone1 0 points N/A #91310

Can we make a dropdown list in Excel?

Hi Kate Harry,

It is possible to create drop down in Ms excel.

You follow the following steps.

Go to data use validation command.

Write the data that you want to validate in a single column or row without separating.

Note you may sort the data the way you want them to appear in the drop down menu.

If you want to use different worksheet or workbook do the following:

Use different worksheet in the same workbook.

Type list of worksheets and define the name of the work sheet.

Use different workbook.

Type the list in that worksheet.

Define name with external with an external reference to the list.

Select the cell where you want drop down list.

On the data menu select validation and then click on settings tab.

About theone1

Questions
0

Answers
40

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel