Blog Post

Microsoft 365 Insider Blog
3 MIN READ

Insert pictures in cells in Excel

Linda_C's avatar
Linda_C
Icon for Microsoft rankMicrosoft
Aug 25, 2024

(Originally published on July 18, 2023 by Itai Goldstein)

 

Hey, Insider community! My name is Itai Goldstein, and I’m a Senior Product Manager on the Excel team. I’m delighted to share that you can now insert pictures in cells from your device – a feature that many of you have asked for.

 

Insert pictures in cells from your device

 

Pictures add a splash of color to your worksheets and provide visual representation of your content. They also make it easier to understand your data and draw insights.

 

While you’ve been able to use pictures in Excel for many years, we’ve only recently enabled the ability for a picture to become the actual cell value. It remains attached to the data even when the sheet’s layout is modified. You can use it in tables, sort, filter, include it in formulas, and much more!

 

In the last year we’ve introduced the new IMAGE function, which allows you to place a web picture in cell using a URL. We are grateful for the fantastic feedback we received from many of you regarding this feature. Your valuable input has been instrumental in shaping the improvements we have made in this area.

 

Today, I’m happy to share that we have listened to your feedback. We implemented the ability to insert local pictures, directly into cells, from your device or from the stock image libraries.

 

How it works

  1. Select the cell where you want to place the picture.
  2. Select Insert > Pictures > Place in Cell, and then select one of the available sources:
    • This Device
    • Stock Images
    • Online Pictures

Insert > Pictures > Place in Cell

 

NOTE: To insert pictures and have them “float” on top of your worksheet, like you used to do before, select Insert > Pictures > Place over Cells.

 

Switch between picture types

If you have an existing worksheet that contains a picture that was inserted using the Place over Cells command, and you want it to become part a cell, select the picture and click the Place in Cell button that appears next to the picture. 

 

You can also find the Place in Cell command in the right-click context menu or in the Picture Format contextual tab.

 

Place in/over Cell 

 

Paste picture from the clipboard into a cell

To directly paste a picture from the clipboard into a cell, select Paste > Paste Picture in Cell on the Home tab or in the right-click context menu.

 

NOTE: When you use the default Paste command on the Home tab or the context menu, or press Ctrl+V to paste a picture, it will pasted over cells for now – not in a cell. 

 

Paste > Paste Picture in Cell

 

Availability

These capabilities are now available to Insiders running:

  • Windows: Version 2306 (Build 16529.20000)
  • Mac: Version 16.75 (Build 23070901)

These capabilities will become available soon in Excel for the web as well as on Excel for iOS and Excel for Android.

 

Feedback

We’d love to hear from you! Click Help > Feedback in Excel to share your feedback and help us prioritize our work.

 


Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!

Updated Aug 25, 2024
Version 1.0
  • david1225's avatar
    david1225
    Copper Contributor

    Hey, I just read the article ,it's useful for me. 

    But I suggest you try another online tool: https://excelpicture.online  . It's pretty straightforward—it just converts URLs to images. While it's not a fancy site with tons of features, it does one thing and does it well. If you've got a URL to an image and want to quickly insert it into Excel, this could be a handy little tool. Give it a try if you need a quick fix for adding images to your sheets!

  • ConnorOnTheJob's avatar
    ConnorOnTheJob
    Copper Contributor

    This is the single greatest technical achievement that Microsoft has pulled off in years. Thank you. 

  • amit_bhola's avatar
    amit_bhola
    Iron Contributor

    A query : what kind of logic works when the two cells with images are compared by = operator?

     

    Cell 1 : image 1 placed in cell (eg A1 cell)

    Cell 2 : image 2 placed in cell (say A2 cell)

     

    Cell 3 formula: A1 = A2 returns TRUE and FALSE

     

    Behind the scene, is the = operator comparing size&pixels RGB ? , or just some unknown image property ?

  • rlbcontractor's avatar
    rlbcontractor
    Copper Contributor

    It would be helpful if the Picture in the Cell (and over the cell) object had usable (and stable) names. I develop excel applications with VBA and hope that a complete set of well documented properties and methods for this new Picture object are being planned. I have tried using the Shapes collection to manipulate Pictures, but I have found that this new Picture object is not a "Shape."