

Also read: How to Make a PIE Chart in Excel Quick Analysis Tool Not Showing Up in Excel – How to Fix? Note that when you hover over the charting options in the Quick Analysis tool, it will show you a preview of how each chart would look like using the selected data. So far, we have seen examples of using the Quick Analysis tool with numeric data and dates.īut you can also use this with text data.īelow I have a dataset where I have the product id in column A and the price in column B. For example, if I first click on the option to highlight cells with dates occurring in the last week and then click on the option to highlight cells with dates occurring in the last month, both the rules would be in place.Īlso read: How to Highlight Weekend Dates in Excel? Highlight All Cells That Contain a Specific Text When you click on more than one option, more than one rule is applied to the selected cells.This rule remains in place unless you remove it by clicking on the ‘Clear Format’ option (it’s also there in the Formatting group) When you use any of the options in the Formatting group, it uses conditional formatting to create a rule for the selected cells.Note that the dates being highlighted are using the current date of my system at the time of taking this screenshotĪ few things you should know when using the Quick Analysis tool to highlight cells using Conditional Formatting: It appears automatically whenever you select a range of cells an icon in the bottom right part of the selection. If you’re searching for the Quick Analysis Tool in the ribbon in Excel, you won’t find it. Where is the Quick Analysis Tool in Excel?Įxcel Quick Analysis tool was introduced in Excel 2013, so you won’t find it in versions before Excel 2013. Can I add More Options to the Quick Analysis Tool?.Quick Analysis Tool Not Showing Up in Excel – How to Fix?.

Quickly Insert a Cluster/Stacked chart, Pie Chart, or Scatter Chart.Remove Conditional Formatting from the Selected Range of Cells.Highlight All Cells That Contain a Specific Text.Highlight Dates That Occur Last Month or Last Week.Highlighting All the Cell With Value Greater Than a Specified Value.Calculate Percentage Total For Multiple Rows/Columns.Get the SUM or COUNT of Multiple Rows/Columns in One Go.Using Quick Analysis Toolbar in Excel – Some Practical Examples.What Can You Do with Quick Analysis Tool in Excel?.

