How to use validation to filter out Excel-specified data

The following small series to take an example to explain in detail:

This example requires that the language score above 120 points be highlighted in the red circle. Screen operation steps:

The first step: open the results table → Choose the language results → Click the Data button on the menu bar → Select effectivity.

Step two: In the Data Validation dialog box, select "Integer" in the "Allow" → in the "Data" box, select "between" → minimum input 0→ maximum input 120→ OK.

Step three: Click the Tools button on the menu bar → select Formula auditing → Select Show the formula Auditing toolbar.

Fourth step: Click the "Circle Invalid Data" button.

So the Chinese score in 120 points above is circled in a red circle, played a prominent role.

But these loops can only be displayed on the computer and cannot be printed. Some teachers want to print it out, the author after exploring, to find a feasible way, the following introduction to this method.

Print operation steps:

The first step: Select the table → hold down the SHIFT key and click the Edit button on the menu bar → select Copy picture → OK.

Step Two: Click the "Edit" button on the menu bar → choose to paste the picture → delete the original datasheet → Adjust the location of the copied datasheet.

Note: You should always hold down the SHIFT key during the first and second steps, otherwise the operation will not succeed.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join