How do I solve a lot of formatting in Excel cells?

How do I solve a lot of formatting in Excel cells?

1, the cell Merge center and alignment:

In Excel, cell merging, centering, alignment is the most common format processing, generally at the table header or footer, all in the center of the alignment, how to center, select the cell, click the Merge Center of the menu bar and on it, as shown:

2, the cell display table print line:

Excel displays a gray border in the software by default, but not when it is printed. Select the cell that you want the border to, right-click the cell format, select the inside and outside border, as shown: (You can select the internal or direct selection according to your own needs).

3, Batch alignment:

When multiple formats appear in a column or row, the format is confusing, ugly, and needs to be bulk aligned. Select the contiguous cells, and click the alignment of the menu navigation bar to align, as shown in figure:

4, Digital cell automatic + 1:

Select the number of the previous column, the mouse placed in the lower right corner of the border to render the plus point when dragging down the mouse and holding down the CTRL key, you can automatically increase the number, as shown:

5. Automatically convert to monetary unit:

Enter a number in the cell, the right mouse button, set the Cell Format dialog box, select the number, currency, set the decimal places, click OK, as shown:

6, set the cell time format:

Enter time, select cell, right mouse button, set cell format, select number, time date, set formatting style, as shown:

Precautions:

Excel format is more complex than word, more information about cell automatic line change, please pay attention to.