Using Data Validation to Add an Input Message

In Excel, you have the ability to add comments to a cell. After it’s created, you can mouse over the cell to see the comment, or set it to show. You can even choose to have it print.

This is an alternate method to comment. Once created, you will only see it if you select the cell. It’s normally used to offer the user guidance on input to a cell, but can also be used for comments. To me, it’s cleaner looking than the normal comment method.

To create, select the cell you want the message in, then click the Data Validation button under the Data Tools ribbon.

Under the Input Message tab, create the Title, and the Input Message.

Once created, select the cell to test…

You’re done!