Excel sets the application of cell formatting

The most common use of Excel is to format and effect the data and text in a table. So how do these things work out today, let's take a look at the settings for the common Excel format.

To finish writing and data formatting, we must use one of the most common tools in Excel: Formatting cells.

The way to format cells is simple, select the columns that you want to set up in the Excel table, row, cell, or range of cells, and then right-click the Format Cells menu, or click the cell item on the Format menu to find the cell formatting item in the following diagram.

Value tab: When we encounter converting numbers to text, decimal places, percentages, conversion time dates and other issues, you can use the Set cell format of the "number" label, you can clearly see that the "value" is to set the format of a pure number, such as the number of decimal digits, whether the use of thousands of points, and so on;

Alignment Tab: This is mainly about setting alignment, such as common center alignment, note that there are two directions, vertical direction and horizontal direction, which allows you to set 9 different positions, automatic line wrapping can be set when more than one line, and the column width is limited can be checked "line wrap" show all, "merged cells" May be one of the most important applications, check that he can merge, if the cancellation of the check can be canceled merged cells;

Font Label: Can be as we use in Word, very convenient to set the text color, font, size, underline, etc.

Borders tab: When we need to print the contents of the Excel table, the border is very useful (do not set the border, it is not visible when printing), if your printer support color, try different line style and color, will give you a beautiful form to provide a powerful help.

Pattern Label: The border is set edge effect and color, then "pattern" is to set the fill color and pattern place, this is also beautify Excel form very important tool;

How about, after introduction, did you personally try these features of Excel to format cell formats?

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join