Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow

Tags:circle invalid data

  • How to Circle All the Invalid Data in Excel at Once

    Date:2019-9-27 Author:Cordelia

    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 […]