It will suggest 6 conditional formatting options based on the data you select, including data bar, color scale, icon set, greater than, top 10% and clear formatting.Īs you hover over each option, you’ll see a preview of the data. The Formatting tab in the Quick Analysis tool is a smart tool, just select the range of cells you want to format, then click the Quick Analysis button below the selection and select the Formatting tab. Next, we’ll show you how to use each of the Quick Analysis tool’s five tabs.Īpply formatting using Quick Analysis tool As mentioned above, there are five tabs of Quick Analysis tool. Quick analysis tool help understand and manage data. Note: If you use Excel version lower than Excel 2013, you need to upgrade to Excel 2013 or later to use Quick Analysis Tool in Excel. To find the quick analysis tool, please review the following steps:Ĭheck the “Show quick analysis options on selection” option on the right side of the “General” tab. If the quick analysis tool is disabled, the quick analysis tool will not appear even after selecting data. Why is Quick Analysis tool Not Showing Up? The above options may vary depending on the data you select.

In the Quick Analysis Toolbar, there are 5 categories: Note: If you select an entire row or column and an empty cell, the Quick Analysis tool will not appear.

Switch between tabs and click options to create visualizations. Then you will see a series of data analysis options. Select a cell or data table and the Quick Analysis button will appear in the lower right corner of the selection.Ĭlick the Quick Analysis icon or press Ctrl+Q (Windows) or Command+Q (MAC) after selecting data to open the Quick Analysis tool.

Excel quick analysis button mac