How to Create Messages in Excel –Part 3

How to create messages in excel –Part 3

In the previous article we have learnt how to create a Error/Warning message in the excel (Create Messages in Excel Part 2)but sometimes we need to give Information only to the users.

Sample Scenario

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 Information

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 with above steps you can configure excel to give you a Information pop up to user,the only difference between ERROR and Information message is that in ERROR message user can’t fill any value but with above option user can fill other value and continue.

This option is valid for cases where you want to guide users to fill the right option from drop down and not to enforce them for choosing only same set of values.

How to Create Messages in Excel-Part 2

How to create messages in excel-Part 2

 

In the previous article we have learnt how to create a Error message in the excel (Create Message Part 1)but sometimes we need to give Warning to the users.

Sample Scenario

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(Create Dropdown Values in Excel) how to create drop down values in excel



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 Warning

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 with above steps you can configure excel to give you a Warning pop up to user,the only difference between ERROR and WARNING message is that in ERROR message user can’t fill any value but with above option user can fill other value and continue.

This option is valid for cases where you are not sure of all the values in advance or at the time of creating excel so can choose this option.

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.

Data Validation in Excel : - How to create a drop down in Microsoft Excel

In todays world excel became a very good source of information and almost used extensively by managers,IT Professionals etc.

All  this data store in excel can be wrong or this information can lead to wrong decision too ?

Surprised check the below Excel

Yes even though you have maintained the above data where person is interested to know how many Customers are satisfied with only knowing Yes or No answer but still there is a difference wrong data is filled by certain customer as shown above.

This lead to Question

How you can be sure that everything is correct.To optimize the data storage in excel we can create Drop Down list.

With the help of this list the chances are NILL for entering wrong data in it.

For e.g

For our above scenario in same excel in the Column B; I just want Yes or No answer;

Without drop down a user can enter whatever he want,so we create a drop down as shown below

Step 1:

Click on column B ,

Step 2

Then goto Data tab now,click on Data Validation

Step 3:

menu choose the “List” option in the Allow as shown,Source box enter values “Yes” and “No” as shown below;

Thus now you have a drop down created in excel with values required for us and user’s can’t enter any other garbage or unwanted value in it as shown below,

Also the same values appear in first or Label column to remove the same proceed as below;

Step 4
Select the Label column

Step 5

Click on data validation again and following pop up will come;

Step 6
Now make the changes as below

Press ok button.

Step 7
Now you can see the LABEL doesn’t have a drop down as expected

Thus above steps will help to customize or guided you to have your own Drop Down list.

Now want to do more click here Create Messages in Excelto learn how to create messages as warning,information or error in Excel.