Add picture to cell as text not object file and reference it from folder to cell | General Excel Questions & Answers | Excel Forum

Hi shafiz

(A) To be able to filter, you will need to fit the picture exactly into a single cell and then set its property to Move and size with cell. Please refer attachment.

(B) As for the link, you could consider using a comment to insert the image. I am unable to upload a sample as the file with linked images is very large and exceed the allowable size but you can follow the instructions below.

1) Insert a comment in each cell

2) You will need to remove the text (author's name) from the comment

3) Right-click the edge of the comment and select Format Comment

4) Select the Colors and Lines tab

5) Select Fill - Color - Fill Effects - Picture

6) Click Select Picture

7) Select your picture and click Insert-OK-OK

8) Fit the inserted image into the cell

9) Change the image property to Move and size with cell

Hope this helps.

Sunny

Hi Frans

Thanks for sharing the link. Very interesting indeed.

Just to share some thought on this subject. Most of the time I have to face situations where 100's of pictures (with different file formats such as gif, bmp, jpg and size) need to be inserted beside a list of names. The pictures then need to be fitted exactly into each cell and must be able to resize with the cell. Worse still, some want the pictures to be displayed only when hovering the mouses over the names. That means inserting the pictures into Comments. Another situation, get the pictures out of the Comments into cells!!. The downside of inserting images is extremely large file size and may slow down performance.