What is Quick Analysis in Excel

Excel 2016 and 2013 provides users with popular tools for doing quick analysis of the selected data. The tools that are available as part of Quick Analysis are Formatting, Charts, Totals, Tables and Sparklines.

Let us take the following sample data and have a quick look at the charts that can be for this data.


Select the data and click the Quick Analysis icon available at the bottom right hand side of the selection.


This should provide you with the option to use different tools as shown below.


Now let us say you want to pick the better looking charts for the sample data. Navigate to Charts tab in Quick Analysis tool and check the preview for different chart types. And on selecting your preferred chart type, will add the chart to your worksheet.


Turn Off Quick Analysis tool

For some reason if you do not want to have the Quick Analysis tool on selecting the data then you can turn off this feature using the General Options.

Click the File menu –> Options from the menu list.


In the General Options window, navigate to User Interface options and unmark the check box with caption as “Show Quick Analysis options on selection”. Click OK button to confirm and save the changes.

In Category: Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 3 Comments
  • Manjunath N March 14, 2014, 10:47 pm

    thanks a ton. its very helpful for me

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.