Working with Google Sheets

3 Likes Comment

How to insert a image into a cell in google sheet?
Just use the formula
IMAGE
Inserts an image into a cell.

Sample Usage
IMAGE(“https://www.google.com/images/srpr/logo3w.png”)

IMAGE(A2,2)

IMAGE(A2,4,120,200)

Syntax
IMAGE(url, [mode], [height], [width])

url – The URL of the image, including protocol (e.g. http://).

The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
mode – [ OPTIONAL – 1 by default ] – The sizing mode for the image

1 resizes the image to fit inside the cell, maintaining aspect ratio.

2 stretches or compresses the image to fit inside the cell, ignoring aspect ratio.

3 leaves the image at original size, which may cause cropping.

4 allows the specification of a custom size.

Note that no mode causes the cell to be resized to fit the image.

height – [ OPTIONAL ] – The height of the image in pixels. mode must be set to 4 in order to set a custom height.

width – [ OPTIONAL ] – The width of the image in pixels. mode must be set to 4 in order to set a custom width.

Ext Tips:
It’s so pretty with a cloudinary images working with google sheets. I mean you just upload your images to cloudinary, then insert them into a sheet.

You might like

About the Author: Toc Xoan

This guy likes taking photos, hunting cheap tours, exploring the unique culture of every cities of Vietnam. Contact: [email protected]