Thread: How to sort and filter when there are images invloved
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default 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

Reply With QuoteReply With Quote