formula to copy picture from one cell into another

[dcloin]

I've been using excel for about 20 years off and on and been a member to this site for over 10 years. I've also taken a couple classes but this has me stumped. I'm reaching out the the greatest excel minds on the internet.

I have a spreadsheet with a picture in cell A1. This picture is locked in the cell and set to move and size with cell A1. I want to have a formula in Cell C1 (and other cells) that will show this same picture. This way I can change the picture in A1 and it will also change in the other cells.

I've tried =(A1), =Cell(A1) and it still returns a '0" . I've searched and searched but can't seem to find an answer.

I have changed cell C1's size to make sure the picture does resize so I believe it is locked in the cell. I can also copy row 1 and paste it and the picture is also pasted. Help!!!!!! I know it can't be this hard.

Darvin Cloin

 

[Yongle]

Have a look at Excel's inbuilt Camera Tool

 

[dcloin]

The Camera Tool did the trick. Never knew it was there. I appreciate you taking the time to respond.

 

[Yongle]

It is one of Excel's best kept secrets!
Thanks for the feedback