You need to guide users on what to enter in a specific cell. An input message is a small pop-up tooltip that appears when a cell is selected. This feature is part of Excel’s Data Validation toolset. This article explains how to set up these helpful messages to prevent data entry errors.
Key Takeaways: Adding Input Messages in Excel
- Data > Data Validation > Input Message tab: Creates a pop-up tooltip that appears when a user selects a specific cell.
- Title and Input Message fields: Control the bold header and the descriptive text shown in the tooltip.
- Clear All button: Removes both the input message and any data validation rules from the selected cells.
What Are Data Validation Input Messages?
Data validation in Excel controls what data can be entered into a cell. The input message is one component of this system. It provides guidance without restricting the actual input. The message appears as a yellow tooltip next to the cell as soon as a user clicks on it.
This feature is separate from an error alert. An error alert only shows up after a user tries to enter invalid data. An input message shows up before any typing begins. It is purely informational and does not block any entries. You need to select at least one cell before you can apply the message.
Steps to Add an Input Message Tooltip
- Select your target cell or range
Click on the cell where you want the tooltip to appear. To apply it to multiple cells, click and drag to select a range. - Open the Data Validation dialog
Go to the Data tab on the ribbon. In the Data Tools group, click the Data Validation button. - Navigate to the Input Message tab
In the Data Validation dialog box, click the second tab labeled Input Message. - Enable the message and add your text
Ensure the box for ‘Show input message when cell is selected’ is checked. In the Title field, type a brief header for your tooltip. In the Input message field, type the full instructions or description for the user. - Apply the settings
Click the OK button to save and apply the input message to your selected cell or range.
Testing and Editing an Existing Input Message
- Select the cell with the message
Click on the cell where you applied the tooltip. The yellow message box should appear immediately. - Open Data Validation to edit
With the cell still selected, go back to Data > Data Validation. The Input Message tab will show your current text. - Modify the text or settings
Change the text in the Title or Input message fields. To remove the tooltip, uncheck the ‘Show input message’ box and click OK.
Common Mistakes and Limitations to Avoid
Input Message Does Not Appear When Cell Is Selected
This usually happens if the ‘Show input message when cell is selected’ checkbox was accidentally left unchecked. Reopen the Data Validation dialog and verify the box is checked on the Input Message tab. Also, ensure worksheet protection is not enabled, as it can hide these messages.
Tooltip Appears for the Wrong Cell or Range
This occurs if the wrong cells were selected when the rule was applied. Clear the message from the incorrect cells by selecting them, opening Data Validation, and clicking Clear All. Then, carefully re-select the correct cell range and create the input message again.
Confusing Input Messages with Error Alerts or Comments
Input messages are temporary tooltips. Excel Comments or Notes are persistent markers indicated by a red triangle. Error Alerts only trigger after bad data is entered. Use input messages for entry instructions, comments for reviewer notes, and error alerts for enforcing rules.
Data Validation Input Message vs. Cell Comment
| Item | Input Message (Data Validation) | Cell Comment (Note) |
|---|---|---|
| Primary purpose | Provide data entry instructions | Add review notes or explanations |
| When it appears | Automatically when cell is selected | On mouse hover or when manually opened |
| Visual indicator | No persistent marker on the cell | Small red triangle in cell corner |
| Persistence | Disappears when cell is not selected | Remains until manually deleted |
| Management location | Data > Data Validation dialog | Right-click menu or Review tab |
You can now add clear guidance directly into your worksheet cells. Use input messages to explain expected date formats or acceptable value ranges. For more control, combine them with a Data Validation rule on the Settings tab to restrict input. Remember that pressing F2 to edit a cell will also make the input message appear.