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, 2022 in Others by Kithuzzz
• 38,020 points
666 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, 2022 by narikkadan
• 63,720 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, 2022 in Others by narikkadan
• 63,720 points
2,317 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, 2022 in Others by narikkadan
• 63,720 points
724 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, 2022 in Others by narikkadan
• 63,720 points
1,045 views
0 votes
1 answer

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,720 points
526 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,690 points
382 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, 2022 in Others by narikkadan
• 63,720 points
624 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, 2022 in Others by narikkadan
• 63,720 points
468 views
0 votes
1 answer

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 63,720 points
1,825 views
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, 2022 in Others by narikkadan
• 63,720 points
996 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, 2022 in Others by narikkadan
• 63,720 points
5,664 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