How to query invalid data with one click in Excel

1. Open the Excel table and enter some data.

2. After selecting the data to be filtered, click [Data] [Data Validity] in sequence.

#3. Enter the verification conditions in the dialog box. Take the number below 450 as an example; (Note: The verification conditions should be contrary to the data you are looking for).

#4. Finally, select [Circle Invalid Data].

The above is the detailed content of How to query invalid data with one click in Excel. For more information, please follow other related articles on the PHP Chinese website!