Monday, January 11, 2016

How to add input message, error alert, invalid data in data validation?


You all heard about data validation in excel. In this tutorial you will learn about How to add input message, error alert, invalid data in data validation?. It is a most important topic in Microsoft excel. Data validation is a feature of Microsoft excel. You can use to define restriction on what type of data can or should be entered in a cell. You can configure data validation to prevent user from entering invalid data. You can also provide short message to define what input you can expect for the cell, and you give instruction to help users correct any errors.

FOR EXAMPLE
Select the range of the data which you want to use data validation and go to data tab and you see data tools group in this group you see data validation option click drop down list and select data validation. Below image shows that where is data validation option?


When you done step 2 which is given above image you see data validation window front of this screen and you see drop down list click on it and select whole number and second drop down list click on it and select between, you see minimum and maximum option select the minimum and maximum number which you want see for example you select minimum number 33 and maximum number 99 and click ok. Below image shows that the above given following description.

When you done the following instruction then go to data validation option and click on this option and select circle invalid data. Below image shows that what happen when we select the circle invalid data. you see Microsoft excel highlighted invalid data in circle.



How to remove invalid data circle?

When you see invalid data and you want to clear invalid circle, go to data validation and click on it you see clear validation circle option click on it. Below image shows that how to remove invalid data circle?


How to add input message on data validation in excel?

When other user use your selected range data and you want to help you can add input message to help those person. Go to data validation option and click data validation and go to Input message and mark the check box (show input message, when cell is selected) and fill title and input message and click ok. When other users select the cell he saw a message and follow description which you give. Below image shows that how to add input message on data validation in excel?


How to add error alert when users enter invalid data?

You also show an error when users enter invalid data. Go to data validation option and select the error alert and click on it and mark the check box (show error alert when user enter invalid data) and go to style drop down list and select anyone which you want, then go to title and add title (Warning message, invalid data) and add error message and click ok. See below image


How to remove data validation in Microsoft excel?

you want to remove data validation in your spreadsheet. Go to data validation and click on it, data validation window open on the screen you see clear all option below on this window click on it and press ok to remove data validation in Microsoft excel. See Image as given below


How to create a drop down list in Microsoft excel?

In Microsoft excel you create a drop down list in various way. If you want to create a drop down list through data validation option click the data validation option, in data validation window go to setting and click on allow drop down list and select list, click on source option and select the range of name which you want to add in drop down list and click ok. See below image


In this article you have studied that how to add input message, error alert, invalid data in data validation? If you like this tutorial don't forget like us on Facebook and also follow on twitter. And if you find any missing then let me know through your comment.

3 comments:

  1. Thanks for sharing the post.. parents are worlds best person in each lives of individual..they need or must succeed to sustain needs of the family. Text Marketing Campaigns

    ReplyDelete
  2. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... Text Marketing Autoresponder

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.