IMAGE Function in Microsoft Excel: Syntax, Examples & Troubleshooting
Insert an Excel image from HTTPS with IMAGE. Compare fit, fill and custom dimensions, use accessible alt text and diagnose authentication, redirects and blocked-content errors.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: IMAGE places an image from an HTTPS source into a cell. It supports alt text and several sizing modes. Loading depends on the source, connection and Excel’s security policy; a formula does not guarantee that an external image will render.
Syntax and argument contract
=IMAGE(source, [alt_text], [sizing], [height], [width])
Source is required and must be an HTTPS image URL. Optional alt_text describes the image for accessibility; it is not an ordinary visible caption. Optional sizing controls layout:
| Sizing | Meaning |
|---|---|
| 0 | Fit inside the cell, preserving aspect ratio |
| 1 | Fill the cell, allowing aspect-ratio distortion |
| 2 | Keep the source’s original size, possibly exceeding cell bounds |
| 3 | Use custom pixel height and width |
The documented formats are BMP, JPG/JPEG, GIF, TIFF, PNG, ICO and WEBP, with WEBP unsupported on web and Android. The source may not require authentication; the reference says authenticated URLs will not render and redirected URLs are blocked for security reasons.
Worked example: a public Microsoft illustration
Put this direct PNG address in A2 and the alt text Microsoft cylinder illustration in B2:
https://support.microsoft.com/en-us/excel/media/excelimagecylindar.png
- Enter
=IMAGE(A2,B2,0)in C2 in a supported Excel environment where permitted external content can load. - The conditional expected visual is the source’s small cylinder illustration, fitted within the cell without changing its aspect ratio.
- Adjusting the cell size changes the available fit area; it does not change the remote source image.
The public source was retrieved on October 17, 2026 as a PNG of 122×40 pixels, without a URL redirect in that retrieval. That confirms the source artifact at that time, not successful rendering in Excel or a permanent availability guarantee. No Excel security setting was changed for the guide.
Second example: an explicit custom size
=IMAGE(A2,B2,3,80,244)
If the source loads successfully, the requested height is 80 pixels and width 244 pixels. Those dimensions are twice the source’s 40-pixel height and 122-pixel width, preserving its 3.05:1 width-to-height ratio.
=IMAGE(A2,B2,3,100,200) instead requests a 2:1 ratio, which distorts a 3.05:1 source. This geometry is independently calculated; the actual rendering is conditional and was not observed in Excel.
Microsoft describes preserving aspect ratio when only one custom dimension is supplied. Its error wording also mentions blank dimensions, so the reproducible custom-size examples deliberately specify both positive dimensions rather than relying on that ambiguity.
Advanced application: build an accessible image register
Keep the image URL, descriptive alt text and any related record identifier in separate columns. Reference the URL cell rather than embedding a long address in every formula. Microsoft’s guidance for URLs beyond the formula’s documented 255-character direct-text limit is to put the complete URL in a cell and reference it.
Do not use a page URL in place of a direct supported image URL. A sign-in page, expiring link or redirected download endpoint can fail even when a browser displays something plausible. Avoid URLs containing private credentials or sensitive query parameters; loading an image contacts its external host.
The current vendor page’s older content.office.net sample address did not succeed in the read-only source check for this guide. The example therefore uses the verified direct documentation PNG above rather than promising the old sample is live.
Troubleshooting and safeguards
Microsoft documents #VALUE! for unsupported format, nontext source or alt_text, sizing outside 0–3, invalid custom dimensions, or height/width supplied with sizing 0,1 or 2. Use explicit numeric sizing and positive custom dimensions.
#CONNECT! indicates internet/source-server issues. #BLOCKED! indicates security settings blocking access. Treat a block as a safeguard to review, not an instruction to disable security or automatically trust a remote host. If content requires permission or authentication, use an approved source or an authorized manual workflow.
The formula produces an image result rather than a numeric value. No exact visual outcome, live screenshot or native application test is claimed here.
Compatibility and verification
Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel for iPhone Excel for Android phones. Microsoft’s alphabetical catalog, checked October 17, 2026, identifies Excel 2024 as the introduction-version marker for IMAGE. This perpetual-release marker does not establish an earlier Microsoft 365 preview or rollout date. Platform restrictions remain separate. The last functioning version is unverified; no retirement is asserted.
Example verification: Expected numerical results are independently calculated; text and shape expectations follow the documented contract. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.
Related guides and source
IFERROR in Excel | ISTEXT in Excel | LEN in Excel
- Microsoft IMAGE reference, retrieved October 17, 2026.