How to draw straight lines and arrows in Excel - Draw shapes in Excel

Below are detailed instructions for drawing straight lines and arrows in Excel.

Instructions for drawing arrows in Excel

Step 1:

We click Insert then click Shapes to display the shapes in Excel.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 1

Step 2:

In the Lines section, find the arrow you want to use in Excel , a 1-way arrow or a 2-way arrow to insert into the content.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 2

Step 3:

Right -click on the drawn arrow in Excel and select Format Shape displayed in the list.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 3

Step 4:

Displayed on the right edge of the interface are options to change the drawing arrow interface in Excel.

1. Color: Adjust the color of the arrow.
2. Transparency: Adjust the opacity of the arrow.
3. Width: Thickness for the arrow.
4. Compound type: Create a style with multiple lines
5. Dash type: Arrow type.
6. Begin Arrow type: Edit the shape at the tip of the arrow.
7. Begin Arrow size: Adjust the size of the arrowhead
8. End Arrow type: Edit the shape at the end of the arrow.
9. End Arrow size: Adjust the size of the end of the arrow.

We will click on each item to change the display interface for the arrow in Excel.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 4

Step 5:

To write text on the arrow , click on the Text Box in the Insert section to write.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 5

We will draw a frame at the position where we want to write the text in the arrow. Next, enter content into the frame and then right-click and select Format Shape .

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 6

Step 6:

Continue to click No Line in the Line section to remove the border.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 7

At Fill , select No fill to remove the background in the Textbox frame.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 8

As a result, you have an arrow with the content displayed as shown below. We can adjust the content display position to match the arrow.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 9

Step 7:

To make it easier to adjust the position of the arrow, press the Shift key, then click on the arrow and text, then right-click and select Group to group the objects into 1. So when you move, the arrow will move. and writing.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 10

Instructions for drawing straight lines in Excel

Step 1:

In Excel content, click on the Insert tab and then click on the Illustrations group . Select the Shapes section to represent drawings in Excel. Here in the Line section , users click on the first line.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 11

Step 2:

Click in a cell and then drag the mouse to the right to create a straight line. When you release the mouse, you will see 2 endpoints at both ends of the line. Note that while drawing, hold down the Shift key so that the drawing line does not break.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 12

Step 3:

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

When hovering over the thickness size, it will be applied immediately on the line for the user to know.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 13

Step 4:

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 14

Step 5:

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 15

Step 6:

Click and hold the mouse in the direction you want to create the Textbox, which here are the two starting points of the line, enter content for the text.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 16

To change the font and font size in the Textbox, highlight the text and select the formatting style in the small dialog box that appears. You can also re-adjust the position of the text on the two ends.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 17

Step 7:

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 18

Step 8:

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 19

Next to the Fill section, click No Fill .

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 20

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 21

Step 9:

The 2 tips will disappear when you click outside the content. To create a line segment blocking the start and end points, click on Shapes and select the Oval ellipse to add 2 endpoints to the line.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 22

We will get an ellipse like below. The next thing is to stretch the frame to form a circle and move it to the beginning of the line to create the endpoint.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 23

Step 10:

So you will get 1 sucking point as shown. Click Format and then edit the color for the endpoint at Shape Fill and Shape Outline .

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 24

Create the remaining endpoints and get a line segment AB as shown.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 25

Step 11:

To move the line segment and the objects in the line, the user needs to group the objects in the line into a common object.

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

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 26

When the group is successful, there will be a border surrounding the line.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 27

Thus, users can move the line segment without changing the position of objects in the image.

How to draw straight lines and arrows in Excel - Draw shapes in Excel Picture 28

Micah Soto

Update 04 April 2024