I just found out that you can insert an image in google spreadsheet not just in a floating image, but inside of a cell, so you can call it back in other cell.
First, you should have an url for your image. How? I put my image in picasa, it connects with google, and share it to get the url. This URL must have the image extention, such as .jpg, or .png, or ... if you have a website, you can put it there too ... so you can have the link.
... and then, choose the mode for the image.
mode 1, is the default, so if you don't write it, it automatically use this mode.
mode 2, will streatch the image to fit the cell
mode 3, will show the original size.
mode 4, you can custom the size as you wish.
with this function, you can call the image anywhere you want in the spreadsheet. even in pivot too ....
Just try in my spreadsheet, you'll get the idea.
Source: Google Support - Image
Check it out here.
The function is: =IMAGE(url,[mode],[height],[width]) (3 last part are optional)
First, you should have an url for your image. How? I put my image in picasa, it connects with google, and share it to get the url. This URL must have the image extention, such as .jpg, or .png, or ... if you have a website, you can put it there too ... so you can have the link.
... and then, choose the mode for the image.
mode 1, is the default, so if you don't write it, it automatically use this mode.
mode 2, will streatch the image to fit the cell
mode 3, will show the original size.
mode 4, you can custom the size as you wish.
with this function, you can call the image anywhere you want in the spreadsheet. even in pivot too ....
Just try in my spreadsheet, you'll get the idea.
Source: Google Support - Image
Komentar
Posting Komentar