Quick Navigation

IMAGE Function

Excel for Microsoft 365, Excel 2021, Excel 2019

Summary

The IMAGE function embeds images directly into Excel cells from web URLs, enabling dynamic visual data representation. Perfect for product catalogs, employee directories, inventory lists, and educational materials where visual context enhances data understanding.

Syntax

=IMAGE(source, [alt_text], [sizing], [height], [width])

Parameters

Parameter	Type	Required	Description
source	`string`	Yes	Required HTTPS URL pointing to supported image format
alt_text	`string`	No	Optional accessibility description
sizing	`number`	No	Optional sizing mode: 0(fit), 1(fill), 2(original), 3(custom)
height	`number`	No	Optional custom height in pixels
width	`number`	No	Optional custom width in pixels

Using the IMAGE Function

IMAGE revolutionizes Excel visualization by embedding web images directly into spreadsheet cells. Images become part of the data structure, moving with sorting, filtering, and table operations while maintaining professional formatting control.

Common IMAGE Examples

Basic Image with Alt Text

=IMAGE("https://example.com/image.jpg", "Product Photo")

Displays image with accessibility description

Fit Image to Cell

=IMAGE(A1, B1, 0)

Fits cylinder image to cell maintaining aspect ratio

Fill Cell Completely

=IMAGE(A2, B2, 1)

Fills pyramid image across entire cell

Custom Dimensions

=IMAGE(A3, B3, 3, 100, 200)

Custom sized pyramid (100px height, 200px width)

Frequently Asked Questions

BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP (WEBP unsupported on Web/Android)

Right-click image in browser, Copy image link, paste to cell, then reference that cell in IMAGE

Check HTTPS protocol, supported format, internet connection, and external content permissions

Common Errors and Solutions

#VALUE!

Cause: Unsupported format, non-string source/alt_text, invalid sizing (not 0-3), sizing=3 with blank/zero height/width

Solution: Verify URL format, image type, sizing value 0-3, provide valid dimensions for sizing=3

#CONNECT!

Cause: Internet connection issues or server problems

Solution: Check internet connection and try again

#BLOCKED!

Cause: Security settings blocking external content

Solution: Enable linked data types in Trust Center or workbook banner

Notes

Requires HTTPS URLs only
Images move with sorting/filtering
WEBP unsupported on Excel Web/Android
Authentication-required URLs won't render
255 character URL limit (use cell reference for longer URLs)
Adjust row height/column width for best display

Compatibility

Available in: Excel for Microsoft 365, Excel 2021, Excel 2019

Not available in: Excel 2016 and earlier, Excel for Web (limited WEBP), Excel Android (limited WEBP)

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel for Microsoft 365, Excel 2021, Excel 2019