Make Excel Oblique Header

Excel makes the table, the indispensable operation is--make oblique table head, the following method may look, hope to bring you help

First Law:

1, select the cell, point format, cell, border, first select the thin solid style, and then point Slash, and then select a slightly thicker solid line, and then point outside the border of the icon, so that the border is painted;

2, then select the cell, point format, alignment, horizontal alignment to select the normal or left; vertical alignment, select the distributed alignment (the upper and lower position is not tense, choose center better);

3, enter the class, press ALT + return; Enter the name again;

4, respectively in the name and class before the addition of spaces, so that the word placed in the appropriate position.

Second Law:

1, select the cell, point format, cell, border, first select the fine solid style. Then point Slash, then select a slightly thicker solid line, and then point the outer border of the icon, so that the border is painted;

2, then select the cell, point format, alignment, horizontal alignment and vertical alignment are selected distributed alignment (upper and lower position is not tense, the selection center better);

3, the input of "name class", the font size selected as number 18th;

4. Select "Name", right button, set cell format, select subscript, select "Class", right health, set cell format, check superscript;

The Third law:

1. Select the cell, click the Border tool in the toolbar and add the bounding box;

2. Point View/Toolbar/drawing, click the Line tool in the Drawing toolbar and then draw the first slash in the cell with a cross cursor, then click the Line tool again, and then draw the second slash; the length or position of the line is not required, you can press the left button to drag the segment to move the position, Then put the cursor on both ends of the circle and hold down the left button to adjust the length and direction of the line segment;

3, selected cells, dot format/cell/alignment, horizontal alignment and vertical alignment are selected as justified;

4, in the cell input "discipline grade year", put the cursor on the "subject" word behind, press alt+enter, and then put the cursor to the "level" after the word, press Alt+enter, and then put the cursor after the word "no", press Alt+enter;

5, in the "Discipline" front, "not" before and "year" plus space, the subject, grade and year to adjust to the appropriate position;

6, adjust the height and width of the cell and slash position, make the table head more good-looking.

Law four:

1. Select the cell, click the Border tool in the toolbar and add the bounding box;

2. Point View/Toolbar/drawing, click the Line tool in the Drawing toolbar and then draw the first slash with a cross cursor in the cell, then click the Line tool again and draw the second slash.

3, point View/Toolbar/Drawing toolbar, text box (horizontal) tool, in any cell to draw a text box, right-click the small circle in its dotted border, and in the right-click menu, click Format Text box, and the following window appears (see Figure 14), where the Colors and Lines tab, in the Fill and line "In the color, all selected colorless, OK. and enter "Discipline" in it:

4, move the cursor to the dotted border, so that the cursor becomes a cross four-arrow shape, click the right button, point to Copy, and then to paste three of such text boxes elsewhere, in the three text boxes, enter the "level", "" "and" year "; move the cursor to the circle in the lower right corner of the dotted border, At this point, the cursor changes to the left high right low oblique two-headed arrow, press the left button to minimize the border;

5, move the cursor to the dotted border, so that the cursor into the four-arrow shape, and then press the left button to drag them to the appropriate position;

6, the length or position of the line is not required, you can click the line, press and hold the left button to drag the segment to move the position, and then put the cursor at both ends of the circle and hold down the left button to adjust the length and direction of the line segment;

7, to remove the slash and text box, you can right-click on either end of the line or text box edge of the small circle, and then cut on the point.

Law Five:

1, open Word document, point table/Insert/table, select a row, roughly adjust the size of the box about 3 cm wide, 2 cm high (too small, the next bad adjustment of text);

2. Dot table/Draw slash header, open the Insert Slash Header dialog box, select Style two, select font size: small fourth; row title: Enter "Discipline", data title: Enter "Level", column heading: Enter "year", OK (prompt cell is too small, whether it is still point "OK");

3, any point of a word, the border will appear as shown in Figure 17 Small garden Circle, right key small circle, point combination/cancellation combination;

4, point "level" word, the cursor moved to the comb-like border, let the cursor turn into a four-headed arrow, hold down the left mouse button, and then hold down SHIFT and drag the level word to coincide with the top left side of the dashed box and the table header, loosen the left button, and then release shift. (Hold down shift to make the graphic move more accurately)

5, drag the "don't" word, so that the left side of the dotted box and the "level" word difference between the word width, the top of the dotted box and the "level" of the word half height;

6, drag the "learn" and "don't" word separated by a word wide, high and level of the same height, the "section" dragged to and "branch" flat Qi;

7, drag the "year" to the left and "level" flat, up and down and "do not" separated by a high word, the "part" to the "year" flat Qi;

8, the right side of the table to drag to the "section" of the right, the table under the end of the line dragged to the bottom of the "year";

9, point any slash, put the cursor on its left side of the circle, let the cursor into a double-headed arrow, hold down the left button, and then press ALT, adjust the slash two endpoints to the appropriate position.

10, according to the initial good shape of the head of the table to make some adjustments, so that its high width and shape more appropriate.

11, the word to do a good job in the slash head screenshot (note to the border line included in the screenshot), copied to the file, click on it, press and hold the circle around its edge to just and the cell border line coincide;

12, if we want to resize the cell again, we also have to resize the screenshot.