Excel Data Validation Go To Same

Occasionally, even if a several cells contain the same data validation settings, you'll get a warning if you try to change the data validation in those cells

Problem reported in excel.misc newsgroup, by Kate, 2005-Mar-10.

View the Error Message

Download the zipped sample file

  1. Select a cell that contains data validation
  2. Choose Edit | Go to
  3. Select Data Validation, and select Same
  4. Click OK
  5. With the "Same" cells still selected, choose Data | Validation
  6. An error message appears:
    " The selection contains more than one type of validation.
       Erase current settings and continue?"

data validation error message

Note: If you copy the group of cells to a different worksheet, the error message doesn't appear.

More Data Validation Links

Data Validation Basics

Create Dependent Lists

Use List from Other Workbook

Criteria Examples

Data Validation Tips

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra




Get weekly Excel tips from Debra


Last updated: April 21, 2021 3:22 PM
Contextures RSS Feed