While operating Excel, some netizens expressed that they were at a loss when they encountered too many formats in cells. What should they do? Today, the editor will talk about the skills to solve the problem of too many formats in Excel cells. Friends who need it can take a look together.

1. Merge, center and align cells:

In Excel, merging, centering, and aligning cells are the most common formatting processes. Generally, merge and center alignment is used at the header or footer of the table. How to align in the center? Select the cell, click Merge, Center, and Align on the menu bar. To it,

2. Cell display table printing line:

By default, Excel displays a gray border in the software, but it does not appear when printing. Select the cells that require borders, set the cell format, and select the inner and outer borders, as shown in the figure: (You can directly select the inner or outer borders according to your needs).

3. Batch alignment:

When multiple formats appear in one column or row, the formatting will be confusing and ugly, requiring batch alignment. Select consecutive cells and click Alignment on the menu navigation bar to align them.

4. Number cells automatically +1:

Select the number in the previous column, place the mouse on the lower right corner of the border and when the plus sign appears, drag the mouse downward and hold down the CTRL key to automatically increase the number.

5. Automatic conversion into currency units:

Enter a number in the cell, right-click the mouse, enter the Format Cells dialog box, select Number, Currency, set the number of decimal places, and click OK.

6. Set the cell time format:

Enter the time, select the cell, right-click the mouse, format the cell, select the number, time and date, and set the format style.

Come and learn how to solve the problem of too many formats in Excel cells. It will definitely help everyone.