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.
Next:
• 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.
San Francisco, California
1-925-310-4170
tom@atlaspm.com
Tom’s Tutorials For Excel: Commenting a Cell With Data Validation
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+Lto show the Data Validation dialog box.Next:
• 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.
Tags: Analytics, Big Data, Business Intelligence, Comments / Screen Tips, Data Science, Data validation, Excel Expert, Excel Guru, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis