Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Embed an Image

And an image to a spreadsheet

Google Sheets: Embed an Image

And an image to a spreadsheet

Embed an Image into a Spreadsheet

You can insert an image onto a Google Sheets spreadsheet by using the Insert menu, but what if you want the image in a cell instead? This is a little trickier.

Image URL

The first thing you need is an image URL. This means it needs to be uploaded to the Internet somewhere, and that is NOT Google Drive. The link from Google Drive is NOT an image link, it is a file link. If the image is uploaded to a website you can right click and choose “Copy Image Address.”
Copy Image Address

Google Sites

Not sure how to get your picture on the Internet? Try adding it to a Google Site and publish the site. From the published site, right click on the image and choose “Copy Image Address.”
Copy image address from the Google Site page

=IMAGE()

In the spreadsheet use the formula =IMAGE(“URL”). Notice the URL is in quotations.

Example: =IMAGE(“https://render.bitstrips.com/v2/cpanel/460288e6-d9a7-4c1a-82a1-2a6f5526f5c6-ea26ef0c-2550-4b7e-96a3-9a0153566a8d-v1.png?transparent=1&palette=1”)

Width and Height

Changing the width of the column and the height of the cell changes the size of the image.
insert an image and adjust the cell size

For more information and options visit the Google Sheets help page.




5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d