How to turn on/off the Quick Analysis feature
Excel
2016
When you select a range of data, Excel displays a Quick Analysis button in the lower-right corner of
the range. But this option can be turned off.
![Quick Analysis Excel 2016 Quick Analysis Excel 2016](/images/tips/327_2016/1.png)
To turn on/off the Quick Analysis feature, follow the next steps:
1. On the File tab, click the Options button:
![Excel 2016 options Excel 2016 options](/images/tips/excel_button2016/2016.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 2016 General tab in Excel 2016](/images/tips/327_2016/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.