Formatting Issues

How to Remove Excel Data Validation Messages and Clear Formatting

Natalie Taylor Sep 25, 2026 871 views

Question details

The user needs to remove pre-set data validation input messages and clear formatting from exported Excel worksheets.

Product: Spreadsheets
Device & OS: not provided
Scenario: Working with Excel files exported from business applications (such as Dynamics) that contain pre-configured validation notes.
Observed behavior: Yellow pop-up notes appear whenever specific cells are selected, causing an annoying interruption to the workflow.

Before you start

Identify whether the yellow pop-up messages are isolated to specific cells (like A98) or applied across the entire worksheet.

Solution 1Recommended

Clear Data Validation Input Messages

Remove the validation rules causing the yellow pop-up notes to appear when cells are selected.

Business applications often embed input messages to guide users on what data to enter. These messages are tied to Excel's Data Validation feature and can be cleared without affecting the actual data in your spreadsheet.

Select the Affected Cells

Highlight the specific cells causing the pop-ups, or press Ctrl+A to select the entire worksheet.

Open Data Validation Settings

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

Clear Input Messages

In the Data Validation dialog box, go to the Input Message tab and uncheck 'Show input message when cell is selected', or simply click the Clear All button at the bottom.

Apply Changes

Click OK to save your changes and remove the pop-up notes from the selected cells.

Data Preservation: Clearing data validation rules will not delete the text or numbers currently stored in your cells.

Solution 2

Clear Cell Formatting

Remove background colors, borders, and text styling from the exported data.

WPS Spreadsheet Solution

Easily Manage Data Validation and Formatting with WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and user-friendly interface to quickly find, clear, or customize data validation and cell formatting for your exported business data.

1. Open the Exported File: Launch WPS Spreadsheet and open the file exported from your business application.
2. Select Problematic Cells: Highlight the cells displaying the yellow pop-up messages.
3. Access Validation Options: Click on the Data tab and select Validation from the toolbar.
4. Clear All Limits: Click Clear All in the dialog box and confirm with OK to instantly remove the pop-ups.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) and exported business reports.Easily locate and clear bulk data validation rules in just a few clicks.Lightweight, fast-loading, and completely free to download.

microsoft office alternative - wps office

Frequently Asked Questions

Why do these yellow pop-ups appear in my exported Excel file?

These yellow pop-ups are Data Validation input messages. Source applications like Dynamics automatically set them to guide users during data entry, and they carry over into the exported spreadsheet.

Will clearing Data Validation delete my cell data?

No, clearing data validation or input messages only removes the rules and the pop-ups. The actual text, numbers, or formulas inside the cells remain completely intact.

How do I remove data validation from the entire worksheet at once?

Press Ctrl+A to select all cells in the worksheet. Then navigate to Data > Data Validation, and click Clear All to remove validation rules and messages globally.

What is the difference between Clear Formats and Clear All?

Clear Formats only removes visual styling such as background colors, bolding, or borders. Clear All will completely erase both the formatting and the actual content inside the cell.

Document & File Issues