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 you fix this value doesnt 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 you match the Data Validation restrictions defined for this cell?
If you have data restrictions in place and a user enters invalid data into a cell, you can display a message that explains the error. Select the cells where you want to display your error message. On the Data tab, click Data Validation > Data Validation.
How do you fix a Data Validation error in Excel?
Resolve a data validation error by using error checking in Excel.
Start Excel, and select the Formulas tab..
In the Formula Auditing group, select Error Checking. ... .
For basic information about the error, see the text that describes the error in the Error Checking dialog box..
How do I override Data Validation restrictions in Excel?
Select the cells with the drop-down list. Click Data >Data Validation. On the Settings tab, click Clear All. Click OK.