can you anchor an image to a cell so that when the sheet is sorted, the image moves with the data?
J jy15bill May 5, 2008 #1 can you anchor an image to a cell so that when the sheet is sorted, the image moves with the data?
P Peo Sjoblom May 5, 2008 #2 Right click the picture and format picture, then properties and select one of the first 2 options -- Regards, Peo Sjoblom
Right click the picture and format picture, then properties and select one of the first 2 options -- Regards, Peo Sjoblom
J jy15bill May 5, 2008 #3 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?
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 May 5, 2008 #5 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
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