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

[kumshan450]

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. 

[#2]

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