Can I anchor a graphic to a cell?

**gshock** · 12-02-2008, 02:39 PM

I've got a couple of graphics that I want to include in one of my spreadsheets, and I just want to anchor them to a cell. Nothing fancy, no macros, no formulas, nothing like that. Can someone show me how to do this?

Thanks,

-gshock

**Ron Coderre** · 12-02-2008, 02:52 PM

How about putting the image in the cell's comment?

Debra Dalgleish's website has instructions:
http://www.contextures.com/xlcomments02.html#Picture

Is that something you can work with?

**gshock** · 12-02-2008, 02:57 PM

Originally Posted by Ron Coderre

How about putting the image in the cell's comment?

Debra Dalgleish's website has instructions:
http://www.contextures.com/xlcomments02.html#Picture

Is that something you can work with?

Ron, it's not a bad idea, but these are rather large graphics... although I can use that tip for something else.

I'm just creating some documentation in one of my workbooks, and I have some screenshots that I want to anchor to a particular cell. They're too big for a comment box.

**ChemistB** · 12-02-2008, 03:07 PM

Once you place the picture in the cell, right click on the picture and then click Format picture, then go to the properties tab and "move and size with cell. Is that what you are looking for? It moves with the cell if you delete or insert other rows/columns and will move if you cut and paste the cell.

**gshock** · 12-02-2008, 04:15 PM

Originally Posted by ChemistB

Once you place the picture in the cell, right click on the picture and then click Format picture, then go to the properties tab and "move and size with cell. Is that what you are looking for? It moves with the cell if you delete or insert other rows/columns and will move if you cut and paste the cell.

Yup, that will do it. Thanks.