How to create messages in excel-Part1

Many times even we have secured our excel by creating drop down to restrict users entering wrong information,we need to provide the message to users so that we can tell what needs to be done so that users landed up into trouble.


We all know messages are important and help users to explain the task easily.

Check the below excel here we have 2 columns and data in column B can be Yes or No as per the values available in drop down,

Note: You can check here how to create drop down values in excel

http://saxenablogs.blogspot.com/2010/05/data-validation-in-excel-how-to-create.html

Now to create the Message as an error proceed below

Step 1 Click on Data Validation tab and choose Data Validation

Step 2 Click on the Error Alert Tab as shown

Step 3 Choose style as Stop

Step 4 Now enter Title and Error Message

Step 5 Press Ok button above and now you will return to the same initial screen

For e.g if I goto link 6 as above and try to make any change or right in it instead of selecting any value from Drop down option I get the following message.

Thus the above steps will help you to configure your sheet in such way that users can provide or fill wrong data and also the message will guide them how/what to fill.