Excel: Disable the Quick Analysis Popup

To disable the Quick Analysis popup in Excel for Microsoft 365 on Windows, go to File > Options > General, clear Show Quick Analysis options on selection, and select OK. Excel will stop showing the Quick Analysis button when you select a range, while leaving the rest of your spreadsheet features available.

What the Quick Analysis popup does

Quick Analysis is a small button that can appear just outside the lower-right corner of a selected range. Select a group of cells containing data, and the button offers shortcuts for applying common analysis and formatting actions. It is designed to make those actions easier to find without requiring you to navigate through the ribbon.

Select the button to see choices such as Formatting, Charts, Totals, Tables, and Sparklines. The suggestions depend on the selected data. For example, Excel might offer a color scale for a block of numbers, a chart based on adjacent categories and values, or a total for a column. The button is contextual: it appears after a suitable selection rather than staying on screen all the time.

Quick Analysis is separate from features such as AutoCorrect, Flash Fill, and the ribbon. Turning off its selection button does not disable those tools, remove existing charts, or change the values in your workbook. It simply hides this particular prompt.

Turn off Quick Analysis in Excel for Windows

In the Microsoft 365 desktop app for Windows, use Excel’s general options. You need to change this setting in the application, not in an individual worksheet, so the choice is not limited to the currently selected range.

Select File in the upper-left corner of Excel.
Select Options near the bottom of the File menu. If the Options window is already open, continue to the next step.
In the Excel Options window, select General in the left pane.
Under User Interface options, clear Show Quick Analysis options on selection.
Select OK to save the change and close the window.

Return to a worksheet and select a suitable range. The Quick Analysis button should no longer appear beside the selection. The setting takes effect in Excel itself; it is not a cell property or a workbook formatting option that you can copy between sheets.

What changes—and what does not

Disabling the option stops the button from appearing automatically when you select data. It does not remove the Quick Analysis commands from Excel or undo actions previously applied with them. Existing tables, charts, formatting, totals, and sparklines remain in the workbook unless you remove them separately.

That distinction is useful if the popup is distracting but you sometimes want its shortcuts. In supported desktop versions, you can still open Quick Analysis with the Ctrl+Q keyboard shortcut after selecting a range. On a Mac, the corresponding shortcut is generally Command+Q in versions that support Quick Analysis, but Command+Q can quit an app in many Mac applications. If the shortcut does not open the tool in your Excel version, use the available interface instead; do not rely on it as a universal way to restore the button.

The option is also different from turning off an entire Excel feature. Clearing the checkbox does not change how selection works, prevent you from using the Home ribbon, or stop Excel from calculating formulas. It only controls whether the Quick Analysis option is displayed on selection.

Turn the popup back on

If you later decide the button is useful, return to File > Options > General and select Show Quick Analysis options on selection again. Choose OK. Selecting a suitable data range should once again display the button.

If the checkbox is already selected but the button is absent, check what you have selected. Quick Analysis is intended for a range of data, and it may not appear for a single blank cell, a selection that Excel cannot interpret as a useful data block, or some unusual layouts. Try selecting a compact rectangle that includes labels and values, or select a continuous row or column of related data.

Choose a different way to avoid interruptions

Hiding Quick Analysis is the direct solution when you do not want the button to appear at all. If you only find it inconvenient in certain situations, changing your selection habits may be enough. For example, click a single cell to move the active cell without dragging across a block of data; a range selection is what commonly prompts the button.

You can also keep the option enabled and simply ignore the button. It does not alter cells unless you select one of its commands, so its presence alone does not change the worksheet. This may suit people who occasionally use its chart or totals suggestions and do not mind the small control.

Want it gone whenever a range is selected? Clear the Quick Analysis checkbox in Excel Options.
Use it sometimes? Leave the setting on and dismiss or ignore the button when it appears.
Want analysis without the popup? Use the ribbon, such as Insert > Recommended Charts for chart suggestions, or the relevant commands on the Home tab for formatting and totals.

Ribbon commands can offer more control than the suggestions in Quick Analysis, but they are not always a one-for-one replacement. For instance, a recommended chart is a starting point; you can then adjust its data, labels, and design using chart tools.

Mac and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. On a Mac, Excel’s settings are organized differently from the Windows File > Options dialog. In versions that provide the Quick Analysis preference, look under Excel > Settings (or Excel > Preferences in some releases) and check the editing-related options for Show Quick Analysis options on selection. Clear that option if it is present. The labels and availability can vary with the Mac release, so update Excel or consult its in-app settings if you cannot find it.

Excel for the web does not use the Windows desktop Options dialog, and its interface and available commands can differ. If you are working in a browser and cannot find the same checkbox, open the workbook in the desktop Excel app to change the Windows setting. Do not assume that changing the desktop preference will create an identical control in every browser version.

Common problems and misconceptions

The button is still visible after changing the setting. Confirm that you selected OK in the Options dialog rather than closing it with the window’s close button. Then test with a fresh selection. If you are using a different Excel installation or a work-managed computer, make sure you changed the option in the same app where the popup appears.

You want to remove a chart or formatting created with Quick Analysis. Turning off the popup does not reverse earlier changes. Select the chart or formatted cells and use the relevant Excel commands to remove or change that content. For cell formatting, for example, use the Home tab’s formatting controls; for a chart, select the chart and delete it if you no longer need it.

You think Quick Analysis is an error message. It is a normal shortcut panel, not a warning that something is wrong with the data. It may show suggestions that are not appropriate for your purpose; you are not required to accept them. Review any suggested action before applying it, particularly when working in a shared or important workbook.

You cannot find the checkbox. Check that you are in the desktop Excel application and that you opened File > Options > General on Windows. The Windows checkbox is not located in a worksheet’s right-click menu or in the ribbon’s Quick Analysis categories. In Excel for Mac, look in the app’s settings and account for version-specific naming.

Frequently Asked Questions

Can I disable Quick Analysis for only one workbook?
The Windows checkbox is an Excel application setting, not a per-workbook switch. Changing it controls whether the button appears in the Excel app, rather than storing a separate preference in one file.

Does turning off Quick Analysis delete anything?
No. It hides the automatic button on selection. Charts, tables, sparklines, formatting, and other content already added to a workbook remain unless you remove them yourself.

Can I use Quick Analysis after hiding the button?
In supported desktop versions, select a suitable range and try Ctrl+Q on Windows. The setting hides the on-selection button; it does not mean that all related commands or other ways to work with the data have been removed.

Why does Quick Analysis appear only sometimes?
Excel shows it when it recognizes a selection that may benefit from its suggestions. A single cell, blank area, or data arranged in a way Excel does not recognize may not trigger the button.

Is Quick Analysis the same as AutoCorrect or Flash Fill?
No. Quick Analysis offers contextual shortcuts for selected data, such as formatting, charts, totals, tables, and sparklines. AutoCorrect and Flash Fill are separate features with separate settings.

Will this setting affect other people opening my workbook?
The Windows option is an application preference, not a workbook instruction. Other people’s Excel apps use their own settings, so hiding the button on your computer does not generally turn it off for everyone who opens the file.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.