See all How-To Articles

How to Draw / Create Lines in Excel & Google Sheets

In this tutorial, you will learn how to draw lines in Excel and Google Sheets.

 

draw lines 1

 

Draw Lines in Excel

Say you have shapes in your sheet that you want to connect with lines.

1. To draw lines, in the Ribbon, click on Insert > Shapes > Lines.

 

draw lines 2

 

2. After that, the cursor will change to a plus sign and you can start to draw lines.

 

draw lines 3

 

As a result, the lines are added to your sheet.

 

draw lines 4

 

Change the Line Weight

If you want, you can change the properties of the lines, such as color, weight, and style. To change the weight of the lines, follow these steps:

First, select the lines for which you want to change the color. Then, in the Ribbon, click on Shape Format > Shape Outline > Weight. Finally, choose the desired line weight.

 

draw lines 9

 

As a result, the weight of the selected lines is changed.

 

draw lines 11

 

Change the Line Color

To change the color of the lines, select the lines you want to change. Then, in the Ribbon, click on the Shape Format > Shape Outline. Choose a color.

 

draw lines 10

 

As a result, the color of the selected lines is changed.

 

draw lines 7

 

Draw Lines in Google Sheets

1. To draw lines in Google Sheet, in the Toolbar, click on the Insert and in the drop-down menu, choose Drawing.

 

draw lines 12

 

2. The Drawing window will open. In the menu, click on the Line icon and choose the line type.

 

draw lines 13

 

3. Use the cursor to draw your lines.

 

draw lines 18

 

Change the Weight of the Lines in Google Sheet

You can also change the properties of the lines, such as color, style, and weight. To change the weight of the lines, follow these steps:

1. Select the lines you want to change.

2. Then in the Toolbar, click on the Weight icon.

3. From the drop-down menu, choose the desired weight of the line.

 

draw lines 15

 

As a result, the weight of the selected lines is changed.

 

draw lines 17