Teach you to make a super complex Excel table head

In Excel, you often run into complex headers that you want to make, including a slash and text (see the red circle below), many beginners are often helpless, and some simply random adjustment, due to the method of improper, the result is spent a long time but can not achieve the ideal effect.

Figure 1

Many beginners often use the following two actions to handle:

1, with the border in the diagonal to adjust;

2, enter the text directly in the cell.

Now the author analyzes its drawbacks:

1, with the diagonal in the border to adjust, can only draw a slash, can not draw more than one slash, at the same time, draw a diagonal can only be a cell diagonally, can not change at will. See figure below:

Figure 2

2, in the cell directly input text, to branch, can only let the cell automatically wrap, and then use the space bar to move the corresponding text to combined second line, this method time-consuming and laborious, a lot of text often can not do the ideal effect.

So far, many beginners are not exclaiming: make a table head how so difficult!!

In fact, change one kind of thinking, change a method, on "Vista". Below, the author still take figure 1 as an example to explain in detail.

First, enter the contents of the cell without the slash, and adjust the row (see Figure 3).

Figure 3

To illustrate here, it is important to adjust the ranks, so that the other parts of the table after the design with a slash no longer need to adjust, otherwise adjust the rest of the table, the content of the slash cell is again adjusted. I must pay attention to this point.

Then, click Line in the Drawing toolbar (Figure 4, where the red circle is painted).

Figure 4

Move the mouse over the cell, clear the start and end of the line, and hold the mouse over the start point to the end to draw the first line.