Tom’s Tutorials For Excel: Commenting a Cell With Data Validation
As a practical alternative to using a comment for supplying information about a cell, consider using Data Validation instead. The advantage is, the user sees the popup message for directions or tips when they select the cell as they enter or edit data.
In the pictured sequence for example, select the range of cells that you want to supply a popup message for when a cell in that range is selected. Then, from your keyboard press
Alt+D+L to show the Data Validation dialog box.
• Click the Input Message tab.
• Check “Show input message when cell is selected”
• Enter a short title for the main idea of the cell entry.
• Enter a brief tip for the entry of data in that cell.
• Click OK.
You can see the result of the pictured settings below, when a cell in that range is selected.
Leave a Reply