Office Settings & Configuration

How to Delete Yellow Pop-Up Messages in Excel Worksheets

Elise WilliamsElise Williams Nov 10, 2026 868 views

Question details

The user wants to remove small yellow pop-up boxes that appear when selecting certain cells in a spreadsheet.

How to Delete Yellow Pop-Up Messages in an Excel Worksheet
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.
Before you start

Ensure the worksheet is unprotected, as you cannot modify Data Validation settings or remove input messages on a locked sheet without the correct password.

Solution 1Recommended

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.

1
Select the affected cells

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.

2
Open Data Validation

Navigate to the 'Data' tab on the top ribbon and click on 'Data Validation'.

3
Clear the Input Message

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.

4
Apply your changes

Click 'OK' to save your settings. The yellow pop-ups will no longer appear when you select those cells.

Disable Data Validation Input Messages
Protected Sheets: If the Data Validation button is grayed out, go to the 'Review' tab and click 'Unprotect Sheet'. You may need a password if the original author locked it.
Manage Data Validation with WPS Spreadsheet

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. 1. Open your file: Launch WPS Office and open your spreadsheet document.
  2. 2. Select the cells: Highlight the cells that are showing the yellow pop-up messages.
  3. 3. Access validation settings: Go to the 'Data' tab on the ribbon and click on 'Validation'.
  4. 4. Disable the message: Switch to the 'Input Message' tab, uncheck 'Show input message when cell is selected', and click 'OK'.
Free to download and useFully compatible with Microsoft Excel (.xlsx) formatsIntuitive Data Validation managementLightweight software with fast performance
microsoft office alternative - wps office

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.