Excel IMAGE Function in 2026: Display Live Images Directly Inside Spreadsheet Cells

Excel has always been able to display images — but they floated above cells, refused to move when you sorted data, and became a nightmare to manage in larger workbooks. The IMAGE function changes everything. Introduced in Microsoft 365 and now fully mature in 2026, IMAGE() embeds pictures directly into cells, so they move, resize, filter, and sort along with your data just like any other cell value.

This guide covers the IMAGE function syntax, practical use cases, how to combine it with other Excel functions, and real-world applications that will transform how you build product catalogs, employee directories, and visual dashboards.

How the IMAGE Function Works

The IMAGE function fetches an image from a URL and displays it within the cell. The basic syntax is:

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

The source parameter is a URL string pointing to an image file (JPG, PNG, GIF, BMP, WEBP, and SVG are supported). The sizing parameter controls how the image fits in the cell:

0 = Fit the image in the cell while preserving aspect ratio (default).

1 = Fill the cell entirely, cropping if necessary.

2 = Stretch the image to fill the cell exactly (ignores aspect ratio).

3 = Use the height and width parameters you specify in pixels.

Your First IMAGE Formula

Here is a simple example. If cell A2 contains the URL https://example.com/product.jpg, you can display that product image in cell B2 with:

=IMAGE(A2) — displays the image from the URL in A2, fitting it to the cell size.

=IMAGE(A2, "Product photo", 0) — same but with descriptive alt text for accessibility.

=IMAGE(A2, "Photo", 3, 80, 80) — displays a fixed 80×80 pixel thumbnail.

To see the image, set the row height to at least 60-80 pixels (right-click the row number > Row Height) and the column to an appropriate width. Excel will render the image within those cell boundaries.

Building a Product Catalog with IMAGE

The IMAGE function's most compelling use case is dynamic product catalogs. When your product images are hosted on a web server or SharePoint document library, you can build a fully visual catalog that updates automatically when you change a URL.

Set up a table with columns: Product ID, Product Name, Price, Image URL, Product Image.

In the Product Image column, enter =IMAGE([@[Image URL]], [@[Product Name]], 0).

Set all rows in the Product Image column to the same row height (e.g., 100px).

Now use AutoFilter, sort by Price, or filter by category — the images move with their rows.

Customers or colleagues viewing the workbook see a visual catalog they can filter and sort interactively.

Combining IMAGE with XLOOKUP for Dynamic Lookups

IMAGE becomes dramatically more powerful when combined with other Excel functions. A classic use case is a visual lookup: type a product name and display its image automatically.

=IMAGE(XLOOKUP(E2, A2:A50, C2:C50)) — looks up the URL for the value in E2 and displays the image.

=IMAGE(INDEX(C2:C50, MATCH(E2, A2:A50, 0))) — the same logic using INDEX/MATCH for older compatibility.

Combine with FILTER: =IMAGE(INDEX(FILTER(C2:C50, B2:B50="Available"), 1)) — shows the first available product image.

Employee Directory with Photos

HR teams love the IMAGE function for building visual employee directories. Store headshot URLs in a SharePoint list exported to Excel, add an IMAGE column, and instantly transform a plain spreadsheet into a directory with photos. Combined with conditional formatting and FILTER, you can create an interactive org chart alternative entirely within Excel.

For enterprise deployments, host images on SharePoint using a consistent URL pattern like https://yourcompany.sharepoint.com/teams/HR/Photos/{EmployeeID}.jpg — then generate the IMAGE formula dynamically using string concatenation: =IMAGE("https://yourcompany.sharepoint.com/teams/HR/Photos/"&A2&".jpg")

IMAGE in Dashboards

Excel dashboards built with IMAGE can display company logos that update based on dropdown selections, show country flags next to regional data, display product thumbnails in summary reports, and include sparkline-adjacent visual indicators using small icon images.

Pair IMAGE with Excel's SWITCH or IF function to display different images based on data conditions: =IMAGE(IF(B2>100, "https://example.com/green-arrow.png", "https://example.com/red-arrow.png")) — shows a directional arrow icon based on whether a value exceeds a threshold.

Limitations to Know

IMAGE requires an internet connection to load images at formula calculation time — offline workbooks will show placeholder boxes.

Images from URLs that require authentication (login-protected) will not load unless you use SharePoint URLs with the user's M365 session.

IMAGE is not supported in Excel for Mac versions prior to 16.69 or in Excel Online for some tenants — test your audience's Excel version before deployment.

Very large image files (over 5MB) may slow recalculation — optimize images before hosting them.

The function cannot load images from local file paths — only web URLs and SharePoint URLs are supported.

Practical Tips and Tricks

Use a named range or table for your URL column so IMAGE formulas update automatically when new rows are added.

Add error handling with IFERROR: =IFERROR(IMAGE(A2), "Image unavailable") — shows text if the URL is broken.

For SharePoint-hosted images, use the file's direct download URL (the link in the 'Copy link' dialog with ?download=1 appended) for reliable rendering.

Combine IMAGE with conditional formatting to highlight rows — the formatting applies to the cell, and the image still displays inside it.

Test IMAGE in a small table first before building large catalogs — confirm the URL format works in your environment.

Conclusion

The Excel IMAGE function solves one of the longest-standing frustrations with spreadsheet design: images that behave like data. In 2026, with IMAGE fully integrated into Microsoft 365 Excel, there is no reason to keep floating images above your cells when they can live inside them, respond to sorting and filtering, and build into your formulas like any other value.

Start with a small product list or employee directory today and experience the difference. Find more Excel function guides at officelearner.net.