Hover your mouse pointer over the icons, and you can see the suggested format in the original cells.
In this tab, you’ll find a preview of the most useful options of conditional formatting. With Quick Analysis in Excel 2013, you just need to click on one of these options to preview how these tools can present your data. When you click on that icon, a new toolbar with five tools will be displayed.Īll these tools already exist in the previous versions of Excel, but not many users are aware of them. When you select a range of cells in Excel 2013, a small icon appears in the bottom right corner.
Hi all, I'm trying to find the QUICK ANALYSIS tool in my Excel on mac version 15.14.Quick Analysis helps you to visualize very quickly how you can display your data in a Chart, a Table, Conditional Formatting, Sparklines, …īut it is also possible to remove this option (end of the post). Quick Analysis Tool Button Excel 2016 Mac.Quick Analysis Quick Analysis helps you to visualize very quickly how you can display your data in a Chart, a Table, Conditional Formatting, Sparklines, But it is also possible to remove this option (end of the post).