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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Indirect Hyperlink from a graphic to a calculated cell or range 5
Locking a cell reference in a formula 1
how do I lock the fill color in a cell 1
Lock cell as reference not value 8
hoW TO LOCK AND UNLOCK A CELL USING A FUNCTION/FORMULA 6
SUMIFs for particular cells in blocks of data 2
Can I add a graphic to a cell in Excel 2

Top