How to Insert Shapes in Google Sheets: A Step-by-Step Guide

how to insert shapes in google sheets

Google Sheets is a powerful tool for managing data, but did you know you can also insert shapes to enhance your spreadsheets? Adding shapes, like arrows, circles, and boxes, can help you visually organize and highlight important data. This article will walk you through the process of inserting shapes in Google Sheets, providing a step-by-step guide to make your spreadsheets not just functional, but also visually appealing.

How to Insert Shapes in Google Sheets

Inserting shapes in Google Sheets can make your data pop and help you visually communicate information. Follow these steps to learn how to add shapes to your spreadsheets.

Step 1: Open Google Sheets

Open your Google Sheets document where you want to insert the shape.

Make sure you have the sheet open where you’d like to add the shape. You can either start a new sheet or use an existing one.

Step 2: Insert a Drawing

Go to the "Insert" menu at the top of the page and select "Drawing."

The "Drawing" option allows you to create and customize shapes that you can then insert into your sheet. A new window will pop up where you can create your drawing.

Step 3: Select the Shape Tool

In the drawing window, click on the shape icon to see a variety of shapes to choose from.

You’ll find different categories of shapes, including arrows, callouts, and equation symbols. Pick the shape that best suits your needs.

Step 4: Draw Your Shape

Click and drag in the drawing window to create your shape.

You can adjust the size and proportions of the shape by clicking and dragging the corners or sides. Release the mouse button when you’re happy with the size.

Step 5: Customize Your Shape

Use the toolbar to change the fill color, border color, and other style options.

You can make your shape stand out by customizing its appearance. Change the fill color, add a border, or adjust the transparency to fit your design needs.

Step 6: Save and Insert

Click "Save and Close" to insert the shape into your Google Sheet.

After customizing your shape, click "Save and Close." The shape will be added to your spreadsheet, and you can move and resize it as needed.

Once you’ve inserted your shape, you can drag it around your sheet to position it exactly where you want. This makes it easier to highlight key data or create a visual layout.

Tips for Inserting Shapes in Google Sheets

  • Use Color Wisely: Choose colors that contrast well with your data to make the shapes stand out.
  • Stick to Simple Shapes: Simple shapes like circles and rectangles can be more effective than complex ones.
  • Layer Shapes: Combine multiple shapes to create more complex visuals.
  • Add Text to Shapes: You can add text to shapes for labels or additional information.
  • Keep it Neat: Don’t overload your sheet with too many shapes; it can make the data hard to read.

Frequently Asked Questions

Can I insert images in addition to shapes?

Yes, you can insert images by using the "Insert" menu and selecting "Image." You can upload images from your computer or the web.

Can I edit shapes after inserting them?

Yes, you can double-click on the shape to reopen the drawing tool and make changes.

Is it possible to copy shapes to another sheet?

Absolutely! Just click on the shape, copy (Ctrl+C), and paste (Ctrl+V) it into the new sheet.

Can I group multiple shapes together?

Yes, you can select multiple shapes by holding down the Shift key and clicking each shape, then right-click to select "Group."

Can shapes be linked to data?

Shapes themselves can’t be directly linked to data, but you can place them near relevant data points to create a visual association.


  1. Open Google Sheets.
  2. Insert a Drawing.
  3. Select the Shape Tool.
  4. Draw Your Shape.
  5. Customize Your Shape.
  6. Save and Insert.


Inserting shapes in Google Sheets is a great way to add a visual element to your data, making it easier to understand and more engaging. By following the steps outlined in this guide, you can turn a plain spreadsheet into a visually appealing document that highlights key information and improves overall readability. Whether you’re a student, a teacher, or a professional, mastering the art of adding shapes to your Google Sheets can elevate your data presentation skills. So go ahead, give it a try, and see how these visual tools can transform your work!

For further reading, check out Google’s own guide on using the drawing tool for more advanced features. And if you have any questions or tips of your own, feel free to leave a comment below. Happy spreadsheet designing!