Hold down the Ctrl key and drag the text box you just created, copy the formatted text box, change the text in it, then use Shift+ click to select the object in the header, right-click and select Merge.
Technical points: Use the border tab in the cell format dialog box to set the diagonal line, and use the alignment tab combined with the space bar to adjust the text position.
Method 2: The specific operation steps are as follows.
1. Click cell A 1 of the worksheet and enter the contents of the diagonal heading. For example, in this example, there are two headings "Project Name" and "Date". Enter the Project Name first, then press the shortcut key Alt+ ENTER to wrap the line in the cell, and then press Alt+ ENTER to enter the Date.
2. Press Ctrl+ ENTER to select a cell without leaving it.
3. Press the shortcut key Ctrl+ 1 to open the cell format dialog box. (If you right-click a cell and choose Cell Format from the shortcut menu that pops up, you can also open the dialog box, but it is faster to use shortcut keys. )
4. In the Cell Format dialog box, click the Border tab, and then click the left slash button.
5. In the Cell Format dialog box, click the Alignment tab and set the horizontal and vertical alignment of the text to justify both ends. After the setting is completed, click OK.
6. Observing the text in the title, it is obvious that the location of the project name is not very suitable. Double-click cell A 1, place the insertion point to the left of the project name, and press the space bar twice to position the project name to the right. Press Ctrl+ ENTER to leave the editing state and select cell A 1. If the "Project Name" is found to be broken, you can adjust the column width until it is appropriate, or you can adjust the row width to make the header size appropriate. Of course, you can also change the size of the text in the header. Finally, you can get the diagonal effect of the header.