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
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

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