putting an jpg into a cell

[Peterso]

I am using office 365 in which the excel have a function which I can past a jpg picture into a cell. I would like to know if excel 2021 version have this function? if not, is there any way to do it in excel 2021? Thanks

 

[jolivanes]

Do you mean inserting a picture from a folder and pasting it in a cell with the picture dimensions being the cell dimension?

 

[Cubist]

For 365, you can try IMAGE function.

 

[Peterso]

Do you mean inserting a picture from a folder and pasting it in a cell with the picture dimensions being the cell dimension?

yes

 

[Peterso]

For 365, you can try IMAGE function.

I just want to do that by excel 2021. Is it possible?

 

[Cubist]

On the Insert tab..., try:

 

[Peterso]

On the Insert tab..., try:
View attachment 111488

Let me try. Thanks

 

[jolivanes]

For any version. I am not prejudiced against any other versions.
This will put a picture in G12, Cells(12, 7), and size it to the cell dimensions.

Sub Insert_Pic()
    ActiveSheet.Shapes.AddPicture "C:\Folder Name Here\Picture Name Here.jpg", False, True, Cells(12, 7).Left, Cells(12, 7).Top, Cells(12, 7).Width, Cells(12, 7).Height
End Sub