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.

**GlenLee** · 03-08-2021, 09:15 PM

Sorry about the off-topic reply.

**FDibbins** · 03-09-2021, 03:02 AM

Originally Posted by GlenLee

Doing this works to have the picture follow the cell, but in Excel 365 I can still move the picture away from the cell even though:

The cell is locked
The worksheet is protected
"Move and size with cells" is clicked
"Locked" is checked in "Format Picture" ➔ Properties section

Is there a way to lock down the picture to the cell so it can't be moved or deleted from a locked cell and protected worksheet?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread