FreeKB - How to create a drop down selector in Excel
How to create a drop down selector in Excel

Home > Search > How-to

Follow these steps to create a drop-down selector in Excel. We will assume you are working in a new workbook.

  1. Add text to cells A1, A2, A3 and A4
    • A1 - boy
    • A2 - girl
    • A3 - mom
    • A4 - data
  2. Select cell B1
  3. In the top menu of excel, select Data
  4. Select Data Validation > Data Validation
  5. In the Data Validation dialog box, on the Settings tab, select List in the Allow drop-down selector
  6. Select the icon to the right of the sources field, and highlight cells A1 through A4 (you could also type =$A$1:$A$4 into the sources field)
  7. Select OK


Cell B1 should now contain a drop-down selector with the options in cells A1 through A4.

Add a Comment

We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.

Please enter d1b68 in the box below so that we can be sure you are a human.