00:00In order to go ahead and show these as a drop-down menu items, you need to go around over here onto the destination sheet and then go around onto the cell where you want to display that drop-down list.
00:13Then you need to go around onto data and then you need to go to data validation right here.
00:19So once you do that over here in the allow section, you need to go ahead and choose list and over here in source, you need to go around onto that list and select that list just like this.
00:31Press enter and then press ok, then you got the drop-down list just like this.
00:36You can go ahead and press ctrl c and select out other cells, press ctrl v to go ahead and replicate those drop-down menus in the other cells just like this as well.
