How To Add Drop Down List In Excel Teams. Your list will now be available for the entire column. Select the range of cells required as the source.
Select the range of cells required as the source. Now go to the cell where you want to create the drop down list and go to data > validation > allow > list and in the source box, tap the f3 key. The second excel drop down list will display the representatives in that region.