How to use validation to filter out Excel-specified data

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.