Five ways to Excel oblique headers

The approach of the oblique table head:

Method One:

Practices

1, select the cell, dot format, cell, border, first select the thin solid line (see figure II), and then point slash (see figure III), and then select a slightly thicker solid line (see figure IV), and then click on the outer border of the icon (see figure V), so 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.

Method Two:

Figure I

Practice:

1, select the cell, dot format, cell, border, first select the thin solid line (see figure II), and then point slash (see figure III), and then select a slightly thicker solid line (see figure IV), and then click on the outer border of the icon (see figure V), so 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;

Method Three:

Practice:

1. Select the cell, click the Border tool in the toolbar (see figure Seven) and add the bounding box;

2. Point View/Toolbar/drawing, click the Line tool in the Drawing toolbar (see Figure Eight, click on the cursor will become a fine cross, and then in the cell with a cross cursor draw the first slash, and then click a Line tool, and then draw a second slash; the length or position of the line is not required, you can click the line segment, Hold down 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 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.

Method Four:

Practice:

1. Select the cell, click the Border tool in the toolbar (see Figure 10) and add the bounding box;

2, point View/Toolbar/drawing, click the Line tool in the Drawing toolbar (see Figure 11, after clicking the cursor will turn into fine cross) 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 (see Figure 12), Draw a text box in any cell, right-click a 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 of 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 paste three of such text boxes somewhere else, and in the three text boxes, enter "level", "No" and "year"; move the cursor to a circle in the lower-right corner of the dotted border. At this point, the cursor changes to the left-high right-low oblique double-headed arrow, and press the left button to minimize the border (see Figure 13);

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 a small circle on the edge of the text box, and then click on the cut can be.

Method Five:

Practice:

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. Point table/Draw slash header, open the Insert Slash Header dialog box (Figure 16), 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";

Figure 19

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

4, point "level" word, the cursor moved to the comb-like border (do not point to the small circle, as shown in Figure 17, let the cursor become a four-headed arrow, hold down the left mouse button, and then hold down SHIFT and drag the "level" word to the dotted box (when you start dragging the border, a thin dotted box appears in Figure 18, which is the position of the character after releasing the left key) Coincide with the top left side of the table header, release 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 (Figure 19), click on it, press and hold the circle on its edge to coincide with the cell border line coincides (see Figure 19);

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

Classification:

• Excel Tutorials