How to Circle All the Invalid Data in Excel at Once

It’s not surprising that there’s some invalid data in an large Excel spreadsheet. If you want to screen out all of them at once, the best idea is to set Data Validation in Excel, and then choose to Circle Invalid Data. Here’re the detailed steps: 1.Select the cells. 2.Go to Data tab. 3.Click Data Validation […]