Zoho Sheet IMAGE Function: Fit, Stretch and Original-Size Modes
Use the three documented image modes with a complete URL fixture, independent geometry controls and explicit loading limitations.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
IMAGE displays a remotely addressed image inside a cell. Its sizing mode controls how the image is fitted, stretched or cropped within the existing cell; Zoho explicitly says the mode does not change the cell’s size.
This is a display function, not a URL-sharing permission grant or a guarantee that every remote image format and host is supported.
Availability and verification
The official IMAGE reference was retrieved October 15, 2026. Zoho’s official release history announces IMAGE in December 2020. That establishes an announcement month, not a numbered first build. The last functioning version is unknown. Current web documentation does not establish every older, mobile or offline client’s behavior.
No native Zoho Sheet session was executed. Worked values are independent controls from complete fixtures, not screenshots or claims of live app output. Examples use the help’s semicolon formula notation; verify the actual editor’s accepted separator.
Syntax and three documented modes
IMAGE(url; [mode])
url identifies the image resource. The source’s syntax heading uses a comma, while its multi-argument examples use semicolons; the examples here follow those worked formulas.
Optional mode defaults to 1:
| Mode | Documented sizing behavior |
|---|---|
| 1 or omitted | Fit inside the cell while retaining aspect ratio |
| 2 | Fit to the cell without preserving aspect ratio |
| 3 | Keep original size; cropping may occur when the cell is smaller |
The reference does not document a fourth custom-height/custom-width mode or extra dimension arguments. Do not import another spreadsheet’s IMAGE signature.
Complete formula-input fixture
Put the following public example URL from Zoho’s reference into A2 as text:
https://images.pexels.com/photos/459225/pexels-photo-459225.jpeg?auto=compress&cs=tinysrgb&dpr=1&w=500
Use =IMAGE(A2) in B2, =IMAGE(A2;2) in C2 and =IMAGE(A2;3) in D2. The expected difference is the documented sizing mode, not a claim that the image was downloaded or displayed during this review.
The query parameters belong to that example URL. They are not IMAGE arguments, and the w=500 parameter is not treated here as independently verified intrinsic pixel metadata. Remote content can change or become inaccessible.
Independent geometry fixture: landscape image
For a separate ideal geometry control, assume a source image is exactly 300 pixels wide by 200 high, and the available cell image area is 120 by 120. These are stated synthetic dimensions, not measurements of the linked photograph or a native screenshot.
For proportional fitting, the scale factor is min(120/300,120/200) = 0.4. The resulting model dimensions are 120 by 80, leaving 40 pixels of total unused vertical space. The guide does not assume how that space is distributed by native alignment or padding.
Under mode 2’s non-proportional fit, the model dimensions are 120 by 120. Horizontal scale is 0.4, vertical scale is 0.6, and the original 1.5 width-to-height ratio becomes 1. A circle or other geometric shape in the original can appear distorted.
Independent geometry fixture: portrait image
Now assume source dimensions 200 by 300 with the same 120-by-120 area. Proportional scale is again 0.4, producing 80 by 120 and leaving 40 pixels of total unused horizontal space.
Stretch-to-fit instead produces 120 by 120, with horizontal scale 0.6 and vertical scale 0.4. The two controls help distinguish proportional fitting from stretching without requiring a particular photographic subject.
These are mathematical sizing expectations for an ideal available image area. Actual cell borders, internal padding, alignment and rasterization were not measured in Zoho.
Advanced: original size and crop expectations
For the 300-by-200 source in a 120-by-120 area, mode 3 retains the larger intrinsic dimensions. Zoho says cropping may occur; it does not specify the exact crop origin or alignment in this entry. Do not assert which face, corner or label remains visible without checking the actual workbook.
If the image contains important labels near an edge, mode 1 is a useful proportional-fit comparison. If mode 2 is used intentionally, inspect whether stretching makes the content misleading. The function’s documented sizing choice does not resize the table cell for you.
Advanced: keep the resource address inspectable
Retain the address in its own column when building an image catalogue. A row can then be audited for the intended resource even when the visual result fails to load. Keep descriptive text in a separate field so the report still identifies the item without depending entirely on the picture.
A link to a login-protected page is not automatically a publicly retrievable image resource. Do not embed private access tokens in example addresses. The public teaching URL above contains only the reference’s ordinary image-processing parameters.
Errors and troubleshooting
Check quotes around a literal URL, the referenced address cell and the selected mode. If the image looks stretched, compare modes 1 and 2 before changing the source data. If it looks cut off, inspect mode 3 and the available cell area.
The shared help error table is generic. It does not establish exact errors for a blocked host, missing image, unsupported format, invalid mode or failed authentication. No native loading, network failure or permission test was performed, so such outcomes are not invented here.