These instructions apply to Excel 2010, Excel 2013 and Excel 2016. For example, you could set up a range to make values under or over a certain amount appear in a different color or with a special icon adjacent.If the Data Analysis command is not available in your version of Excel, you need to load the Analysis ToolPak add-in program. Then hover over one of the icons in that category to see the result previewed on your worksheet:įormatting: These shortcuts point to conditional formatting options. This is the Quick Analysis icon, and clicking it opens a panel containing shortcuts to several types of common activities related to data analysis.Ĭlick on of the five headings to see the shortcuts available in that category. When you select a range of cells, a small icon appears in the lower right corner of the selected area. Here are some points to keep in mind about Quick Analysis: When you need to do a speedy analysis of your data in Excel 2016, consider using the Quick Analysis feature.
To remove any conditional formatting, click Clear Format in the Quick Analysis gallery.įor additional formatting options and colors, select your data, and then click Home > Conditional Formatting. On the Formatting tab, move your mouse over the different options to see a Live Preview on your data, and then pick the formatting you like best.
The Quick Analysis button appears on the lower-right corner of the selection.Ĭlick the Quick Analysis button, or press Ctrl+Q. Here’s how you can quickly apply this type of formatting: For example, you can use a color scale to differentiate high, medium, and low temperature values. But Excel provides a bunch of ways to quickly analyze your data using conditional formatting. It can be hard to get a lot of meaning out of numbers in a worksheet.
0 kommentar(er)
