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.
Mark fields that that you want to be shown as drop-down options and hit small button on the side (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).
I hope that this tutorial was informative to you and thank for visiting this website.