In this article:

How to Draw on Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Draw on Google Sheets

Follow the steps below to draw in Google Sheets. 

1. Highlight Cells to Create Your Drawing Canvas

Click and drag your mouse to highlight the cells that will serve as your drawing area. This is your canvas.

how to draw on google sheets

2. Color Cells with Background Fill for Basic Drawing

To draw, you'll use the background color of cells. Click on the "Fill color" icon in the toolbar and select a color to start coloring your selected cells.

how to draw in google sheets

3. Add Detail with Custom Borders on Selected Cells

For adding details, utilize cell borders. Select the cells where you want to add borders, click on the "Borders" icon in the toolbar, and choose the desired border style.

4. Merge Cells Together for Creating Larger Color Blocks

To create larger blocks of color, you can merge cells. Select the cells to merge, click "Format > Merge Cells > Merge all from the context menu.

5. Apply Conditional Formatting for Advanced Patterns and Designs

For more complex designs, conditional formatting is useful. Select the cells, go to Format > Conditional formatting.

Set up rules to automatically change colors based on the cells' contents.

6. Insert Text and Shapes Using the Drawing Tool

To add text or shapes, use the drawing tool. Go to Insert > Drawing.

In the drawing editor, you can add shapes, lines, and text. Click "Save and Close" when done to insert into your sheet.

7. Resize Cells to Fit Drawing Elements Precisely

Adjust the cell sizes if needed to better fit your drawing elements. Hover over the line between row or column headers and drag to resize.

We hope that you now have a better understanding of how to draw on Google Sheets. If you enjoyed this article, you might also like our article on how to set up ternary in Google Sheets or our article on how to insert footnotes in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->