Excell spread sheet

Copper Contributor

How to create drop down tabs on a sheet

1 Reply
Select a cell to house the dropdown i.e cell D1.

Goto Data tab > Data Validation > In the settings dropdown, select List > In the source, select your data i.e $A$1:$A$20. Click OK

The video link below explains the steps given above

https://m.youtube.com/watch?v=xCe_XRkQW1Q