Join our mailing list to receive the latest news and updates from our team.

<p>Thanks for signing up! :)</p>

read more.mapouter{overflow:hidden;height:500px;width:600px;}.gmap_canvas {background:none!important;height:500px;width:600px;}
Home / Google / How to Insert a Drawing Into a Google Spreadsheet

How to Insert a Drawing Into a Google Spreadsheet

Posted on

You may think that Google Sheets has no need for Google Drawings in its territory. But did you know that you can easily add a drawing into Google Sheets and help give the facts or figures some extra context? So, let’s explore one more creative way to use Google Drawings today.

What is Google Spreadsheet?

Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. All for free.

 What can be done with Google Spreadsheets?
Create, edit and collaborate with others on spreadsheets from your Android phone or tablet with the Google Sheets app. With Sheets, you can:

– Create new spreadsheets or edit existing files
– Share spreadsheets and collaborate in the same spreadsheet at the same time.
– Work anywhere, anytime – even offline
– Add and respond to comments.
– Format cells, enter or sort data, view charts, insert formulas, use find/replace and more.
– Never worry about losing your work – everything is saved automatically as you type.
– Get insights, instantly, quickly insert charts and apply formatting in one tap – with Explore.
– Open, edit and save Excel files.

How to Insert a Drawing Into a Google Spreadsheet

Using a sketch or a professionally done drawing in a Google Spreadsheet can help support the data. For instance, you can use a flowchart to present the future value of an investment. Or, add a map to support some demographic data. So, launch Google Sheets.

  1. Click on Insert > Drawing from within Google Sheets.
  2. The blank canvas of Drawings gives you multiple tools to make your illustration. You can also upload an image, take a snapshot, or add it from a URL.
    Google Drawing
  3. Create your drawing with the drawing tools available on the canvas. Click the blue Save and Close button to insert the drawing in your sheet.
  4. The inserted drawing can be moved and positioned anywhere on the sheet. You can also resize the graphic by dragging the bounding handles. You can also set the text to wrap around the Drawing on all sides no matter where you drag it on the page.
    Embedded Image in Spreadsheet
  5. If you need to do edit the Drawing again, just double-click on the embedded drawing to re-open it in canvas.

Do note that separate editing permissions will apply for the spreadsheet and the drawing as both are two documents. So, when you share a Google Sheet that has a Drawing embedded, the people you share it with can only view the Drawing. Unless you give them edit rights to the Drawing as well. Then, they can also double-click on the Drawing to open and edit it.

The ability to add a drawing to a spreadsheet is very handy when you want to add a simple straight line to a sheet. Just use the canvas to draw a straight line and move it around to the right place in your documents.

Sources:
Make Use Of
Google support
Google Play

Leave a Reply

Top
%d bloggers like this: