IMAGE
Inserts the given image into the specified cell.
Syntax
IMAGE(url, [mode])
url: The url of the image to insert. E.g. " https://images.pexels.com/photos/459225/pexels-photo-459225.jpeg?auto=compress&cs=tinysrgb&dpr=1&w=500"
|
Supported IMAGE_mode |
|
1 - fits the image into the cell while maintaining the aspect ratio 2 - fits the image into the cell while ignoring the aspect ratio 3 - retains the original size of image; may get cropped based on cell size |
Examples
|
Formula |
|
=IMAGE(C2) |
|
=IMAGE(C3;2) |
|
=IMAGE(C4;3) |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Insert an image
To insert an image: Tap the cell in which you wish to insert the image. Tap Image from the Insert menu. From the drop-down, select either Image In Cell or Image Over Cells. Select whether you wish to upload the image from Photo Library or Camera. ...Insert an image
To insert an image: Select the cell in which you want to insert the image. Under the Insert menu, select Image . From the dropdown, select either Image In Cell or Image Over Cells > Upload from Mac. Select the desired image and click Open.Insert an image into the spreadsheet
To insert an image: Go to the icon Under the Insert menu, choose Image. Choose Image In Cell to insert the image within a cell, and Image Over Cells to insert it over the grid. You can choose an image from your device gallery or WorkDrive library, or ...Convert an image to a spreadsheet
The Data from Picture feature allows you to quickly extract text and numerical data from images and convert them into an editable spreadsheet. Whether you have a printed table or a screenshot of a dataset, this feature uses advanced OCR (Optical ...Delete an image
To delete an image: 1. Right click on the image and select Delete. Alternatively, you can click on the image and hit Delete. 2. You can also use the Advance Options menu from the top right corner of the image.