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.
View the Error Message
Download the zipped sample file
- Select a cell that contains data validation
- Choose Edit | Go to
- Select Data Validation, and select Same
- Click OK
- With the "Same" cells still selected, choose Data | Validation
- An error message appears:
" The selection contains more than one type of validation.
Erase current settings and continue?"
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
Data Validation Tips
Last updated: April 2, 2023 11:18 AM