To insert shapes in Google Sheets, go to Insert > Drawing, click the Shape button in the drawing toolbar, pick a shape, and drag on the canvas to draw it. Then click Save and close. The shape appears over your sheet, where you can move and resize it.
Shapes float above the cells rather than sitting inside them, which is useful for callouts, arrows, labels, and clickable buttons.
Quick Answer
Insert > Drawing > Shape > choose a shape > drag to draw > Save and close.
How to Add a Shape
- Open the spreadsheet and click Insert > Drawing.
- Click the Shape icon (a circle over a square) and choose Shapes, Arrows, Callouts, or Equation.
- Click a shape, then drag on the grid to draw it. Hold Shift while dragging to keep a perfect circle or square.
- Use the toolbar to set the fill color, border color, border weight, and border style.
- Double-click the shape to type text inside it.
- Click Save and close.
Move, Resize, or Edit the Shape
- Move: Click the shape and drag it anywhere on the sheet.
- Resize: Drag the blue corner handles.
- Edit: Double-click the shape, or click it and choose the three-dot menu > Edit, to reopen the Drawing window.
- Delete: Click the shape and press Delete.
What You Can Insert From the Drawing Tool
| Tool | Use it for |
|---|---|
| Shapes | Boxes, circles, stars, highlight areas |
| Arrows | Pointing to important cells |
| Callouts | Speech-bubble notes |
| Line tool | Straight lines, curves, connectors |
| Text box (T icon) | Free-floating labels |
| Image | Logos or icons combined with shapes |
Turn a Shape Into a Button
Click the shape, open the three-dot menu, and choose Assign script. Enter the name of an Apps Script function, and clicking the shape will run it. This is how people make “Clear form” or “Add row” buttons.
Limitations
- Shapes can’t be placed inside a single cell; they always float over the grid.
- Shapes don’t move with sorting or filtering, so keep them away from data you rearrange.
- The mobile apps can view drawings but have limited editing. Create and edit them on a computer.
If you want shapes to stay visible while scrolling, put them near a frozen area; see how to freeze or lock a column. To draw attention to results instead, filter columns to show only what matters.
Working in a document instead? Here’s how to insert shapes in Google Docs.
Troubleshooting
- Insert > Drawing is grayed out: You have view-only or comment access. Ask the owner for edit access.
- The shape covers data: Drag it aside or shrink it. Drawings can’t be sent behind cells.
- Text inside the shape is cut off: Reopen the drawing and make the shape larger or the font smaller.
Frequently Asked Questions
Is there a draw tool in Google Sheets?
Yes. Insert > Drawing opens a drawing canvas with shapes, lines, text boxes, and images.
Can I copy a shape from Google Docs or Slides?
Yes. Copy it there and paste it into the Drawing window in Sheets.
Can I make a shape transparent?
Yes. In the Drawing window, choose Fill color > Transparent, or use Custom to lower the opacity. The same idea works for pictures in Docs; see how to make a picture more transparent in Google Docs.
Summary
- Click Insert > Drawing.
- Choose Shape and draw it on the canvas.
- Style it and add text.
- Save and close, then position it on the sheet.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.