How do I "lock" a graphic to a particular cell in Excel?
 

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

My question is: How do I "lock" 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

How do I "lock" a graphic to a particular cell in Excel?
 

The only way Iknow is to insert the graphic "IN" 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
"Darlene" wrote in message
...
I have a worksheet with ~ 800 rows & ~ 20 columns. One of those columns
contains an unique graphic for each row, so I have ~ 800 graphics.

My question is: How do I "lock" 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

How do I "lock" a graphic to a particular cell in Excel?
 

Hi Darlene

Right-click the graphicFormat PicturePropertiesMove 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