How does Excel reduce errors in entering data? How to use Excel table data validity?

In the Excel table, we often need to manually enter some numbers. If you input for a long time, you will have visual fatigue. Even if you make a mistake, we will find it difficult to find out. For example, repeatedly enter the ID number, or exceed the invalid data such as characters. And reasonable use of data validation rules can avoid some operational errors, so how do we use Excel data validation rules? Watchmaking

Excel download powerful features to our work to bring the convenience, but errors can occur in the form of data entry process. Excel 2010's "Data Validity" feature limits the type and scope of data that is allowed to be entered.

For example: Computer scores are within 0-100. Do you have such an experience, you need to input a lot of data every day, but how can you reduce the error of entering data? Xiaobian teaches you a very practical trick today.

Set data validity —— Prevent data entry errors

1. Select the cell where you want to enter data.

2. Click on the data —— data validity.

3, in the validity condition, allow the selection of integers, data selection between, minimum and maximum values, you need to enter in the blank space of the table in advance, open the data validity and directly select the data minimum and maximum value.

4, select the error warning, enter "in the error message", please enter 0 to 100 data "ldquo;."

5, in the data area you want to enter, if the data you input is not within 0 to 100, an error message will pop up.

Set the data validity —— sequence to set the drop-down box options

1. Select the area you want to set.

2. Click on the data —— data validity, in the validity condition, allow (A) to select the sequence.

3. In the source (S), enter “ pass, do not pass & rdquo;.

Note: The comma must be a comma in English.

4. If the comma entered is not a comma in the English state, it will be displayed by not connecting together.

END

Excel data validation rules are designed to be flexible, and it takes years of Excel spreadsheet experience. The purpose of this article is to guide users and give them a chance to fish. Not giving people a fish.