How Excel sets the data error warning

Source: Internet
Author: User
Tags date now

How does Excel set data error warnings? The validity of cell data in Excel tables is a very useful feature, and setting data validation can reduce the error of entering data. Limit the length of data (such as cell phone number), between a certain number (such as height), require a certain format (such as date), can only be fixed into a few options (such as gender, education) need to use data validation.


Data > Data validation, you can find this feature.

Data validation settings for sex

Select a column of sex, I hope this can only be fixed into the "male" or "female", the following figure to fill out the content. The source where "," must be in English state input.

Go to the Error alert and enter the following.

When you are done, you can see options selected.

When the input error, the stop warning will pop up, as long as the input is not correct will pop up, not allowed to fill in the error message.

Enter information

Look at the use of input information, such as the following to fill out, OK. Find a reminder when you click on a cell.

There are three styles of error warning

Stop, warning, information.

Stop and do not allow incorrect information to be entered.

Warning, allows you to choose whether to continue to enter the wrong information, choose No, you can not enter the error message.

Information, just reminders will not not allow you to enter.

Tips for entering the same content for multiple cells

When you select multiple cells, enter text in a cell, and then press Ctrl+enter to enter all the selected cells.

Data validation settings for date of birth

Data for the date of birth is a date and must be less than the current date now (), and then set an error warning.

Data validation settings for the ID number

The number of digits of the ID number is fixed to 18 digits, the text length is equal to 18.

Error warning set itself.

Data validation settings for height/cm

Height is an integer, and the normal height has a range, such as the next set.

Error warning set itself. It is recommended to use input information to remind you that the height unit is cm.

Attention matters

If there is a mistake, please verify that the comma, double quotes are not entered in the English state.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.