How to Check Data Entered in a Cell in Excel

This guide explains how to check Data Entered in a Cell in Excel, with clear steps, practical tips, and important checks before you begin.

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

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

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

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 .

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 .

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

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.

Above is how to check data entered in Excel cell.

Good luck!