Lookup & Reference
Excel 365
◉ 11 views
=IMAGE()
The custom width of the image in pixels.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel for iPhoneExcel for Android phones
=IMAGE(source, [alt_text], [sizing], [height], [width])
Hover argument names in the table for details.
Output typeMixed
Popularity35 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =IMAGE() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
source |
Text | Required | The URL path, using an "https" protocol, of the image file. Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and also WEBP (WEBP is unsupported on Web and Android). |
alt_text |
Text | Optional | Alternative text that describes the image for accessibility. |
sizing |
Number | Optional | Specifies the image dimensions. There are several possible values: Values: 0 = Fit the image in the cell and maintain its aspect ratio.; 1 = Fill the cell with the image and ignore its aspect ratio.; 2 = Maintain the original image size, which may exceed the cell boundary.; 3 = Customize the image size by using the height and width arguments.. |
height |
Number | Optional | The custom height of the image in pixels. |
width |
Number | Optional | The custom width of the image in pixels. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
B2 |
Cylinder |
B3 |
Pyramid |
B4 |
Pyramid |
B5 |
Cylinder |
B6 |
Pyramid |
B7 |
Pyramid |
Example 1
=IMAGE("https://support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
Example 2
=IMAGE(A2, B2, 0)
Example 3
=IMAGE(A3, B3, 1)
Example 4
=IMAGE(A2, B2, 3, 100, 200)
§ Remarks
- Be careful customizing the height and width as it may skew the aspect ratio, or the proportional relationship between the original image height and width.
- If source is a URL that requires authentication, the image doesn't render.
- If source is a URL that's redirected, it's blocked because of security concerns.
- To work around the URL limit of 255 characters, avoid copying a long URL from the browser address bar. Instead, right click the image in the browser, select Copy image link, paste the value into a cell in Excel, and then reference that cell as source. For example, if the long URL is copied to F10, create the following function call: =IMAGE(F10).
✦ Tips
- Be careful customizing the height and width as it may skew the aspect ratio, or the proportional relationship between the original image height and width.
- If source is a URL that requires authentication, the image doesn't render.
- If source is a URL that's redirected, it's blocked because of security concerns.
- To work around the URL limit of 255 characters, avoid copying a long URL from the browser address bar. Instead, right click the image in the browser, select Copy image link, paste the value into a cell in Excel, and then reference that cell as source. For example, if the long URL is copied to F10, create the following function call: =IMAGE(F10).
⚠ Common Errors
#VALUE!
Excel returns a #VALUE! error under the following circumstances: For more information, see How to correct a #VALUE! error.
Fix: Check the image address and the third input
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!