Create drop down list in MS Excel cell

So many times i needed drop down list and it`s so easy to do it, yet I see so many MS Excel tables where people don`t use this. Basically it`s few clicks, but in different tabs. OK, you don`t have to do it in different tabs, but it`s more transparent.

I created table with some data and I will create drop-down under cell Data4 (Slide 1.).
Create drop down list in MS Excel cell

Slide1.

Take another tab and create data that will bi part of future drop-down. I did it with simple Yes and No (Slide 2.)
Create drop down list in MS Excel cell
Slide 2.

Go back to your data tab and mark cell/cells in which you want to insert drop-down and than pick Data – Data Validation – Data Validation option as I did in slide 3.
Create drop down list in MS Excel cell
Slide 3.

In dialog pick option List and hit small button on the right side of Source tab (Slide 4.). Then pickup
Create drop down list in MS Excel cell
Slide 4.

Mark fields that that you want to be shown as drop-down options and hit small button on the side (Slide 5).

Create drop down list in MS Excel cell

Slide 5.

It is ready now. In your cell/cells you should see drop-down list, as small arrow on the side of cell. You can now copy these settings to some other cells or just drag down or up for cells in same column or row (Slide 6).


Create drop down list in MS Excel cell

I hope that this tutorial was informative to you and thank for visiting this website.

Dejan Dzodan

Dejan Dzodan

IT professional for more then 15 years, mostly in financial institutions but with experience in ISP and retail. Proven in networking and overall infrastructure projects. Cisco instructor.

Leave a Reply

Your email address will not be published. Required fields are marked *


6 + 8 =