How to add Error Messages in Microsoft Excel

As nosotros all know Microsoft Excel is used to collect information inwards rows in addition to columns. Sometimes, nosotros desire to confine to exclusively for certain information to move inwards the sheet. We desire to throw an error, when individual is trying to motion into information against the validation. For example, if you lot desire to laid upward the restriction inwards such agency that, a detail jail cellular telephone inwards Excel should exclusively bring text of 10 characters inwards length, in addition to then you lot tin attain notice specify the validation for that jail cellular telephone inwards Excel easily.

Add Error Messages inwards Excel

Whenever anyone enters text beyond the restriction, you lot tin attain notice present the mistake message explaining the validation. In this article I volition allow you lot know how to practice or add together mistake messages inwards Excel.

First, pick out the jail cellular telephone (E6 in our example) which you lot desire to laid upward the restriction. Click on the Data tab in addition to nether Data Tools section, click Data Validation.

In Data Validation dialog box, click on Settings tab. In the Allow drop-down, you lot tin attain notice specify what information is allowed inwards the cell. It tin attain notice move a whole number, Date, Decimal or fifty-fifty custom formula tin attain notice move added.

In our case, every bit nosotros require to laid upward the restriction for to a greater extent than than 10 characters, pick out Text Length. If you lot practice non desire to throw an mistake for empty cell, in addition to then banking concern jibe Ignore blank check-box.

Now, inwards Data drop-down, pick out the operator. In our case, I selected between.

As nosotros induce got chosen ‘between’, nosotros require to specify Minimum in addition to Maximum range. We tin attain notice either pick out the jail cellular telephone attain or motion into the values directly. For our case, motion into ‘1’ inwards Minimum in addition to ‘10’ inwards Maximum.

Now, click on the Input Message tab. This tab is used to specify the message to move shown when the jail cellular telephone is selected in addition to for that banking concern jibe Show input message when jail cellular telephone is selected. Specify the Title and Message to move shown when the jail cellular telephone is selected. Title is shown inwards bold in addition to the message is shown every bit normal text below the title.

Now, it is the fourth dimension to practice the Error Message inwards Excel. Click on Error Alert tab. Check the alternative “Show mistake warning afterwards invalid information is entered” to avoid mistake message beingness shown for every information entered inwards the cell.

Recommended: Microsoft Excel Tips to Save Time in addition to Work Faster

In Style dropdown, pick out the mistake type to move shown. It tin attain notice move Stop, Warning or Information. Enter the Title in addition to Error Message to move shown inwards the mistake popular up. Click “OK” in addition to your validation has been laid upward for the selected jail cellular telephone inwards Excel.

When you lot motion into the text which has less than 10 characters, in addition to then no mistake message is shown. But, when you lot motion into the text to a greater extent than than 10 characters beyond our restriction, in addition to then mistake message is shown every bit below.

You could come across that the championship in addition to message you lot laid upward is shown inwards the mistake message. It is suggested to induce got the meaningful championship in addition to message which explains the validation in addition to restriction.

This is the easiest agency to practice mistake messages inwards Excel.

Source: https://www.thewindowsclub.com/

Share This :