link to the page
_______________
When you try to input some value in a cell and you get an error message in Excel 2016:
Excel 2016 - This value doesn't match the data validation restrictions defined for this cell.or in Excel 2013:
Excel 2013 - The value you entered is not valid. A
user has restricted values that can be entered into this cell.This means that someone has set Data Validation on that cell. To view its configuration and remove if needed follow these steps:
Select cell and go to Data -> Data Validation
Depending on the size of the window you access it in a bit different way.
Please look at the screenshots below:
Excel - Data -> Data Validation - Narrow Size Window. Click to enlarge.Excel - Data -> Data Validation - Middle Size Window. Click to enlarge.Excel - Data -> Data Validation - Wide Size Window.
Click to enlarge.
You will see Data Validation window. Look into Settings tab, Validation criteria section.
If you want to disable validation, select Any value in Allow drop down and accept by clicking OK.
Excel
- Data Validation Window - Settings - Criteria. Click to enlarge.
How do I match data validation in Excel?
Try it!.
Select the cell[s] you want to create a rule for..
Select Data >Data Validation..
On the Settings tab, under Allow, select an option: ... .
Under Data, select a condition..
Set the other required values based on what you chose for Allow and Data..
How do you fix the value doesn't match the data validation restrictions defined for this cell?
The value you entered is not valid..
Select the cell or cells that you want to remove validation from..
Click Data > Data Tools > Data Validation..
Click the Clear All button..
Click OK..
How do I unlock data validation restrictions in Excel?
How to remove data validation in Excel.
Select the cell[s] with data validation..
On the Data tab, click the Data Validation button..
On the Settings tab, click the Clear All button, and then click OK..