Using the Validation Input Message as a Cell Comment in Microsoft Excel

The Data Validation is used for making the data error free. It is a technique in Microsoft Excel by which we can control the input by providing the drop down list to users.

What is the use of Input Message?

Input messages are generally used for giving direction to others, which type of input you can insertinto a cell. This message is shown near the cell if you want to move this pop up you can move it to another cell.

To understand: Using the validation “Input Message” as cell comment

  • Select the cell C3, Go To “Data” tab in the ribbon, click on “Data Validation” from the “Data Tools” group.

img1

  • Select “Data Validation” from the drop down list.
  • A data Validation dialog box will appear.

img2

  • In “Settings” tab select “List” from the “Allow”drop down list,Source tab will get active select the range A2:A13.

img3

  • Go to “Input Message” tab, in “Input Message Box” type “Enter only the month name”, the message box will appear near to the cell.

img4

img5

  • Go to “Error Alert” tab and write the message in the box of “Error Message” Input Error and click on ok
  • If you will enter the number instead of month name the pop up will get to appear and give the message what you had entered in “Error Message” box.

img6

This is the way, you can create input message as a cell comment. If user will enterin the range apart of month name, he will get the input message and would be able to enter the correct input in the range in Microsoft Excel 2010 and 2013.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube