How to Disable Quick Analysis Options Near Selected Excel Cells
Question details
The user wants to stop the Quick Analysis tool or chart controls from appearing next to cells after making a selection.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Selecting data ranges or multiple cells while working in an Excel spreadsheet.
- Observed behavior
- A small Quick Analysis icon pops up automatically near the selected cells. Attempting to disable it via ScreenTip settings does not work in all Excel versions.
Make sure you have your Microsoft Excel application open. Note that menu options may vary slightly depending on whether you are using Microsoft 365, Excel 2019, or an older version.
Turn Off Quick Analysis Options in General Settings
This is the primary and most effective method to prevent the Quick Analysis icon from appearing when you select cells.
The Quick Analysis tool is controlled directly from Excel's General options. Disabling this specific setting resolves the issue for modern versions of Excel.
Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu.
In the Excel Options dialog box, ensure that the 'General' tab is selected in the left-hand pane.
Scroll down to the 'User Interface options' section and uncheck the box next to 'Show Quick Analysis options on selection'.
Click the 'OK' button at the bottom of the dialog box to save your settings. The popup will no longer appear when selecting cells.

Check ScreenTip Settings (Alternative Troubleshooting)
Some older tutorials suggest disabling shortcut keys in ScreenTips. While this does not disable Quick Analysis in modern versions, you can verify this setting if you are using an older Excel build.
Enjoy a Cleaner Spreadsheet Experience with WPS Office
If you find Microsoft Excel's automatic pop-ups and complex settings distracting, consider switching to WPS Office. WPS Spreadsheet provides a streamlined, highly compatible, and user-friendly interface that lets you focus on your data without unnecessary interruptions.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Spreadsheets: Right-click any existing .xlsx file and choose 'Open with WPS Spreadsheet'.
- 3. Work Without Distractions: Enjoy a clutter-free environment while retaining all advanced data analysis and charting tools.

Frequently Asked Questions
What exactly is the Quick Analysis tool in Excel?
The Quick Analysis tool is a contextual popup menu that appears when you select a range of data. It provides fast access to formatting, charts, totals, tables, and sparklines without needing to navigate the main ribbon.
Why can't I find the 'Show shortcut keys in ScreenTips' option?
Microsoft frequently updates Excel's interface. In newer builds of Microsoft 365 and Excel 2019/2021, the option to disable shortcut keys in ScreenTips was either removed or relocated, and it is no longer the correct way to disable Quick Analysis.
Will disabling Quick Analysis remove my ability to create charts?
No. Disabling this setting only hides the small shortcut icon that pops up next to your cursor. You can still create charts, apply conditional formatting, and use all data analysis features by using the 'Insert' or 'Home' tabs on the main ribbon.
How do I turn the Quick Analysis tool back on?
To re-enable it, simply go back to File > Options > General, and re-check the 'Show Quick Analysis options on selection' box under the User Interface options.




