A Neater Way to Show Users Comments or Spreadsheet Instructions

When I wanted to show instructions to users on spreadsheets I used to use Excel cell comments or write something in another cell on the sheet. Comments leave unwanted little red triangles everywhere and instructions dotted around on a sheet may just mess with your fine tuned formatting. Also, Normal Excel comments only appear when you hover your mouse pointer over them. What if you want the comment to appear when a user selects a particular cell.

This alternative uses the Data Validation option. Watch this video for a quick demonstration or read on for details…

 

How to add Data Validation comments

Excel_Data_Validation_Comments_2

Select the cell you would like an instruction to pop up on (once selected)

Excel_Data_Validation_Comments_3

In the Data Tab, select the Data Validation option from the Data Tools section. Navigate to the Input Message tab and type your instruction into the Input Message: box (highlighted below in blue)

Excel_Data_Validation_Comments_4

Now when you select that cell, your message will appear and you wont have an ugly little red triangle getting in your face!

Excel_Data_Validation_Comments_5

You can obviously combine messaging with other data validation options like drop down boxes etc. Those will be covered in a future post.

No ratings yet.

Please rate this