As everyone knows, Microsoft Excel is used to acquire information in rows and columns. Typically, we wish to limit to solely sure information to be in the sheet. We would like to throw an error, when somebody tries to enter information in opposition to the validation. For instance, if you would like to set the restriction in such a method that, a specific cell in Excel ought to solely settle for textual content of 10 characters in size, then you may specify the validation for that cell in Excel simply.
How to add Error Messages in Excel
Each time anybody enters textual content past the restriction, you may present the error message explaining the validation. On this article I’ll let you understand how to create or add error messages in Excel.
First, choose the cell (E6 in our instance) which you need to set the restriction. Click on on the Knowledge tab and underneath Knowledge Instruments part, click on Knowledge Validation.
In Knowledge Validation dialog field, click on on Settings tab. Within the Permit drop-down, you may specify what information is allowed in the cell. It may be a complete quantity, Date, Decimal and even customized method could be added.
In our case, as we’d like to set the restriction for greater than 10 characters, choose Textual content Size. If you do not need to throw an error for empty cell, then examine Ignore clean check-box.
Now, in Knowledge drop-down, choose the operator. In our case, I chosen between.
As we now have chosen ‘between’, we’d like to specify Minimal and Most vary. We are able to both choose the cell vary or enter the values immediately. For our case, enter ‘1’ in Minimal and ‘10’ in Most.
Now, click on on the Enter Message tab. This tab is used to specify the message to be proven when the cell is chosen and for that examine Present enter message when cell is chosen. Specify the Title and Message to be proven when the cell is chosen. Title is proven in daring and the message is proven as regular textual content beneath the title.
Now, it’s the time to create the Error Message in Excel. Click on on Error Alert tab. Examine the choice “Show error alert after invalid data is entered” to keep away from error message being proven for each information entered in the cell.
Really useful: Microsoft Excel Suggestions to Save Time and Work Sooner
In Type dropdown, choose the error sort to be proven. It may be Cease, Warning or Info. Enter the Title and Error Message to be proven in the error pop up. Click on “OK” and your validation has been set for the chosen cell in Excel.
While you enter the textual content which has lower than 10 characters, then no error message is proven. However, while you enter the textual content greater than 10 characters past our restriction, then error message is proven as beneath.
You might see that the title and message you set is proven in the error message. It’s prompt to have a significant title and message which explains the validation and restriction.
That is the best method to create error messages in Excel.
Learn: How to insert Excel Spreadsheet in Phrase Doc.
