software

I want to show pictures in an Excel spreadsheet. I would like to either embed
a picture in a single cell that could be enlarged as need to view. If that is
not possible I would like to embed a link to a jpeg file that could then be
clicked on to open that file. Any ideas about how this could be accomplished?

I am using Excel 2003.

You might consider inserting the pictures into the comment boxes of cells,
and they will pop-up as the cell is moused over.

Vaya con Dios,
Chuck, CABGx3
quot;Tom the Builderquot; wrote:

gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; not possible I would like to embed a link to a jpeg file that could then be
gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt;
gt; I am using Excel 2003.


Tom,
You could put a hyperlink in to any file including a picture file, by
selecting the cell and hitting Ctrl K. Then find the file you want to
link.
Alternatively, to insert a picture into a comment, create a comment
(Shift F2), delete any text and then right click the comment and choose
Format Comment/Colours and Lines/Fill Section/Color/Fill
Effects/Picture.
Clive

Tom the Builder Wrote:
gt; I want to show pictures in an Excel spreadsheet. I would like to either
gt; embed
gt; a picture in a single cell that could be enlarged as need to view. If
gt; that is
gt; not possible I would like to embed a link to a jpeg file that could
gt; then be
gt; clicked on to open that file. Any ideas about how this could be
gt; accomplished?
gt;
gt; I am using Excel 2003.--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: www.excelforum.com/member.php...oamp;userid=32569
View this thread: www.excelforum.com/showthread...hreadid=533437Chuck,

Thanks for your reply. I like this idea

I tried it but once I went to the insert/picture/ menu I was unable to
access the file from that menu. The only item it will let me insert is an
organiztional chart. I also tried to copy the picture and went to edit the
comment box but found the quot;pastequot; option unavailable. Do you have any hints
on how to insert the picture into the comment box?

Thanks,
Tom

quot;CLRquot; wrote:

gt; You might consider inserting the pictures into the comment boxes of cells,
gt; and they will pop-up as the cell is moused over.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Tom the Builderquot; wrote:
gt;
gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt;
gt; gt; I am using Excel 2003.

Hi Tom.........
To insert a picture into a Comment Box, first select the cell of interst,
then Right-click gt; InsertComment gt; backspace to eliminate any existing text,
then Left-click on the border of the Comment Box where the cursor becomes a
cross, then click on the arrow next to the FillBucket, then click FillEffects
gt; PictureTab gt; SelectPicture.....browse to find a picture file, then OK gt;
OK.......then ou can grab a cornet haldle and resize the picture as desired,
then click off on any other cell. Now, when you mouse over that cell, that
picture pops up.........cool.

Vaya con Dios,
Chuck, CABGx3
quot;Tom the Builderquot; wrote:

gt; Chuck,
gt;
gt; Thanks for your reply. I like this idea
gt;
gt; I tried it but once I went to the insert/picture/ menu I was unable to
gt; access the file from that menu. The only item it will let me insert is an
gt; organiztional chart. I also tried to copy the picture and went to edit the
gt; comment box but found the quot;pastequot; option unavailable. Do you have any hints
gt; on how to insert the picture into the comment box?
gt;
gt; Thanks,
gt; Tom
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; You might consider inserting the pictures into the comment boxes of cells,
gt; gt; and they will pop-up as the cell is moused over.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Tom the Builderquot; wrote:
gt; gt;
gt; gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt; gt;
gt; gt; gt; I am using Excel 2003.

Clivey:
Thanks for the suggestion. I tried both methods.
1) The Hyperlink appeared, but when I click on it I received a pop-up
stating quot;Can not open specified filequot;

2) When I used Fill Effects, I found the picture, chose it, but only the
name of the picture's file showed up, not the picture itself. I then clicked
on quot;Insertquot; but the picture did not appear in the Comment Box.

Any suggestions.
Thanks for your time,

Tom

quot;Clivey_UKquot; wrote:

gt;
gt; Tom,
gt; You could put a hyperlink in to any file including a picture file, by
gt; selecting the cell and hitting Ctrl K. Then find the file you want to
gt; link.
gt; Alternatively, to insert a picture into a comment, create a comment
gt; (Shift F2), delete any text and then right click the comment and choose
gt; Format Comment/Colours and Lines/Fill Section/Color/Fill
gt; Effects/Picture.
gt; Clive
gt;
gt; Tom the Builder Wrote:
gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either
gt; gt; embed
gt; gt; a picture in a single cell that could be enlarged as need to view. If
gt; gt; that is
gt; gt; not possible I would like to embed a link to a jpeg file that could
gt; gt; then be
gt; gt; clicked on to open that file. Any ideas about how this could be
gt; gt; accomplished?
gt; gt;
gt; gt; I am using Excel 2003.
gt;
gt;
gt; --
gt; Clivey_UK
gt; ------------------------------------------------------------------------
gt; Clivey_UK's Profile: www.excelforum.com/member.php...oamp;userid=32569
gt; View this thread: www.excelforum.com/showthread...hreadid=533437
gt;
gt;

Chuck:

Once again thanks. I gave it a try and got to Fill effect, pictutres. I then
found the picture, chose it, but only the name of the picture's file showed
up, not the picture itself. I then clicked on quot;Insetquot; but the picture did not
appear in the Comment Box.

Hmm, any suggestions?
Tom
quot;CLRquot; wrote:

gt; Hi Tom.........
gt; To insert a picture into a Comment Box, first select the cell of interst,
gt; then Right-click gt; InsertComment gt; backspace to eliminate any existing text,
gt; then Left-click on the border of the Comment Box where the cursor becomes a
gt; cross, then click on the arrow next to the FillBucket, then click FillEffects
gt; gt; PictureTab gt; SelectPicture.....browse to find a picture file, then OK gt;
gt; OK.......then ou can grab a cornet haldle and resize the picture as desired,
gt; then click off on any other cell. Now, when you mouse over that cell, that
gt; picture pops up.........cool.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Tom the Builderquot; wrote:
gt;
gt; gt; Chuck,
gt; gt;
gt; gt; Thanks for your reply. I like this idea
gt; gt;
gt; gt; I tried it but once I went to the insert/picture/ menu I was unable to
gt; gt; access the file from that menu. The only item it will let me insert is an
gt; gt; organiztional chart. I also tried to copy the picture and went to edit the
gt; gt; comment box but found the quot;pastequot; option unavailable. Do you have any hints
gt; gt; on how to insert the picture into the comment box?
gt; gt;
gt; gt; Thanks,
gt; gt; Tom
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; You might consider inserting the pictures into the comment boxes of cells,
gt; gt; gt; and they will pop-up as the cell is moused over.
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt; gt; gt;
gt; gt; gt; gt; I am using Excel 2003.

I don't know what else to say, Tom......it works for me. What version of
Excel are you using?........BTW, I do not see the option quot;Insetquot; anywhere on
any of the menu path I described to you.........where are you seeing it?

Vaya con Dios,
Chuck, CABGx3
quot;Tom the Builderquot; wrote:

gt; Chuck:
gt;
gt; Once again thanks. I gave it a try and got to Fill effect, pictutres. I then
gt; found the picture, chose it, but only the name of the picture's file showed
gt; up, not the picture itself. I then clicked on quot;Insetquot; but the picture did not
gt; appear in the Comment Box.
gt;
gt; Hmm, any suggestions?
gt; Tom
gt; quot;CLRquot; wrote:
gt;
gt; gt; Hi Tom.........
gt; gt; To insert a picture into a Comment Box, first select the cell of interst,
gt; gt; then Right-click gt; InsertComment gt; backspace to eliminate any existing text,
gt; gt; then Left-click on the border of the Comment Box where the cursor becomes a
gt; gt; cross, then click on the arrow next to the FillBucket, then click FillEffects
gt; gt; gt; PictureTab gt; SelectPicture.....browse to find a picture file, then OK gt;
gt; gt; OK.......then ou can grab a cornet haldle and resize the picture as desired,
gt; gt; then click off on any other cell. Now, when you mouse over that cell, that
gt; gt; picture pops up.........cool.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Tom the Builderquot; wrote:
gt; gt;
gt; gt; gt; Chuck,
gt; gt; gt;
gt; gt; gt; Thanks for your reply. I like this idea
gt; gt; gt;
gt; gt; gt; I tried it but once I went to the insert/picture/ menu I was unable to
gt; gt; gt; access the file from that menu. The only item it will let me insert is an
gt; gt; gt; organiztional chart. I also tried to copy the picture and went to edit the
gt; gt; gt; comment box but found the quot;pastequot; option unavailable. Do you have any hints
gt; gt; gt; on how to insert the picture into the comment box?
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt; Tom
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You might consider inserting the pictures into the comment boxes of cells,
gt; gt; gt; gt; and they will pop-up as the cell is moused over.
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; gt; gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; gt; gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; gt; gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am using Excel 2003.

Chuck:
My Typo, that was quot;Insertquot; - here is what I did:
I followed your instructions and got to Format Comment gt; Colors and Lines gt;
Fill gt; I used the color pull down menu gt; Fill effect gt; Select Picture gt; in
Select Picture mune, I clicked on the picture I want, then clicked quot;Insertquot; gt;
OKquot;CLRquot; wrote:

gt; I don't know what else to say, Tom......it works for me. What version of
gt; Excel are you using?........BTW, I do not see the option quot;Insetquot; anywhere on
gt; any of the menu path I described to you.........where are you seeing it?
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Tom the Builderquot; wrote:
gt;
gt; gt; Chuck:
gt; gt;
gt; gt; Once again thanks. I gave it a try and got to Fill effect, pictutres. I then
gt; gt; found the picture, chose it, but only the name of the picture's file showed
gt; gt; up, not the picture itself. I then clicked on quot;Insetquot; but the picture did not
gt; gt; appear in the Comment Box.
gt; gt;
gt; gt; Hmm, any suggestions?
gt; gt; Tom
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Hi Tom.........
gt; gt; gt; To insert a picture into a Comment Box, first select the cell of interst,
gt; gt; gt; then Right-click gt; InsertComment gt; backspace to eliminate any existing text,
gt; gt; gt; then Left-click on the border of the Comment Box where the cursor becomes a
gt; gt; gt; cross, then click on the arrow next to the FillBucket, then click FillEffects
gt; gt; gt; gt; PictureTab gt; SelectPicture.....browse to find a picture file, then OK gt;
gt; gt; gt; OK.......then ou can grab a cornet haldle and resize the picture as desired,
gt; gt; gt; then click off on any other cell. Now, when you mouse over that cell, that
gt; gt; gt; picture pops up.........cool.
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Chuck,
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks for your reply. I like this idea
gt; gt; gt; gt;
gt; gt; gt; gt; I tried it but once I went to the insert/picture/ menu I was unable to
gt; gt; gt; gt; access the file from that menu. The only item it will let me insert is an
gt; gt; gt; gt; organiztional chart. I also tried to copy the picture and went to edit the
gt; gt; gt; gt; comment box but found the quot;pastequot; option unavailable. Do you have any hints
gt; gt; gt; gt; on how to insert the picture into the comment box?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; Tom
gt; gt; gt; gt;
gt; gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; You might consider inserting the pictures into the comment boxes of cells,
gt; gt; gt; gt; gt; and they will pop-up as the cell is moused over.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; gt; gt; gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; gt; gt; gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; gt; gt; gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I am using Excel 2003.

After you select the picture, forget the quot;Insertquot;, just click on OK over on
the right side of that pop-up..........then OK on the next pop-up.....then
the picture will go right into the comment box......

Vaya con Dios,
Chuck, CABGx3quot;Tom the Builderquot; wrote:

gt; Chuck:
gt; My Typo, that was quot;Insertquot; - here is what I did:
gt; I followed your instructions and got to Format Comment gt; Colors and Lines gt;
gt; Fill gt; I used the color pull down menu gt; Fill effect gt; Select Picture gt; in
gt; Select Picture mune, I clicked on the picture I want, then clicked quot;Insertquot; gt;
gt; OK
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; I don't know what else to say, Tom......it works for me. What version of
gt; gt; Excel are you using?........BTW, I do not see the option quot;Insetquot; anywhere on
gt; gt; any of the menu path I described to you.........where are you seeing it?
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Tom the Builderquot; wrote:
gt; gt;
gt; gt; gt; Chuck:
gt; gt; gt;
gt; gt; gt; Once again thanks. I gave it a try and got to Fill effect, pictutres. I then
gt; gt; gt; found the picture, chose it, but only the name of the picture's file showed
gt; gt; gt; up, not the picture itself. I then clicked on quot;Insetquot; but the picture did not
gt; gt; gt; appear in the Comment Box.
gt; gt; gt;
gt; gt; gt; Hmm, any suggestions?
gt; gt; gt; Tom
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi Tom.........
gt; gt; gt; gt; To insert a picture into a Comment Box, first select the cell of interst,
gt; gt; gt; gt; then Right-click gt; InsertComment gt; backspace to eliminate any existing text,
gt; gt; gt; gt; then Left-click on the border of the Comment Box where the cursor becomes a
gt; gt; gt; gt; cross, then click on the arrow next to the FillBucket, then click FillEffects
gt; gt; gt; gt; gt; PictureTab gt; SelectPicture.....browse to find a picture file, then OK gt;
gt; gt; gt; gt; OK.......then ou can grab a cornet haldle and resize the picture as desired,
gt; gt; gt; gt; then click off on any other cell. Now, when you mouse over that cell, that
gt; gt; gt; gt; picture pops up.........cool.
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Chuck,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks for your reply. I like this idea
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I tried it but once I went to the insert/picture/ menu I was unable to
gt; gt; gt; gt; gt; access the file from that menu. The only item it will let me insert is an
gt; gt; gt; gt; gt; organiztional chart. I also tried to copy the picture and went to edit the
gt; gt; gt; gt; gt; comment box but found the quot;pastequot; option unavailable. Do you have any hints
gt; gt; gt; gt; gt; on how to insert the picture into the comment box?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; gt; Tom
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; You might consider inserting the pictures into the comment boxes of cells,
gt; gt; gt; gt; gt; gt; and they will pop-up as the cell is moused over.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Tom the Builderquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I want to show pictures in an Excel spreadsheet. I would like to either embed
gt; gt; gt; gt; gt; gt; gt; a picture in a single cell that could be enlarged as need to view. If that is
gt; gt; gt; gt; gt; gt; gt; not possible I would like to embed a link to a jpeg file that could then be
gt; gt; gt; gt; gt; gt; gt; clicked on to open that file. Any ideas about how this could be accomplished?
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I am using Excel 2003.