Application of Excel data validation

Source: Internet
Author: User

After the exam, the teacher might want to highlight the Excel form in the red circle, and the company may also want to highlight the special data in the statistics. Such requirements can be easily accomplished with Excel's data availability. Let me give an example of how to achieve this requirement with the result sheet. (Note: This example requires that the language score above 120 points in the red Circle highlighted.) )

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.

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.