How to create a drop-down list in Excel

Question

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 )

narikkadan · Answer 1 · Oct 9, 2022

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,600 points

Your comment on this question: