Link to home
Start Free TrialLog in
Avatar of CalDev
CalDev

asked on

Embed image in Excel cell

I would like to know how to embed an images (jpg) into cells in Excel 2000. Each row will need to have a different product image embeded. I don't want to do Insert>picture>from file, since using this method files float on the page and are not embeded in the cells. The object is to have images imbeded in cells so that they can be sorted with rows.
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

You cannot place images inside cells. They have to float. What you can do is configure the picture to move and size with cells. This will tell Excel to keep the image over the same cells as the rows and columns are resized.

Kevin
Avatar of CalDev
CalDev

ASKER

zorvek

Do you know how to configure the pictures to move and size with cells?
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
CalDev,

>The object is to have images embedded in cells so that they can be sorted with rows.

Yes, this can almost be done, but the picture is attached to a cell not within the cell. If that's good enough then this is how it's done.

1. Right click on the cell and Insert Comment

2. On the hashed border around the Comment, double click. That will bring up a dialogue box entitled Format Comment, select the Colours and Lines tab.

3. Click on the Fill/Colour dropdown arrow and click on the Fill Effects& at the bottom.

4. Select the Picture tab and then press the Select Picture button. Navigate your way to the correct picture and press OK (as many times as needed) all the way back to the beginning. The picture will appear squashed up in the Colour dropdown, but ignore that.

Thats it. Its fiddly but it is doable. You can either make the Comments (with the pictures) permanently visible or you can make it so that the picture only shows when you move the mouse cursor over the cell.

Hope that helps

Patrick
CalDev,

Well, that was pretty impatient.

Patrick