attaching a picture to a cell.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tonso - 30 Jan 2008 14:01 GMT

using Excel 2002, is there a way to place a picture in a cell, then,
if the range the cell is in is sorted, have the picture move with the
cell?
Tonso

Reply to this Message

Dave Peterson - 30 Jan 2008 14:45 GMT

Pictures hover over the cells--they're not actually in the cells.

Make sure the pictures are totally within the row (or cell)--no overlapping to
the cell above or below.

Then make sure each picture is marked to move and size with cells.

Right click on a picture|Format Picture|Properties tab|move an size with cells.

An alternative that you may like better:
http://contextures.com/xlcomments02.html#Picture
(From Debra Dalgleish's site)

> using Excel 2002, is there a way to place a picture in a cell, then,
> if the range the cell is in is sorted, have the picture move with the
> cell?
> Tonso

Signature

Dave Peterson

Reply to this Message

CLR - 30 Jan 2008 18:10 GMT

The picture must be totally contained within the cell, as Dave
described.....usually cells are too small for this to be able to see the
picture. Better methods are to use the Comment Boxes like dave suggests, or
to just put a Hyperlink to the picture in the cell.....

Vaya con Dios,
Chuck, CABGx3

> using Excel 2002, is there a way to place a picture in a cell, then,
> if the range the cell is in is sorted, have the picture move with the
> cell?
> Tonso

Reply to this Message