---
title: The IMAGE function | Full Stack Modeller
description: Introducing Microsoft's Excel IMAGE function! Import images into Excel cells. Discover more in our Full Stack Modeller Future of Excel article.
---

[Blog ](https://www.fullstackmodeller.com/blog)

# [The IMAGE function | Full Stack Modeller](https://www.fullstackmodeller.com/blog/image-function-excel)

 Written by [Myles Arnott](https://www.fullstackmodeller.com/blog/author/myles-arnott) | Mar 3, 2023, 1:30:00 PM

Microsoft announce exciting new IMAGE function

*Announced by Microsoft on 21st February 2023*

In this latest article in our Future of Excel series, we look at the new IMAGE function.

Ever wished you could bring an image directly into a cell in your Excel spreadsheet via a formula rather than manually inserting it? Well, now you can! 

## So how does it work?

The image is imported and sized using the new IMAGE function:

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

- ***Source*****:** The URL path, using an "https" protocol, of the picture file. *Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.** *
- ***alt_text*****:** A description of the picture for accessibility. 
- ***sizing*****:** The picture dimensions. There are several possible values:  
    - 0: Fit the picture in the cell and maintain its aspect ratio. 
    - 1: Fill the cell with the picture and ignore its aspect ratio. 
    - 2: Maintain the original picture size, which may exceed the cell boundary. 
    - 3: Customize the picture size by using the *height* and *width *arguments. 
- ***height and width:** Only a*pplicable when sizing option 3 is selected, define the height and width of the picture.  

### Here's a simple example

I would like to bring the Full Stack Modeller logo below into my model.

The logo is stored here:

[https://www.fullstackmodeller.com/hubfs/Full%20Stack%20Modular%20Feature%20Images.webp](https://www.fullstackmodeller.com/hubfs/Full%20Stack%20Modular%20Feature%20Images.webp)

The formula to bring this image into my Excel spreadsheet with an Alt Text of "Full Stack Modeller" and a sizing of 200 by 300 is:

=IMAGE("https://www.fullstackmodeller.com/hubfs/Full%20Stack%20Modular%20Feature%20Images.webp", "Full Stack Modeller", 3, 200, 300)

### My thoughts

This is a very helpful new feature from Microsoft. The ability brings images straight into a workbook via a formula will undoubtedly prove useful to anyone who regularly works with images in their spreadsheets.

It is a shame that you can only bring images in from HTTPS addresses rather than from a local drive, or from within the model itself. Hopefully, this will be added to the IMAGE function in the near future.

### Release date

The feature is currently available in the 365 version of Excel.

## Our Future of Excel series

This series of articles focuses on new features recently released or soon to be released in Excel. See the announcement from the [Microsoft Tech Community](https://techcommunity.microsoft.com/t5/excel-blog/insert-pictures-in-cells-with-the-image-function/ba-p/3748692) team.

See other articles in our Future of Excel series [here](https://www.fullstackmodeller.com/blog/future-of-excel).

 

[View full post](https://www.fullstackmodeller.com/blog/image-function-excel)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Myles Arnott"
  },
  "dateModified" : "2024-09-21T16:41:55.638Z",
  "datePublished" : "2023-03-03T13:30:00Z",
  "headline" : "The IMAGE function - Insert Pictures in Cells",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1260,
    "url" : "https://www.fullstackmodeller.com/hubfs/The%20IMAGE%20function%20-%20Insert%20Pictures%20in%20Cells.png",
    "width" : 2240
  },
  "mainEntityOfPage" : "https://www.fullstackmodeller.com/blog/image-function-excel",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```