can you anchor an image to a cell in excel?

J

jy15bill

can you anchor an image to a cell so that when the sheet is sorted, the image
moves with the data?
 
P

Peo Sjoblom

Right click the picture and format picture, then properties and select one
of the first 2 options


--


Regards,


Peo Sjoblom
 
J

jy15bill

Thanks for the response, I tried that and when I sorted the sheet the image
did not move with the data? Am I doing something wrong?
 
G

Gord Dibben

If the image lies entirely within the cell boundaries it will move and sort with
the cell.

Make sure you have set it "move and size with cells".

Otherwise......no.


Gord Dibben MS Excel MVP
 
Top