Hi, Insiders! My name is Elisabetta Caldesi, and I’m a Product Manager on the Excel team. I’m excited to share with you a new function, called IMAGE, which returns an image within a cell.
We’ve received a lot of feedback about the wish to be able to insert images in cells, and we’re happy to deliver! Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. This improvement unlocks and facilitates many new scenarios, such as tracking inventories, creating employee dashboards, or building games and brackets.
How it works
The IMAGE function inserts images into cells from a source location, along with alternative text. All you need to do is type the following into a cell: =IMAGE(source, [alt_text], [sizing], [height], [width]), where:
- [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.
Scenarios to try
- Insert a sphere in a cell by typing
- Insert a cylinder in a cell by:
- Copying and pasting the following URL in cell B1: https://support.content.office.net/en-us/media/35aecc53-b3c1-4895-8a7d-554716941806.jpg
- Entering Cylinder in cell B2.
- Entering =IMAGE(B1,B2,0) in cell A3 and pressing the ENTER key.
- If the URL to the image file you are using is pointing to a site that requires authentication, the image will not render.
- Zooming in and out with images in cells may distort the images.
- Moving between platforms (for example, Windows and Mac) may result in irregular image rendering.
The IMAGE function is available to Insiders running the following Beta Channel builds:
- Windows: Version 2209 (Build 15608.10000) or later
- Mac: Version 16.65 (Build 22080701) or later
- iOS: Version 2.65 (Build 22080701) or later
- Android: 16.0.15608.10000 or later
Don’t have it yet? It’s probably us, not you.
Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.
As you use the preview of the new IMAGE function in Excel, we hope you will join us in this journey. Click Help > Feedback to share your feedback and help us prioritize our work.
Learn what other information you should include in your feedback to ensure its actionable and reaches the right people. We’re excited to hear from you!