For example, here we want to make a single diagonal title with the name and theme. First, we enter the name in the cell, then press Alt+ ENTER to wrap the line in the cell, and then change the alignment to top alignment and left alignment.

Then we knock some spaces in front of the main body to move his position to the far right, then click the cell, click the right mouse button, select the cell format, and select the border. We select the diagonal border in the lower left corner, click OK, and that's it.

Second, make a double diagonal header.

If you want to make a double diagonal header, that means we need to enter three categories in a cell. At this time, we need to set the cell larger for us to input. For example, here we need to make a header of name, grade and subject. First, enter the name in the cell, press alt+ ENTER to enter the grade, and then press alt+ ENTER to enter the subject. Similarly, we should align the top and left and display the font in small bold.

Then enter a space in front of the grade and put it in the middle right position, and enter a space in front of the subject and put it in the far right position. Then click Insert a straight line in the selected shape, insert a straight line in the right position, change the color to black, and then press Copy a straight line and put it in the right position.

Thirdly, make an inclined meter head.

When the content of our header is long, we can make an inclined header to display the data if we need to set the font very small to display all the content when using the general header.

Let's first select the header area to be set, then click the right mouse button to select Format Cell, click Alignment, and set the angle to 45 degrees, which is not good-looking. You can press Ctrl+T to quickly beautify the table.

Fourth, freeze the header.

Sometimes we have a lot of data. If we drag the data down, we can't see the header. At this time, we can freeze the header, which is more convenient for us to check the comparison data.

We click the view function group, find the freeze pane, and choose to freeze the first row, so that we can keep looking down at the data header.

Fifth, print the title line.

Printing the title line means that when we print the form, the first line of each page is printed as the title line.

First of all, we click the page setup function group to find the print title, and select the header of the table at the top title line, so that each paper will print the title line.

What about these settings about the title line? Are they simple and practical?