Learn how to Circle Invalid Data in Excel. We also show you how to remove Invalid Data, and validate and approve the circled data.

Go to the Data Validation dialog menu in the same way as if you were deleting the menu options, but instead of deleting them all, simply delete only the ones you want to remove.

If you see the "This value doesn't match the data validation restrictions defined for this cell" error in Excel, this article will help you.

Use data validation Data validation is like setting the group rules for your Excel cells. It ensures that only the right kind of data gets in and eliminates any errors or typos.