How to create a drop-down list in Excel

0 votes

I have a column of values in Excel, like this :

enter image description here

How can I make this a drop-down list so that it appears in each row of the column? (with dog, cat , fish, bat , toad. .. all inside )

Oct 9 in Others by Kithuzzz
• 20,660 points
65 views

1 answer to this question.

0 votes

Making a list of the items you want to appear in the drop-down, but anyplace in your spreadsheet, is the first step. For example:

enter image description here

Then the next step is to click the "Data Validation" button in the ribbon :

enter image description here

Ok, step 3 is to click "Settings" in the "Data Valid" menu, and choose "List" from the drop-down:

enter image description here

Step 4 is to click on that little blue icon in the "List" sub-menu :

enter image description here

The next step is to simply highlight the Cells you need. enter image description here

Finished now. Here is the dropdown :

enter image description here

answered Oct 9 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to create Dropdown list in excel using php

Try this: $objValidation = $objPHPExcel->getActiveSheet()->getCell('B'.$i)->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
148 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
26 views
0 votes
0 answers

How to create a batch file in windows?

What is a batch file and How ...READ MORE

Jul 4, 2019 in Others by sindhu
317 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
84 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
55 views
0 votes
1 answer

Can I use VBA in Excel 2010 Starter Edition?

No, unfortunately you can't use VBA in ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
72 views
0 votes
1 answer

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
262 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP