![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |