Insert Pictures in Cells with the IMAGE Function
Published Feb 21 2023 09:51 AM 42.7K Views
Microsoft

Pictures have always been an important part of Excel spreadsheets, adding color and visualization to the data workbooks. Today, we’re excited to announce a new way to use pictures, as in-cell objects which will be part of the Excel grid. Using the new IMAGE function, pictures can now live in the cell and be the cell value instead of floating on top of it. The feature is available now on all our platforms! Windows, MacOS, Web, Android and iOS. 

 

With Pictures in cells, a whole new world of opportunities is unlocked! Imagine being able to insert a company logo next to important data, adding a product image to an inventory list and create an employee dashboard with their photos! You can use sort and filter, calculate, and write formulas with pictures, move or resize the cells, and work with Pictures within an Excel table. 

 

attendence dashboard_croped.jpg

 

 

How it works 

The IMAGE function inserts pictures into cells from a web source location along with alternative text. All you need to do is enter into a cell =IMAGE(source, [alt_text], [sizing], [height], [width]), where: 

  • [Required] 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. 
  • [Optional] alt_text: Alternative text that describes the picture for accessibility. 
  • [Optional] Sizing: Specifies 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. 
  • [Optional] Height and Width: only with sizing 3, define the height and width of the picture.  

For example, in the screenshot below, we took a picture of the Surface Laptop Studio and changed its dimensions using the function's parameters.

 

4.png

 

 

Share Your Feedback 

Do you have an idea to make Excel better? If yes, we'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion". 

 

Want to know more about Excel? Subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter. We look forward to hearing from you. 

37 Comments
Co-Authors
Version history
Last update:
‎Feb 21 2023 10:59 AM
Updated by: