How to Delete Yellow Pop-Up Messages in Excel Worksheets
Question details
The user wants to remove small yellow pop-up boxes that appear when selecting certain cells in a spreadsheet.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Navigating or entering data into a spreadsheet created by another author.
- Observed behavior
- Small yellow pop-up messages automatically appear when clicking on specific cells, usually displaying hints or instructions, even if the cell doesn't restrict data entry.
Ensure the worksheet is unprotected, as you cannot modify Data Validation settings or remove input messages on a locked sheet without the correct password.
Disable Data Validation Input Messages
This is the most direct way to eliminate the yellow pop-up boxes without affecting any underlying data entry restrictions.
These yellow pop-ups are created using the Data Validation feature. You can disable the message prompt from the settings while keeping the actual data rules intact.
Highlight the specific cells, or click the triangle in the top-left corner of the grid to select the entire worksheet where the yellow pop-up boxes appear.
Navigate to the 'Data' tab on the top ribbon and click on 'Data Validation'.
Go to the 'Input Message' tab in the dialog box. Uncheck the box for 'Show input message when cell is selected'. Alternatively, you can simply delete the text inside the Title and Input message fields.
Click 'OK' to save your settings. The yellow pop-ups will no longer appear when you select those cells.

Clear All Data Validation Rules
Use this method if you do not need any data entry restrictions, dropdown lists, or messages on those cells and want to clear the validation entirely.
Easily Edit or Remove Data Validation in WPS Office
WPS Office Spreadsheet provides a seamless and free way to manage, edit, or remove Data Validation rules, including unwanted pop-up messages. It offers full compatibility with Microsoft Excel formats and a highly intuitive interface.
- 1. Open your file: Launch WPS Office and open your spreadsheet document.
- 2. Select the cells: Highlight the cells that are showing the yellow pop-up messages.
- 3. Access validation settings: Go to the 'Data' tab on the ribbon and click on 'Validation'.
- 4. Disable the message: Switch to the 'Input Message' tab, uncheck 'Show input message when cell is selected', and click 'OK'.

Frequently Asked Questions
What are these yellow pop-ups actually used for?
They are 'Input Messages' created via the Data Validation feature. They are usually designed by the spreadsheet author to provide instructions or hints on what type of data should be entered into specific cells to prevent errors.
Can I disable all pop-up messages in the entire workbook at once?
You cannot do it for the whole workbook in one click, but you can do it per worksheet. Select the entire worksheet (by clicking the triangle in the top-left corner) before opening Data Validation. If it prompts to extend to cells with different settings, click 'OK', then uncheck the input message option.
Why is the Data Validation option greyed out?
The worksheet is likely protected. You must go to the 'Review' tab and select 'Unprotect Sheet' before you can edit Data Validation rules. A password may be required if the creator set one.
Will removing the input message break the data restrictions?
No. Unchecking the 'Show input message' box only hides the yellow pop-up hint. The actual data restrictions and drop-down lists set in the 'Settings' tab of the Data Validation dialog will still function normally.




