Forum Discussion
Convert image url to actual image in excel
I have a column of image URLs in my workbook and would like to show the actual image in the next column. Is there a formula or add in that can be used?
Hi Haytham Amairah ,
Thanks for sharing the code. Works, however:
- the images do not get inserted within (inside) the cell; they are floating on top of the cells and can be moved around freely; the cells behind the image can be clicked and text entered. Is there a way that the image is inside the cell and can be picked up as data associated with that row?
- Can a hyperlink be added such that the image/thumbnail can be clicked and it pops open the original image?
Thanks!
Mus
Hi Mus,
Pictures inserted in Excel float in something called (Drawing layer) on top of the worksheet.
It's cannot be added inside the cells.
Regards
- hello is there an option with IF parametres to lock aspect ratio based on whether the height/width of the picture is bigger and then it automatically making it that aspect ratio. for example if the image is landscape oriented it locking the height?
