Embedded Files
You can bring any web image to your cells in Google Sheets. This is really useful when you create a catalogue or product list and show the image also which is interactive an easy to understand.
How to use?
How to use?
SYNTAX: =IMAGE(url,[mode],[height],[witdth])
URL is the public web address of the image
[mode] – Optional specification of how to size the image.
1 – Resize to fit the cell. Maintains the same aspect ratio so the image does not look distorted.
2 – Makes the image fit the entire cell. Will disregard the aspect ratio.
3 – Maintains original size even it gets cropped.
4 – Custom
[height] – If you specify 4 for custom mode, use this for the height.
[width] – If you specify 4 for custom mode, use this for the width.
PRACTICE SHEET
The below sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse