Excell spread sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1292913%22%20slang%3D%22en-US%22%3EExcell%20spread%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1292913%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20create%20drop%20down%20tabs%20on%20a%20sheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1292913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1292944%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20spread%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1292944%22%20slang%3D%22en-US%22%3ESelect%20a%20cell%20to%20house%20the%20dropdown%20i.e%20cell%20D1.%20%3CBR%20%2F%3E%3CBR%20%2F%3EGoto%20Data%20tab%20%26gt%3B%20Data%20Validation%20%26gt%3B%20In%20the%20settings%20dropdown%2C%20select%20List%20%26gt%3B%20In%20the%20source%2C%20select%20your%20data%20i.e%20%24A%241%3A%24A%2420.%20Click%20OK%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20video%20link%20below%20explains%20the%20steps%20given%20above%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DxCe_XRkQW1Q%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DxCe_XRkQW1Q%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

How to create drop down tabs on a sheet

1 Reply
Highlighted
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