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

D

Darlene

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
 
G

Gilles Desjardins

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
 
S

Scoops

Hi Darlene

Right-click the graphic>Format Picture>Properties>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
 
Top