How to Draw a Straight Line in Microsoft Excel

How to draw a straight line, draw an arrow in Excel

On Excel users can draw lines, arrows with drawing tools are available to represent in diagrams in Excel.

  • SVG element in HTML5
  • How to draw straight lines, curves in Photoshop

On office software Word, Excel or Power Point, there are always drawing tools to represent types of diagrams and thinking diagrams. These types of diagrams will make it easier for the reader to visualize the content being presented, to grasp the content more quickly. One of the basic types of mind map representation is drawing straight lines, drawing arrows. The following article will guide you how to draw straight lines, draw arrows on Excel.

  1. How to create charts, graphs in Excel
  2. Instructions for inserting, drawing and creating charts in Word 2007
  3. Tutorial for Word 2016 (Part 18): How to add Shape shapes

Instructions for creating straight lines, arrows on Excel

1. Draw straight lines in Excel

Step 1:

In Excel, click on the Insert tab and then click on the Illustrations group . Select the Shapes item to represent the drawing on Excel. Here the Line section of the user clicks on the first line.

Picture 1 of How to draw a straight line, draw an arrow in Excel

Step 2:

You click on a cell and drag the mouse to the right to create a straight line. When you release the mouse button, you will see 2 points at both ends of the line. Note that during the drawing process, hold down the Shift key so that the line is not broken.

Picture 2 of How to draw a straight line, draw an arrow in Excel

Step 3:

After creating the line, we will customize the thickness for the line, click on the line just drawn and click on the Format tab , select Shape Outline and select Weight to select the thickness for the line.

When hovering on the thickness size will be applied right on the straight line for users to know.

Picture 3 of How to draw a straight line, draw an arrow in Excel

Step 4:

To change the color for the line, we also click on Shape Outline and then select the color we want to use for the line.

Picture 4 of How to draw a straight line, draw an arrow in Excel

Step 5:

Once you have created the straight line and edited the line, you need to insert the text at the two points of the line. Click the Insert tab and then find the Text group, select the Textbox .

Picture 5 of How to draw a straight line, draw an arrow in Excel

Step 6:

Click and hold the mouse in the direction you want to create the Textbox, here is the first 2 points of the line, enter the text for the text.

Picture 6 of How to draw a straight line, draw an arrow in Excel

To change the font and font size in the Textbox, highlight the text and select the format in the small dialog box displayed. You can also reposition the text on 2 ends.

Picture 7 of How to draw a straight line, draw an arrow in Excel

Step 7:

Next, remove the border and background for the Textbox, right-click on the Textbox and choose Format Shapes .

Picture 8 of How to draw a straight line, draw an arrow in Excel

Step 8:

Display the new interface, in the Line Color section, click No Line .

Picture 9 of How to draw a straight line, draw an arrow in Excel

Next, click the Fill button and select No Fill .

Picture 10 of How to draw a straight line, draw an arrow in Excel

Then continue to create the Textbox with the remaining end and name it B to get the straight line AB as shown.

Picture 11 of How to draw a straight line, draw an arrow in Excel

Step 9:

2 ends will disappear when you click outside the content. To create a straight line that blocks the start and end points, click on the Shapes item to select the Oval ellipse to add the two end points for the line.

Picture 12 of How to draw a straight line, draw an arrow in Excel

We will get the ellipse as shown below. The next thing is to pull the frame to make a circle and move to the top of the line to create a sucking point.

Picture 13 of How to draw a straight line, draw an arrow in Excel

Step 10:

So you get 1 point of sucking like the picture. Click Format and edit the color for the tip point at Shape Fill and Shape Outline .

Picture 14 of How to draw a straight line, draw an arrow in Excel

Create the last point of the sucking point and get the line AB as shown.

Picture 15 of How to draw a straight line, draw an arrow in Excel

Step 11:

To move straight lines and objects in the line, users need to group the objects in the line into a common object.

Hold down the Shift key and click on the objects in the picture. Then right-click on any object that selects Group and then select Group to group them.

Picture 16 of How to draw a straight line, draw an arrow in Excel

When the team succeeds, there will be a frame around the line.

Picture 17 of How to draw a straight line, draw an arrow in Excel

Thus the user can move the segment without changing the position of the objects in the image.

Picture 18 of How to draw a straight line, draw an arrow in Excel

2. Draw arrows in Excel

The way to draw arrows in Excel is similar to when you draw lines in Excel.

Step 1:

In the Shapes section select Line Arrow and then press and hold the left mouse button, then drag to get a straight arrow.

Picture 19 of How to draw a straight line, draw an arrow in Excel

Step 2:

Then change the color, the thickness for the arrow as the straight line.

Picture 20 of How to draw a straight line, draw an arrow in Excel

Next use the Textbox to add the start and end points for the arrow. Add a tip at the arrowhead with an ellipse. Finally, you will get the AB arrow as shown. Group objects to be able to move within the content.

Picture 21 of How to draw a straight line, draw an arrow in Excel

Step 3:

You can also draw a line with two arrowheads or a folded arrow in the Line section. Block Arrows is often used to create circle arrows in mind maps in Excel.

Picture 22 of How to draw a straight line, draw an arrow in Excel

Above is how to draw straight lines, lines and vector arrows on Excel. We will use the Shape drawing tool in Excel, then add the start and end points and group the objects to be able to move within the content, without disturbing the position of the objects.

I wish you all success!

How to Draw a Straight Line in Microsoft Excel

Source: https://tipsmake.com/how-to-draw-a-straight-line-draw-an-arrow-in-excel

0 Response to "How to Draw a Straight Line in Microsoft Excel"

Enregistrer un commentaire

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel