There's a knack for drawing tables in Excel cells

Source: Internet
Author: User
Tags range

Visually grasp the overall distribution of data through gradient colors
Displays a two-color gradient or a three-color gradient in a range of cells, shading the color to represent the values in the cell, and the gradient color intelligently changes with the size of the data value, very tough. The new version of Excel brings a brand-new "level" conditional format that allows readers to view them more visually and comfortably.
1. Select the data you want to analyze, such as the "A3:c8" cell range.
2. In the "Start" tab of the Excel ribbon, click the Conditional Formatting button in the Styles group.
3. In the conditional Formatting Drop-down menu, perform the Levels--> Green-Yellow-red step command.
At this point, the table of the specific data in accordance with the size of the data, displayed in different colors, for the statistical summary of the data is very practical, can make people on the overall change situation at a glance.
Make the data more expressive with varying lengths of color bars
The above is a comparison of the overall table, if you only need to be able to see the size of a certain column of data, how to do? The data bar conditional format can be applied to data, and the length of the data bar represents the size of the values in the cell. By looking at a colored bar, you can easily get to know the maximum or minimum value in a column of data by eliminating the time to contrast the values individually. The specific method of operation is as follows:
1. Select a range of cells in the table.
2. In the "Start" tab of the Excel ribbon, click the Conditional Formatting button in the Styles group.
3. Then, in the pop-up drop-down menu, execute "Data bar"--> Blue Data Bar command.
At this point, the application of the "Data bar" conditional format, you can easily see the entire column of the data maximum and minimum value, do not have to go data-by-contrast to see the dazzling.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.