Solve: This value doesn’t match the data validation restrictions defined for this cell

By | June 10, 2016

When you try to input some value in a cell and you get an error message in Excel 2016:

This value doesn' class=
image-2431

Excel 2016 – This value doesn’t match the data validation restrictions defined for this cell.

or in Excel 2013:

The value you entered is not valid. A user has restricted values that can be entered into this cell.
image-2432

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:

  1. 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.
    image-2433

    Excel – Data -> Data Validation – Narrow Size Window. Click to enlarge.

    Excel - Data -> Data Validation - Middle Size Window. Click to enlarge.
    image-2434

    Excel – Data -> Data Validation – Middle Size Window. Click to enlarge.

    Excel - Data -> Data Validation - Wide Size Window. Click to enlarge.
    image-2435

    Excel – Data -> Data Validation – Wide Size Window. Click to enlarge.


  2. 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.
    image-2436

    Excel – Data Validation Window – Settings – Criteria. Click to enlarge.

One thought on “Solve: This value doesn’t match the data validation restrictions defined for this cell

Leave a Reply

Your email address will not be published.