Two methods of making Excel slash head

When you make an Excel table, you use a slash-and-slash-head. It's not hard to add a slash, you can right-click a cell to add a single slash using format cell formatting or to add multiple slashes manually by using Insert-shape-line.

Slash add good, content how to input it? This is a problem that many students are concerned about.

Small knitting to find two simpler ways:

Use a text box to add content

Click Insert-text box-Horizontal vertical text box.

The mouse will go down the arrow like

, drag the mouse to generate a text box. Then type the header content in the text box. You can also make some text formatting edits if you want.

When the text box content is entered and edited, move the mouse, and when it is turned into four arrows, drag the text box to the diagonal header cell. You can then adjust the position of the header content by adjusting the position and size of the text box.

(Note: Don't forget to set the text box to have no fill, wireless bar format Oh ~)

The same way, the other contents of the header into the text box, and finally drag the past, find a suitable place to put the good! (Here small easy to single slash head for example, multiple slash table head as long as more than a few text boxes can be built)

Second, direct input

Enter the header content directly in the cell and press "Alt+enter" to wrap the line. Then you can adjust the position of the content by wrapping and spacebar.

This method is relatively simple, but not as good as the text box control, the layout may not be so beautiful.