Wauvel

Excel like a finance pro.

← The library

Web function

IMAGE

Places an image from a URL into a cell.

OccasionalDifficulty 1200 · ProficientUsage rank #189 of 520
Practice · 3 questions →

When to use it

Places an image from a URL inside a cell, with optional alt text and sizing. Product thumbnails and logos in tables.

The shape of it

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

Worked examples

  • Fit to cell

    =IMAGE("https://example.com/logo.png") → the image, fit to the cell

    Default sizing keeps the aspect ratio within the cell.

  • Fill the cell

    =IMAGE(A2,"Product photo",1) → the image, filling the cell

    Sizing 1 fills the cell and may crop.

  • Custom size

    =IMAGE(A2,,3,60,60) → a 60 by 60 image

    Sizing 3 with a custom height and width.

Worth knowing

  • Supported formats: BMP, JPG, GIF, TIFF, PNG, ICO, WEBP.
  • Row height controls the size in mode 0.
  • Introduced in Microsoft 365 (2022).

Where it goes wrong

  • #VALUE! for an unreachable URL or unsupported format.
  • Images do not print in some older builds.

Related

STOCKHISTORYWEBSERVICEFILTERXMLENCODEURL

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.