Placeholder text to auto-populate in each cell row of the table

%3CLINGO-SUB%20id%3D%22lingo-sub-1720811%22%20slang%3D%22en-US%22%3EPlaceholder%20text%20to%20auto-populate%20in%20each%20cell%20row%20of%20the%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720811%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3EIn%20the%20state%20column%2C%20the%20user%20should%20enter%20only%20one%20of%20the%20values%20like%20KL%20or%20AP%20or%20TS%3C%2FDIV%3E%3CDIV%3EIn%20the%20Product%20column%2C%20the%26nbsp%3Buser%20should%20enter%20only%20one%20of%20the%20values%20out%20of%20MC%20or%20CV.%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1720811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1721204%22%20slang%3D%22en-US%22%3ERe%3A%20Placeholder%20text%20to%20auto-populate%20in%20each%20cell%20row%20of%20the%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811979%22%20target%3D%22_blank%22%3E%40kumshan450%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20workbook%2C%20rows%2024%20and%2025.%20Look%20into%20%22data%20validation%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
 

 

In the state column, the user should enter only one of the values like KL or AP or TS
In the Product column, the user should enter only one of the values out of MC or CV. 
1 Reply
Highlighted

@kumshan450 Perhaps like in the attached workbook, rows 24 and 25. Look into "data validation".