The technique of Excel2016 table head making

Slash head making

Excel to make a table is very simple, select a certain area, right-click Select "Format cell" (or directly press ctrl+1 key) out of the Settings dialog box, switch to the "border" set the box line, you can quickly get a table.

The table in the diagram above is slightly more difficult than the diagonal in the header, which is actually very simple. When the cell is selected, enter the cell's border settings, you can see the middle of the diagram below, there is a diagonal line of the schematic mark, what kind of diagonal slash, you can directly click on the selection.

Double-click the cell, enter the project name "Week", and then press ALT + ENTER to return to the line, and then enter the project name "section." Select left alignment, in the above "Week" before the appropriate addition of space, slash text is set to complete.

Three-column Slash header

Sometimes it takes a header with a three-column slash, which is hard to achieve with the above method.

At this point, you can use the Direct Line painting method. Switch to the Insert tab, click on "Shape", select "Straight line", and directly draw a straight line in the cell, you can draw as many as you want.

However, the column text can not be entered directly, you need to take the form of inserting a text box. Insert a text box to enter and set the text, then you can copy the way to paste out the text box and adjust the position, and finally modify the text content on it.

Alternative tilt Table Head

The above two types of table head is more acceptable, below to demonstrate a more alternative way to make the head, you can apply to the PPT report, such as the need to beautify the place.

First, make the table in the normal process, and select all the cells in the header.

Press ctrl+1 key to pull out the cell Settings window, switch to the Alignment tab, in the text direction, set the angle of the text tilt, you can drag the mouse settings directly, determine the effect of tilting the head of the table.