Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

NEW! Insert Image into Google Sheets

google sheets insert image in cell

NEW! Insert Image into Google Sheets

Insert image in cell

Insert Image Into a Cell

It used to be that when you inserted an image into a Google Sheets spreadsheet it would float on top of the spreadsheet, not within the cell. To insert an image into the cell you would need the image URL from where the image was hosted and use the formula =IMAGE(“URL”). NO MORE!

Insert Menu

You can now use the Insert menu and when choosing Image you have a pop out tray of 2 options. “Image in cell” or “Image over cells.”

Insert menu insert image in cell

Upload Your Image

This gives you the option to UPLOAD your image. No more needing to obtain the image URL first.

Image upload box

Oh My That is Small

The image will by default fit in the cell.

Look how small that inserted image is

Increase the cell width and height to make the image larger.

Increased cell height and width

Merge Cells

Another trick for making your image not quite so small is to merge a bunch of cells together to give yourself room for the image. The image still fits the cell, but now your cell is HUGE!

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 »

3 thoughts on “NEW! Insert Image into Google Sheets

  1. I am attempting to make this work with conditional formatting in a cell so that when a student enters a correct or incorrect response, the image appears in the cell to verify or indicate another attempt.

  2. Great post thank you. I love Google Sheets but to be fair conditional formatting is still an playing catch-up. Soon though. What I like about this is you can insert company logos into cells and it looks cool as just tried it. Cheers Stacey

Leave a Reply

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

%d