Home > Validation > Rules > Go to Same

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.

data validation error message

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



About Debra


Last updated: April 2, 2023 11:18 AM