How to Draw / Create Lines in Excel & Google Sheets

This tutorial demonstrates 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

 

  1. When the cursor changes to a plus sign, 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 lines’ properties, 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 Sheets, in the Menu, click on the Insert, and in the drop-down menu, choose Drawing.

 

draw lines 12

 

  1. The Drawing window opens. In the menu, click on the Line icon and choose the line type.

 

draw lines 13

 

  1. Use the cursor to draw your lines.

 

draw lines 18

 

Change Line Weight in Google Sheets

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