Use an Excel formula to insert pictures into cells with the IMAGE function

Microsoft recently announced the rollout of the new IMAGE function. It enables us to write a formula that inserts an image directly into a cell. This opens up many new interesting possibilities.


We have been able to insert images into Excel worksheets for a long time. Historically, these images float above the grid in the drawing layer. Images have been independent of the grid. For many situations, this works great. However, when trying to incorporate pictures dynamically, this method was cumbersome.

Recently, Microsoft announced the availability of a new function, IMAGE. With it, we are able to write a formula that displays a picture in a cell. Since the path to the image is stored in the formula, we are able to easily change the image path and filename dynamically using the power of Excel formulas.

Note: currently, the image must be available via an https URL, meaning, stored on the internet. Currently, the IMAGE function is available to Insiders on the Insiders update channel. Perpetual licenses of Excel won’t receive this enhancement retroactively. Office 365 users should receive the update based on their update channel. Current file formats include PNG, JPG, GIF and other common image types.


The basic function syntax is:

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


  • source – the URL of the image file
  • [alt_text] – optional alternative text provided for accessibility
  • [sizing] – optional image dimensions (fit image, fill cell, original size, custom size)
  • [height] – optional custom height
  • [width] – optional custom width

For example, if the image we wanted to pull into the cell was stored at, we could pull it into a cell with the following formula:


Since this is a formula, we are free to construct the function arguments dynamically, based on other cell values or formulas. For example, we can use concatenation or lookups.


If all of the files are stored in the same place, we can store the file path in a cell and then combine that with the image filename.

For example, we could store the path ( in A1. And if the filename was stored in B1, we could combine them like this:


Alternatively, we could store the filenames in a table column. If the filename column was named PicFile, we could write the following formula in a new table column to retrieve all of the images:


Hit Enter and bam:


Using a formula with the IMAGE function also enables us to use lookups to construct the function arguments dynamically. For example, we could allow the user to select a Model from a data validation drop-down, and then do a lookup to return the corresponding filename. If the path was stored in A1, the model input cell was C2, and the filename was in the third table column, we could use a formula like this:


That way, when a user selects a specific Model, Excel dynamically retrieves the correct image along with any additional information we may want to present:

As you can see, the IMAGE function opens up many interesting possibilities 🙂

Let me know what you think by posting a comment below … thanks!

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.


  1. Donna on September 7, 2022 at 8:15 am

    That’s a cool function! I don’t have access to the IMAGE function yet, but will find a use for it!

  2. Sarah on October 31, 2022 at 1:42 pm

    I don’t have access to this function yet, but I do wonder how this could be used with files saved on the computer… I.e. snipits of a contract that we may want to use the IMAGE function for. Is there a way to source from the computer or from another tab of the workbook?

  3. Greg on January 4, 2023 at 8:33 pm

    Nice but why do some jpg comes in side ways from google drive they are landscape in Excel with =Image. When viewing with google drive previewer they are portrait.

  4. Willy on March 4, 2023 at 11:39 pm

    Doesn’t work for one drive and shared drive image? Is there any suggestion?

  5. skees on August 30, 2023 at 9:35 am

    thanks very good

  6. Sarith on October 11, 2023 at 9:10 pm

    Good for explanation, but i could not get this function in my excel file, pls advise how to get this function works?

Leave a Comment