Add or Delete a Pop-Up Message Box in an Excel Cell

Updated 10 November 2026 · Standard formula, shown below

You can add a pop-up message to an Excel cell with Data Validation input messages, which appear when someone selects the cell; you can remove one by editing or clearing that validation message. If you mean a warning that appears only after an invalid entry, use the separate Data Validation error alert instead.

What a cell pop-up does

Excel’s Data Validation feature can display a short input message when a user selects a cell. It is useful for explaining what to enter without taking up space in the worksheet—for example, “Enter a date as day/month/year” or “Choose a value from 1 to 5.” The message is associated with the cell’s validation settings, not stored as cell text or as a traditional comment.

An input message is a prompt, not a restriction. By itself, it does not stop a user from entering an incorrect value. To limit entries, set validation criteria such as a date range, whole number, decimal, or list, and optionally configure an error alert. This distinction is important: a pop-up that explains a rule and a pop-up that blocks an invalid entry are related but different settings.

Add an input message to a cell

In the desktop versions of Excel, the usual route is through Data Validation. The ribbon labels can vary slightly between platforms and releases, but the feature is in the Data tab.

Select the cell or range where the message should appear.
Open the Data tab and choose Data Validation. In some layouts, Data Validation is inside a Data Tools group or available from a dropdown.
In the dialog, open the Input Message tab.
Turn on Show input message when cell is selected.
Enter a title and the message text, then choose OK.

For instance, select cell B2, set the title to “Quantity,” and use the message “Enter a whole number from 1 to 100.” If you also want Excel to enforce that rule, choose the appropriate validation criteria on the Settings tab. The prompt alone does not enforce the range.

To apply the same prompt to several cells, select the whole range before opening Data Validation. If the cells already have different validation rules, be cautious: editing validation for a multi-cell selection can affect the selected cells’ settings. Check the result on a sample cell before applying changes broadly.

Delete or change the pop-up message

To remove just the input message, select the cell, open Data > Data Validation, and go to Input Message. Clear the option to show the message, or remove the title and message text, then confirm with OK. The message should no longer appear when the cell is selected.

That action is different from clearing the cell’s contents. Pressing Delete on the worksheet removes entered data, but it does not necessarily remove the validation message. Likewise, deleting an input message does not automatically remove validation rules or an error alert.

If the goal is to remove all validation from the selected cell, use Data Validation and select Clear All in the dialog, then confirm. This removes the validation criteria and its associated input message and error-alert settings for the selection. It does not clear the cell’s current value or formatting. Since Clear All removes more than the prompt, use it only when you intend to discard the validation setup too.

Input messages versus error alerts

Excel provides two different types of Data Validation pop-ups:

Input message: Appears when a user selects the cell. It can explain the expected entry before the user types. It does not itself reject data.
Error alert: Appears after a user enters a value that does not meet the validation rule. Depending on the alert style, Excel can stop the entry, show a warning, or provide information.

To change an error alert, open Data Validation for the cell and use the Error Alert tab. You can turn the alert off or edit its text and style. If there is no validation rule, an error alert may not behave as expected: the alert is connected to the rule that defines valid entries.

A common misconception is that adding a message makes a cell a dropdown. It does not. For a selectable list, choose List under the validation settings and provide the list source. You can use an input message alongside that list to explain how to choose an item.

Copying, applying, and checking messages

Validation settings can be copied along with a cell, so copying and pasting a cell may also copy its input message and validation rule. If you only want the formatting or value, use the relevant paste option rather than an ordinary paste, and verify the destination cell afterward. The exact paste choices depend on the Excel version and platform.

When a message does not show, check these common causes:

The selected cell is not the cell that has the input message.
Show input message when cell is selected is turned off.
The message was added to a different cell or range than intended.
The workbook or worksheet is being viewed in an app or mode that handles Excel features differently.
The message is an error alert, which appears only after an invalid entry, rather than an input message shown on selection.

To diagnose it, select the cell, reopen Data Validation, and inspect both the Input Message and Settings tabs. If the worksheet is protected, or the file is open in a different spreadsheet application, some editing or display behavior may differ. Try the workbook in a desktop version of Excel if the relevant controls are unavailable in the current app.

Choosing the right way to guide users

Use an input message for brief, cell-specific instructions that should be visible while entering data. Use validation criteria when the entry needs to follow a rule, and an error alert when users should be notified after breaking that rule. For longer explanations that should remain visible, put instructions in a nearby worksheet cell or a separate help area instead of relying on a small pop-up.

For example, a form might use a list validation rule for a “Status” cell, an input message saying “Select the current review stage,” and a Stop-style error alert to reject values outside the list. Each part has a distinct purpose: the list defines choices, the input message offers guidance, and the alert responds to an invalid entry.

Frequently Asked Questions

Can I add a pop-up message without restricting what users enter?
Yes. Add an input message on the Input Message tab and leave the validation criteria as they are, or use no restrictive criteria. The message is guidance only and does not block entries.

How do I remove a pop-up but keep the dropdown list?
Open Data Validation, go to Input Message, and turn off the option to show the message or clear its text. Do not choose Clear All if you want to preserve the list validation rule.

Why does my message appear only after I type something?
You may have configured an error alert rather than an input message. Input messages display when the cell is selected; error alerts display in response to entries that fail the validation rule.

Can one message be added to multiple cells?
Yes. Select the range first, then configure the input message. Verify the range’s existing validation settings before applying changes, especially if its cells have different rules.

Does deleting the cell’s contents delete its message?
No. Clearing a cell value does not normally remove its Data Validation settings. Edit the Input Message tab to remove the prompt, or use Clear All if you also want to remove validation and related alerts.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.