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!

FREE!

Go Slow Online Workshop
Google Forms Workshop

Click Here to Register

WP Twitter Auto Publish Powered By : XYZScripts.com
%d bloggers like this: