How to Insert a Shape in Excel & Google Sheets

This tutorial shows how to insert a shape into Excel and Google Sheets.

 

insert a shape in excel 3

 

Insert Shape

In Excel, you can insert different types of shapes, such as circles, arrows, rectangles, and more.

  1. In the Ribbon, go to Insert > Shapes and select a shape you want to insert (here, the block arrow).

 

insert a shape in excel

 

  1. When the cursor becomes a black cross, position it and drag to draw the shape.

 

insert a shape in excel 2

 

This will insert the shape into the sheet.

 

insert a shape in excel 3

 

When you click on the shape, the Shape Format tab appears in the Ribbon. Here you can change the properties of the shape (size, color, font, etc.)

insert a shape in excel 4

 

Insert Shape into Google Sheets

You can also insert shapes into Google Sheets.

  1. Go to Insert > Drawing in the menu.

 

google sheets insert a shape

 

  1. In the drawing window, (1) click the Shape icon, (2) go to Shapes, and (3) choose a shape to insert.

 

google sheets insert a shape 1

 

  1. When the cursor becomes a black cross, drag it to draw the shape.

 

google sheets insert a shape 2

 

  1. When you draw the shape, various options for editing will be displayed (fonts, colors, etc.). When you are done, press Save and Close to close the Drawing window.

 

google sheets insert a shape 3

 

As you can see, the shape is inserted into the sheet.
google sheets insert a shape 4