software

I have a worksheet with ~ 800 rows amp; ~ 20 columns. One of those columns
contains an unique graphic for each row, so I have ~ 800 graphics.

My question is: How do I quot;lockquot; a graphic to a particular cell. For example,
when I hide/unhide columns, the graphics move out of the cell. Text and
formulas are locked into a cell, surely there must be a way to do the same
for grahics?

Thanks

The only way Iknow is to insert the graphic quot;INquot; a comment. Therefore the
comments can be hidden and the rows can be sorted and the comments follow.

Insert, comment, Right mouse, format comment, colors and lines, color, fill
effects, picture, select picture.

HTH

Gilles
quot;Darlenequot; gt; wrote in message
...
gt;I have a worksheet with ~ 800 rows amp; ~ 20 columns. One of those columns
gt; contains an unique graphic for each row, so I have ~ 800 graphics.
gt;
gt; My question is: How do I quot;lockquot; a graphic to a particular cell. For
gt; example,
gt; when I hide/unhide columns, the graphics move out of the cell. Text and
gt; formulas are locked into a cell, surely there must be a way to do the same
gt; for grahics?
gt;
gt; Thanks
Hi Darlene

Right-click the graphicgt;Format Picturegt;Propertiesgt;Move and size with
cells.

Were you also aware that holding the Alt key while sizing your picture
will snap it to the cell?

Regards

Steve