Create Multiple Select Dropdown for entire column

Question

I have to create a dropdown list with items that can be updated at any point. I want to be able to go from row to row in the same column and select different drop options if needed. I have made the drop down list and implemented it, but for the whole column I do not know how to get the selections to continue onto the whole workbook if I needed to go from 1-500.

Answer 1

Am I correct in my interpretation that you want the same DropDown on every row. If so, then select and Copy the one DropDown cell that you have created and then select the remaining cells where you require the dropdown and right click and select Paste Special, then select Validation option and then OK.

If I have mis-interpreted your question then please provide more info like examples of what you require.

Answer 2

Hi @Eric Selvey ,

Could you please explain more about the "Multiple Select Dropdown"?
Besides, to help us understand your needs better, it's best to share us a simple sample and the results that you need.

Please check whether the following is helpful to you.

• Create a Name.
  We can use Offset formula to get dynamic data source. On my sample, the formula for the name "Fruit" is =OFFSET(Sheet1!$A$1,1,,COUNTA(Sheet1!$A:$A)-1).
  
• Insert a drop down list.
  
• Then if you add the data in that column, the data in list will be updated automatically.
  

Any misunderstandings, you can feel free to let us know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 3

My question on "Multiple Select Dropdown" is different. See the picture below.

How could I do this with Excel? Even if it is not possible to do it with a dropdown, how could I make possible to accept several options within one cell? There must be a way to do this.