excel spread sheets links

[JSt0rm]

I'm new to office software but is there a way to link to jpg or other files from within a cell and have that picture pop up when you click it?

 

[mayest]

You could create a hyperlink to the image. Use the Hyperlink() function. That will launch a browser window with the image loaded. You could also just copy the picture and paste it into Excel. If you need to hide it and then show it only when a link is clicked, then that will probably require a macro.

 

[petesamprs]

This can be done in an interesting way. First, go to the cell you want the picture to appear in. Then, hit Shift+F2 to create a comment box.

Right click on the box and choose "Format Comment", then choose the "Colors and Lines" tab.

Under "Fill" go the "Color" pull down and select "Fill Effects" all the way at the bottom.

Then choose the rightmost tab "Picture" and insert your saved pic. Select "Lock picture aspect ratio" at the bottom as well.

Now everytime you mouse over the cell, the comment box will open with your pic in it.

 

[BrunoPuntzJones]

Originally posted by: petesamprs
This can be done in an interesting way. First, go to the cell you want the picture to appear in. Then, hit Shift+F2 to create a comment box.

Right click on the box and choose "Format Comment", then choose the "Colors and Lines" tab.

Under "Fill" go the "Color" pull down and select "Fill Effects" all the way at the bottom.

Then choose the rightmost tab "Picture" and insert your saved pic. Select "Lock picture aspect ratio" at the bottom as well.

Now everytime you mouse over the cell, the comment box will open with your pic in it.

Outstanding answer. I wouldn't have thought of that.

 

[mayest]

petesamprs, major props on that! Very clever.

 

[JSt0rm]

cool. thanks for the tips everybody!!