Show Image when column is clicked in excel which is saved in another sheet

Question

I want to store some data in a row related to particular image and Image want to store in different sheet but in main sheet I want one column and when I click on this column then it will open the image.

This will save the space and all the data will one place.

Answer 1

The HYPERLINK function (Excel documentation, Calc documentation) can provide clickable links from one document location to another document location. It won't link to the images per se, but rather to the cell in (or near) which you have placed the image.