As we all know Microsoft Excel is used to collect data in rows and columns. Sometimes, we want to restrict to only certain data to be in the sheet. We want to throw an error, when someone is trying to enter data against the validation. For example, if you want to set the restriction in such way that, a particular cell in Excel should only accept text of 10 characters in length, then you can specify the validation for that cell in Excel easily.
Add Error Messages in Excel
Whenever anyone enters text beyond the restriction, you can show the error message explaining the validation. In this article I will let you know how to create or add error messages in Excel.
First, select the cell (E6 in our example) which you want to set the restriction. Click on the Data tab and under Data Tools section, click Data Validation.