How to put image or a picture in to the excels cell but as a function or something.

Question

Hi, so here is the problem. I have a folder with images and I can put that image into a cell and all. But I don't want to see that image in that cell. I want it, so that I can click on it and it would open that image separately from that folder. I can't seem to find a way to make it work. Your help would be of great help to me.

Answer 1

Hi @Ильяс Ильясов

You may use Hyperlink function: =Hyperlink(link_location, [friendly_name]) to insert the image.

But please note, if you click the link, the image is not opened in Excel, but opened through the system's picture viewer software.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---