If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...

These new Excel features for working with text and lists will save you time ... you can create a dropdown list in Excel by choosing Data, Data Validation and choosing List in the Allow box on ...

Use Excel data validation to prevent duplicate ... making sure to use straight (not curly quotes). If you’re working with your own data, be sure to update the name of the Table and column.