How to check data entered in a cell in Excel

The following article details how to Check data entered into a cell in Excel.

For example, want to check that the data entered in the birth year column has a value between 1993 and 1999.

How to check data entered in a cell in Excel Picture 1

Step 1: Highlight the cell to check the data entered -> DATA -> Data Tools -> Data Validation -> Data Validation .

How to check data entered in a cell in Excel Picture 2

Step 2: The dialog box appears on the Settings tab in the Allow section, click Whole number .

How to check data entered in a cell in Excel Picture 3

Step 3: After selecting the Whole number and the Minimum and maximum properties displayed -> enter the value of the minimum year of birth in the Minimum field and the maximum year of birth in the section Maximum -> OK .

How to check data entered in a cell in Excel Picture 4

Step 4: Switch to the Input Message tab in the Title field, enter a title for the notification, in the Input Message field enter the content of the message -> click OK .

How to check data entered in a cell in Excel Picture 5

Now when you move the mouse towards the cell to enter the year of birth, the message displays:

How to check data entered in a cell in Excel Picture 6

When you enter the year of birth data outside the range of 1993 to 1999 display the error message -> click Cancel to re-enter the data.

How to check data entered in a cell in Excel Picture 7

Above is how to check data entered in Excel cell.

Good luck!