How to Draw on Google Sheets (Easiest Way in 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.

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.

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.