How to Disable Excel Cell Pop-Up Messages When Hovering
Question details
The user wants to stop Excel from showing informational pop-up messages when hovering over or selecting specific cells.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Working within a spreadsheet where unwanted cell information pop-ups or instructional boxes appear automatically.
- Observed behavior
- A pop-up box displaying cell information appears continuously whenever a specific cell or range of cells is hovered over or clicked.
Ensure you have editing permissions for the worksheet, as protected sheets will prevent you from modifying or removing Data Validation rules.
Disable Data Validation Input Messages
Turn off the specific Data Validation setting that triggers informational pop-ups when a cell is selected.
These pop-ups are usually created using the Data Validation 'Input Message' feature, which is designed to guide users on what data to enter. Disabling this setting removes the pop-up without affecting the actual validation rules restricting data entry.
Click and drag to select the cell or range of cells displaying the unwanted pop-up message.
Look at the top ribbon menu and click on the 'Data' tab.
Click on 'Data Validation' located within the Data Tools group.
In the Data Validation dialog box that appears, switch to the 'Input Message' tab.
Uncheck the box next to 'Show input message when cell is selected', then click 'OK'.
Clear All Data Validation Rules
Completely remove all data validation, including drop-down menus, restrictions, and input messages.
Easily Manage Data Validation and Cell Pop-Ups in WPS Office
WPS Spreadsheet provides a highly intuitive interface for managing cell input messages, data validation, and spreadsheet settings, making it easy to customize your worksheet behavior without hassle.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your affected document.
- 2. Select target cells: Highlight the cells currently displaying the pop-up message.
- 3. Access Validation settings: Navigate to the 'Data' tab on the top menu and click on 'Validation'.
- 4. Turn off input messages: Switch to the 'Input Message' tab and uncheck the 'Show input message' option.
- 5. Confirm and save: Click 'OK' to confirm your changes and save the spreadsheet.
Frequently Asked Questions
Why do some Excel cells show a yellow note box when I hover?
A yellow note box that appears on hover is typically a Cell Note or Comment, not a Data Validation message. To remove it, simply right-click the cell and select 'Delete Note' or 'Delete Comment' from the context menu.
Can I disable Data Validation pop-ups for the entire workbook at once?
You can disable it for an entire worksheet by pressing Ctrl+A to select all cells, then navigating to Data > Data Validation, and unchecking the 'Show input message' box. However, you will need to repeat this process for each worksheet individually within the workbook.
Does removing the input message delete my drop-down lists?
No, unchecking the 'Show input message when cell is selected' option only hides the informational pop-up. Your drop-down lists and any data entry restrictions defined on the 'Settings' tab of the Data Validation menu will remain completely intact.
