Microsoft Excel

Excel Image Function

Chris Menard

Chris Menard

— 1 min read
Excel Image Function

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.

Excel IMAGE function

Excel IMAGE function

IMAGE Function syntax

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

IMAGE Function Arguments

  • [Required] source is the URL path of the image file, using an “https” protocol. (NOTE: Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.)
  • [Optional] alt_text is the alternative text that describes the image (for accessibility).
  • [Optional] sizing specifies the image dimensions. There are several possible 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
  • [Optional] height and width define the height and width of the image only when using sizing 3 option.

Read more