Data Validation is a feature which is used to avoid an entry of invalid data.
Data Validation
Select Data > Go to Data Validation
![](https://microcomputercenter.in/wp-content/uploads/2023/12/image1.png)
Settings Tab
Click on the Settings Tab >Allow > Select any option
![](https://microcomputercenter.in/wp-content/uploads/2023/12/image2.png)
Input Message
Input Message Tab > Customize Message
![](https://microcomputercenter.in/wp-content/uploads/2023/12/image3-1024x576.png)
Error Alert
Enter an invalid Data > Error Alert appears
![](https://microcomputercenter.in/wp-content/uploads/2023/12/image4.png)
![](https://microcomputercenter.in/wp-content/uploads/2023/12/image5.png)