ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to sort and filter when there are images invloved (https://www.excelbanter.com/excel-discussion-misc-queries/118361-how-sort-filter-when-there-images-invloved.html)

[email protected]

How to sort and filter when there are images invloved
 
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

How to sort and filter when there are images invloved
 
wrote:
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


Jim Thomlinson

How to sort and filter when there are images invloved
 
Nope... To the best of my knowledge this is not going to work out for you...
--
HTH...

Jim Thomlinson


" wrote:

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?



Dave Peterson

How to sort and filter when there are images invloved
 
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).

wrote:

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?


--

Dave Peterson

Ken Johnson

How to sort and filter when there are images invloved
 

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



All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com