How to turn on/off the Quick Analysis feature
Excel
365
When you select a range of data, Excel may display the Quick Analysis icon in the lower-right corner of the range. After clicking this icon, you will see a list of analysis options that can be quickly applied to the selected data.
This list contains:
- Conditional formatting (see more about Conditional Formatting in Excel):
![Quick Analysis Excel for Microsoft 365 Quick Analysis Excel 365](/images/tips/327_365/1.png)
- Create a chart (see different charts)
- Add most used formulas such as Sum, Average, Count, etc.
- Create a pivot table
- Create Sparkline graphics.
The exact options vary, depending on the data in the range.
The Quick Analysis option in the local Excel can be turned off.
To turn on/off the Quick Analysis feature, follow the next steps:
1. On the File tab, click the Options button:
![Excel for Microsoft 365 options Excel 365 options](/images/tips/excel_button365/365.png)
2. In the Excel Options dialog box, on the General tab, check or uncheck Show Quick Analysis options on selection:
![General tab in Excel for Microsoft 365 General tab in Excel 365](/images/tips/327_365/2.png)
Note: You can also press Ctrl+Q on the keyboard to display the Quick Analysis options.
See also this tip in French: Comment activer / désactiver la fonction d'analyse rapide.