Office Settings & Configuration

How to Disable Quick Analysis Options Near Selected Excel Cells

John WilsonJohn Wilson Oct 21, 2026 873 views

Question details

The user wants to stop the Quick Analysis tool or chart controls from appearing next to cells after making a selection.

How to Disable Quick Analysis Options Near Selected Excel Cells
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu.

2
Navigate to General Settings

In the Excel Options dialog box, ensure that the 'General' tab is selected in the left-hand pane.

3
Disable the Feature

Scroll down to the 'User Interface options' section and uncheck the box next to 'Show Quick Analysis options on selection'.

4
Apply Changes

Click the 'OK' button at the bottom of the dialog box to save your settings. The popup will no longer appear when selecting cells.

Turn Off Quick Analysis Options in General Settings
Quick Analysis Shortcut: Even with this setting disabled, you can still manually trigger the Quick Analysis tool anytime by selecting your data and pressing Ctrl + Q on your keyboard.
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open Your Spreadsheets: Right-click any existing .xlsx file and choose 'Open with WPS Spreadsheet'.
  3. 3. Work Without Distractions: Enjoy a clutter-free environment while retaining all advanced data analysis and charting tools.
Completely free and lightweight alternative to Microsoft OfficeSeamless compatibility with all Microsoft Excel formats (.xls, .xlsx, .csv)Clean, intuitive user interface without aggressive automatic pop-upsFamiliar layout ensures zero learning curve when migrating your spreadsheets
microsoft office alternative - wps office

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.