headermask image

Business Tools Blog

Create a drop down selection list in Excel

Photobucket

A question from Chris Murphy:

Could you please show me how to set up excel with drop down choice’s per cell?

Absolutely - here are step by step instructions on how to create an excel drop down list.

Step 1 - Type the list that you want to appear in the drop down  (I usually do this in Column A, ~row 500)

Photobucket

Step 2 -

  • Put your mouse in the cell where you would like the drop down to appear
  • Go to the menu and select Data, then Validation

Photobucket

Step 3 - On the Data Validation Menu, Select List 

  Photobucket

Step 4 -  On the Data Validation Menu, Select Source

 Photobucket

Step 5 - Highlight the list that you typed in Step 1, and click the select range key

 
Photobucket

Step 6 - click OK

Photobucket 

Now you have a drop down that looks like this:

Photobucket 

I hope this works for you, let me know if you have any questions. - Sandi

 

If you liked my post, feel free to subscribe to my rss feeds

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*