How to Remove the Orange Input Message Box from an Excel Cell in WPS Spreadsheets
Question details
The user wants to remove or hide an orange description box that appears when selecting a cell in WPS Spreadsheets, which is caused by a Data Validation input message.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user selects a cell in a spreadsheet and sees an orange input message box, and wants to disable or remove it without changing other workbook data unnecessarily.
- Observed behavior
- The orange input message box appears each time the cell is selected.
Open the workbook in WPS Spreadsheets and identify the exact cell or range that displays the orange input message. If you are not sure which cells have validation rules, click a cell and check whether the Data Validation input message is enabled.
Disable the Input Message for a Cell Data Validation Rule
Use this when you want to keep the data validation rule but stop the orange box from appearing when the cell is selected.
Open the workbook in WPS Spreadsheets and select the cell or range that shows the orange input message box.
Click the Data tab on the ribbon to access the Data Tools group.
In the Data Tools group, click Data Validation to open the Data Validation dialog box.
In the Data Validation dialog box, click the Input Message tab.
Uncheck the Show input message when cell is selected checkbox, then click OK.
Remove the Data Validation Rule Completely
Use this if you no longer need the validation rule, its dropdown, or its input message for the selected cell or range.
Remove Data Validation Input Messages in WPS Spreadsheets
WPS Spreadsheets lets you quickly disable or remove the input message attached to a Data Validation rule, so the orange cell description box no longer interrupts your work.
- 1. Open the workbook: Launch WPS Spreadsheets and open the workbook that contains the orange input message box.
- 2. Select the cell: Click the cell or select the range where the input message appears.
- 3. Open Data Validation: Go to the Data tab and click Data Validation in the Data Tools group.
- 4. Disable or remove the message: On the Input Message tab, clear Show input message when cell is selected, or use Clear All to remove the rule entirely.
- 5. Apply the change: Click OK to save the settings and close the Data Validation dialog.
Frequently Asked Questions
Why does an orange box appear when I click a cell in WPS Spreadsheets?
The orange box is usually the Input Message associated with a Data Validation rule. It appears only when Show input message when cell is selected is enabled.
How do I hide the input message but keep the data validation dropdown?
Select the cell, click Data > Data Validation, open the Input Message tab, uncheck Show input message when cell is selected, and click OK.
How do I remove the orange input message from multiple cells at once?
Select the entire range or all affected cells, open Data Validation from the Data tab, and clear the input message option. If cells have different validation rules, you may need to clear the rules or clear the input message for each selection.
Can I delete the data validation rule completely?
Yes. Select the cell or range, click Data > Data Validation, then click Clear All or set Allow to Any value, and click OK to remove the validation rule and its input message.
Does this work the same way in WPS Spreadsheets and Microsoft Excel?
The steps are very similar. In both applications, use the Data tab and Data Validation dialog to control the input message or remove the validation rule.
