To avoid entering incorrect product codes, account names, surnames…
To limit options to a pre-populated list try creating a Data Validation List using Excel.
- Type a list of States
- Select the cell/s to apply the list to
- Data Tab, Data tools group
- Select Data Validation
- In the Allow field
- Choose List form the drop down arrow
- In the Source Field
- Select the range of cells with the States
- You know have a drop down arrow to select a state for your data entry.