1/11/16

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.

26 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
  3. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. advanced analytics

    ReplyDelete
  4. Your article has piqued a lot of positive interest.I can see why since you have done such a good job of making it interesting. wireless gaming keyboard

    ReplyDelete
  5. Different massage styles work in different ways and prove more beneficial to specific problems or symptoms. portable massage chair

    ReplyDelete
  6. I really like your article. It’s evident that you have a lot knowledge on this topic. Your points are well made and relatable. Thanks for writing engaging and interesting material. quickbooks data entry outsource

    ReplyDelete
  7. Very good Article, We are a major believer throughout putting up responses in internet sites for you to let the web site freelance writers be aware that they̢۪ve included a thing helpful for you to virtual reality!offline data entry in india

    ReplyDelete
  8. Great content material and great layout. Your website deserves all of the positive feedback it’s been getting. call center data entry

    ReplyDelete
  9. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. bookkeeper data entry

    ReplyDelete
  10. I'm impressed, I must say. Very rarely do I come across a blog thats both informative and entertaining, and let me tell you, you ve hit the nail on the head. Your blog is important.. bookkeeping data entry

    ReplyDelete
  11. By outsourcing the services you provide to India, you can enjoy the advantage of saving up to 70% cost incurred on business operations. Data entry will be the hub of the business despite the fact that it may well appear to be simple to manage and handle, this requires many processes that should be dealt systematically data entry bookkeeper

    ReplyDelete
  12. By outsourcing the services you provide to India, you can enjoy the advantage of saving up to 70% cost incurred on business operations. Data entry will be the hub of the business despite the fact that it may well appear to be simple to manage and handle, this requires many processes that should be dealt systematically data entry bookkeeper

    ReplyDelete
  13. being a blogger myself . i can see someone with great potential”    image typing data entry

    ReplyDelete
  14. It appears everybody needs to do them. Indeed, I did a verify how frequently individuals composed in the expression, 'data entry' (with Suggestion's Watchword Selector Device) and found that last month there were 38,490 looks for Data Entry; and that is not including all the quests on Google, MSN or any of the many other web crawlers on the Web!data entry virtual assistant

    ReplyDelete
  15. {Another {reason why|reason|reasons why|good reason that} {people don't|individuals don't|folks don't|people do not} {go for|choose|select|opt for} online {home based|work from home|home-based|work at home} data entry jobs {is that they|is they|is because they|is because} don't {receive the|get the|have the|obtain the} actual money {which is|that is|which can be|that's} paid {by the|through the|from the|with the} employer|Such services {includes a|features a|carries a|incorporates a} {wide range of|number of|great deal of|massive amount} back office and BPO - Business Process Outsourcing and ITO - Information Technology Outsourcing enabled {data processing|information systems|computer} services|Outsourcing data entry {is a good|is a great|is an excellent|is a superb} plan {unless you|if you don't|until you|if you do not} {figure out|determine|find out|discover} {the best|the very best|the most effective|the top} {in that|for the reason that|because|in this} business and delegate them tasks {that are|which are|which can be|which might be} quite {feasible to|possible to|possible} undertake with due respect {to the|towards the|for the|on the} time frame| Finding the right person {for the job|to do the job|for the position|for the task} {is a|is really a|can be a|is often a} task {in itself|by itself|alone|itself} {and is also|and it is|and is particularly|which is} expensive| Companies can avoid such task by outsourcing their requirements to reputed entry company| It involves PDF conversion, XML conversion, Document conversion; Document digitizing, RTF Conversion and RTF conversion}. { There {is a|is really a|can be a|is often a} delicate balance between {using a|utilizing a|employing a|by using a} keyword {too little|not enough|inadequate|weak hands} and {using a|utilizing a|employing a|by using a} {keyword phrase|keyword|search term|search phrase} too much| You must {choose the|pick the|select the|find the} data entry services form reputed outsourcing company {to get|to obtain|to have|to acquire} secure, accurate {and on|as well as on|and also on|and so on} time entry service at feasible cost| Additional {benefit of|advantage of|good thing about|benefit for} outsourcing is saving cost on resources {which could|that could|which may|that may} be {invested in|committed to|dedicated to|purchased} widening {the business|the company|the business enterprise|the organization} activity| Minding confidentiality and integrity {of data|of information|of knowledge|of internet data} {might seem|may appear|may seem|might appear} {as a|like a|being a|as being a} trivial issue {at first|in the beginning { It may includes data-entry into websites, tracking debit or {credit card|charge card|bank card|plastic card} transactions, entry into electronic have been|there was|there are} no online payment processors| Businesses keep their favored {service providers|providers|companies|agencies} by sending over {hundreds of|countless|a huge selection of|numerous} bulk projects {that are|which are|which can be|which might be} {to be|to become|being|to get} done minding {the time|time|enough time|some time} and budget constraints|- Don't be put off {by a|with a|by way of a|by the} {lack of|insufficient|not enough|deficiency of} testimonials - Just because a company {doesn't have|does not have|doesn't always have|doesn't need} testimonials {doesn't mean|does not mean|does not imply|doesn't suggest} {they aren't|they are not|they're not|they may not be} {a good|a great|an excellent|a fantastic} company}. invoice data entry

    ReplyDelete
  16. I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. https://massage-marvels-100.myshopify.com/

    ReplyDelete
  17. Click Bank data entry jobs are usually e-Books or data entry vendors other materials that tell you how you can make money using AdWords and selling affiliate links to Click Bank products.

    ReplyDelete
  18. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. for more info

    ReplyDelete
  19. Its in the same way an excellent write-up that i unquestionably appreciated studying. It's actually not essentially day-to-day that i grow a chance to uncover nearly anything. payroll data entry

    ReplyDelete
  20. Personally I think overjoyed I discovered the blogs. reception data entry

    ReplyDelete
  21. Much thanks for sharing such a valuable article. Will spared and return to your site data entry crm

    ReplyDelete
  22. I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. baixar whatsapp gb versão mais recente

    ReplyDelete
  23. 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... how to start a payment gateway company

    ReplyDelete
  24. So lot to occur over your amazing blog. Your blog procures me a fantastic transaction of enjoyable.. Salubrious lot beside the scene. email spider

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.