Table formatting operation refers to the formatting of the worksheet. The formatting operation includes setting the numerical format, font size, text color, etc. of the data in the cell, as well as setting the border, shading, and background of the cell. Color, alignment, etc.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

What are the table formatting operations?

The formatting of the worksheet includes the format of the cells, such as setting the number format, font size, text color, etc. of the data in the cells, as well as setting the borders and shading (background color) of the cells. ), alignment, etc.

The setting method is as follows:

(1) Select the cell range to be formatted.

(2) Right-click the selected area and select "Format Cells" in the "Shortcut Menu" to open the dialog box.

(3) In the "Number" tab, you can set the format of the data, such as "numeric" type data, you can set the number of decimal places, whether to add a "thousand separator", etc.; such as "Currency" Type data, you can set whether to add a currency symbol before the value.

Recommended: "Excel Tutorial"

(4) In the "Alignment" tab, set the alignment of the data in the cell Alignment (including horizontal alignment and vertical alignment), and can be set to merge or unmerge cells, etc.

(5) In the "Font" tab, set the font, font size, font color, etc. of the text in the cell or cell range.

(6) In the "Border" tab, set the border line of the cell or cell area, first select the line type, and then apply it to the required border.

(7) In the "Pattern" tab, set the background color (shading) of the cell or cell range.

(8) After setting, confirm it to take effect.

The above is the detailed content of What are the table formatting operations?. For more information, please follow other related articles on the PHP Chinese website!