Insert images in Google Spreadsheet
This
post describes how you can insert images into any cell of your Google sheet
cells.
To
add an image to a cell, highlight the cell and click F2 to enter the formula
mode. Next, enter the formula =IMAGE (URL, mode) where URL is the public web
address of the image and mode is the default scaling of the image.
=IMAGE(“https://i.imgur.com/yHxeI5J.png”)
Google
sheet, by default, will scale the image to fit inside the area of the selected
cell but you can customize the cell by adding one more parameter to the IMAGE
function.
By
setting mode 1 (second parameter), image is fitting inside the cell =IMAGE (url,
1) and set to mode 2 image is stretching inside the cell =IMAGE (url,2) and set
to mode 3 image is inserted into the cell with its original size =IMAGE (url,3)
You
can also customize your cell by specifying height and width of the image in
pixels by setting to the mode 4.
=IMAGE
(url, 4, 70, 200)
Thank You! Please provide your value feedback on the comment section to improve my blog.
Comments
Post a Comment