Ways to draw various diagonal lines in Excel tables

Today, I teach you in Excel table Slash, double slash, three slash, four slash method, the following small series will be detailed for you how to draw in Excel table Slash, double slash, three slash, four slash method, the specific contents are as follows:

One, the Excel table to draw a single slash

Step one, punch in the Excel document first, and make the table you want to adjust slightly larger, as shown in the figure:

Step two, then select the cell, right-click, select Format cells in the pop-up Drop-down menu, click the "Border" button in the pop-up window, click the "Slash" option, and then OK. As shown in the figure:

Step three, enter text in the cell, such as we enter the region date, as shown in the figure:

Step four, then we based on the content of their input, the use of manual methods to adjust the format, the following small series to introduce how to adjust:

1, using the keyboard (ALT + carriage return), and then add space to adjust

2, or adjust the date to the region's superscript, and then use the space bar to adjust the position, adjust it to their desired position can be

As shown in the figure:

Two, the Excel table to draw double slash

Step one, click the Insert tab in the menu bar, and then select "Shape" in the interface and select "line" under "line" in the pop-up interface. As shown in the figure:

Step two, use the line tool to draw a line in the selected cell, as shown in the figure:

In step three, use the Insert text box to type the text information in the header slash. In the menu bar, select click the Insert tab, select text box, pull out multiple text boxes in turn, and then enter text in the text box, select text box, click Format, select No fill in shape fill, and select No outline in shape outline. As shown in the figure:

Third, the Excel table in three slash or four slash

Here I do not talk with you more, and above the method of drawing a double slash, in addition to using the above method, you can also use Word to draw a table after copying to Excel.