How to limit the value entered by Data Validation Excel
Step 1:
In the Excel table, you want to set up the same data message, highlight the column to do, then click on the Data tab and select Data Validation , also click Data Validation .
How to create duplicate data entry notifications on Excel Picture 1
Step 2 :
The Data Validation dialog box appears, click the Settings tab, and then adjust the values as shown below.
How to create duplicate data entry notifications on Excel Picture 2
Step 3:
Switching to the Error Alert section also sets the settings as follows.
When finished setting, click OK to save.
How to create duplicate data entry notifications on Excel Picture 3
Step 4:
Go back to the area of the notification. When you enter the same data, the message will appear as shown below for us to know and check, re-enter the data correctly.
How to create duplicate data entry notifications on Excel Picture 4
Creating notifications when entering data in Excel with Data Validation will help users in managing the table content more easily. You will know immediately what content has problems to correct it in time.
See more:
I wish you all success!