How to turn on/off the Quick Analysis feature

Excel 365 2016 2010
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 2013

To turn on/off the Quick Analysis feature, follow the next steps:

   1.   On the File tab, click the Options button:

Excel 2013 options

   2.   In the Excel Options dialog box, on the General tab check or uncheck Show Quick Analysis options on selection:

General tab in Excel 2013

Note: You can also press Ctrl+Q on the keyboard to display the Quick Analysis options.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Show or hide enhanced ScreenTips

Show or hide enhanced ScreenTips

By default, Excel shows document tooltips (or screentips) when you hover on a button, but this option can be turned off.
Recalculating the worksheet

Recalculating the worksheet

If you are working with huge workbooks that contain a very large number of formulas, functions, and data, you can turn off the automatic recalculation.
Adding commands to the Quick Access Toolbar

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.