How to sort and filter when there are images invloved

[DJChes]

I was wondering if there was some way to sort and filter columns when
there are images involved. When I paste images in spreadsheets, they
sit above the cell. Is there a way to have the image attached to the
cell?

 

[Ken Johnson]

I was wondering if there was some way to sort and filter columns when
there are images involved. When I paste images in spreadsheets, they
sit above the cell. Is there a way to have the image attached to the
cell?

Hi,

It's a pity they sit above the cell.
If the image is inside the cell and their Object Positioning property
is either "Move and size with cell" or "Move but don't size with cell"
then they will be sorted with their cell value.

Can you set up the sheet so that the images are inside the cell rather
than sitting on top?

Ken Johnson

 

[Guest]

Nope... To the best of my knowledge this is not going to work out for you...

 

[Dave Peterson]

You could add a comment to the cell and put the picture in that comment.

Debra Dalgleish has some notes:
http://www.contextures.com/xlcomments02.html#Picture

And if you do change those settings (move and size with cells), then if you're
very careful to put the picture within the borders of the cell (still floating
above the cell), then it should work ok (include that column in the sort, too).

 

[Ken Johnson]

I think I have misinterpreted "sit above the cell", I took that to
mean, for example, picture name in A2 then picture in A1. I'm probably
wrong there. You more than likely mean the picture is above the cell in
the Z direction.

Ken Johnson