Ways to draw various diagonal lines in Excel tables

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.