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!
You should read it
- How to Truncate Text in Excel
- How to name a cell or Excel data area
- How to name, comment and protect cells in Excel
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to limit the value entered by Data Validation Excel
- How to Compare Data in Excel
- Cell counting function with data in Excel - Enclose example
- Excel data entry faster
- How to create a newline in Excel 2020
- Hide the contents of any Cell in Excel
- How to combine 2 or more cells in Excel without losing data
- Calculate by cell background color in Excel
May be interested
SYD function - Calculate depreciation for an asset by remaining value in Excel
PRICE, PRICEDISC, PRICEMAT - Calculate the value of stock in Excel
IMSUM and IMSUB functions - Sum and complex differences in Excel
TBILLPRICE function - The function calculates the value of treasury bonds by the $ 100 face value in Excel
TBILLYIELD function - The function calculates the discount rate for a bond in treasury in Excel
VDB function - Calculate asset depreciation by the declining balance method in Excel