How to Draw a Straight Line on Excel

Similar to when you work in Word, you can also draw straight lines in Excel to represent the chart style or used to draw thinking diagrams … So how to draw lines, draw arrows in Excel do as how? Please follow the instructions in detail below.

As mentioned above, drawing shapes in Word can be drawn straight lines, arrows, circles … are quite basic and simple operations, then with the Excel application you can also do it. Same to Draw straight lines, draw arrows in Excel with a very handy Shapes toolkit.

Create straight lines and arrows on the Excel application

Instructions for drawing straight lines, creating arrows in Excel

In this article, we will demonstrate how to draw straight lines and arrows Excel 2019 – this is the latest version of Office suite released this year. You can do the same thing for older versions of Excel like: Excel 2016, 2013, 2010.

1. How to Draw straight lines in Excel

Step 1: You open the Excel you are using, the session we open is Excel 2019. Then click on the tab Insert -> then click next Illustrations -> select the item Shapes to represent drawings in Excel. At the section Line -> click on the first line.

Step 2: Next, you click on a cell and drag the mouse to the right for example to create a line. When you release the mouse button, you will see 2 points on both ends of the line as in the image below.

Note: When drawing straight lines, you should press and hold the key Shift so that the line does not bend or bend.

Step 3: After you have created and drawn the line -> you will customize the thickness of the line by -> you click on the line just drawn -> then click on Format -> select Shape Outline -> and then select Weight to choose the thickness for the line you just drew.

When you hover the mouse on the thickness size for the line, you will see that it is applied right on the line so you know whether the thickness you just drew is suitable for you to take the initiative in choosing.

Step 4: Next, you can change the color of the line, you can change it by -> clicking Shape Outline -> then select the color you want.

Step 5: Once you have created the line and edited the line, if you need to insert text at the two points of the line, do the following.

You clicked Insert then find the group Text as described in the image -> and then continue Textbox.

Next, click and hold the mouse in the direction you want to create the Textbox, as shown below is the first 2 points of the line -> then, you enter the content in the Textbox box.

If you want to change the font, as well as the font size in Textbox, then highlight the text -> and select the format in the dialog box that appears. You can adjust the position of the text on the two ends of the line if you want.

Step 6: Next, remove the borders and background for the Textbox if you want. To do so, right-click Textbox -> select Format Shapes.

Display interface Format Shapes, in section Line -> click No Line. Next to item Fill -> click No Fill.

Then, you continue to create Textbox with the other end and name B to get the line AB as shown in the image below.

Step 7: The two ends of the line will disappear when you click outside the content. To create a segment with a starting point and an end point -> click on the item Shapes select picture Oval ellipse for example, to add 2 terminal points for a line.

Step 8: The operation as above is you will get a new point as described in the image below. To change the color, click Format -> then edit the color for the dot at Shape Fill item and item Shape Outline.

At the other end -> you do the same and will be straight line AB as in the picture below.

Step 9: To move the straight line as well as the objects in the line, you need to perform the grouping of the objects in the line into a common object.

Then press and hold the key Shift -> and then click on the objects in the picture -> and then right click on any object -> and select Group -> and then continue Group to group them together.

When you successfully group, there will be a grid around the line as in the image below.

Finally, you can move the straight line, this line without changing the position of the objects in the picture.

2. How to Draw arrows in Excel

How to draw arrows in Excel 2019, you are similar to when you draw straight lines in Excel.

Step 1: In the section Shapes -> you choose Line Arrow -> then click and hold the left mouse button, then you drag to get the line is the arrow.

Step 2: After that, you can also change the color, the thickness of the arrow the same way we did with the straight line we have instructed above.

Next, you use the Textbox to add the start and end points for the arrows if you want. You can add an endpoint at the tip of an arrow with an ellipse, for example. Finally, you will get an arrow as AB as shown below. You can also group objects together similar to the one in the line above so you can move the arrow without changing the position of existing objects in the picture.

Step 3: In addition, you can also draw lines, drawing arrows in a kinked manner in the section Line. Or choose in the section Block Arrows to draw arrows in a circular fashion in the mind map in Excel.

https://thuthuat.taimienphi.vn/cach-ve-duong-thang-trong-excel-47436n.aspx
Above is the guide Draw straight lines in Excel, the way you draw straight lines, draw arrows, as well as draw shapes in Excel is basically that users use the tools available in Shape to draw, then users add the relevant parts, and then group the objects. to move to different positions on the worksheet without worrying about the location of the drawn objects, this is for Excel, and for Word, the way to draw shapes in Word is similar, using the Tool in Shape. Good luck!

How to Draw a Straight Line on Excel

Source: https://sccaid.com/how-to-draw-straight-lines-in-excel/

Share this post