Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
i would like to insert a picture in a cell in excell and i need it to stay in that cell and act as text or numbers would act in that cell, or i would like the picture to be inserted in the comment box and it to be displayed if i mouse over the cell. Any help would be appreciated. Louis |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To insert a picture in a comment (xl2003):
1. Insert a comment in a cell. 2. The comment is surrounded by diagonal lines. CLick on the diagonal lines. NOw the comment should be surrounded by dense dots. 3. Select Comment from the Format menu. 4. On the Colors and Lines tab, select Color, then Fill Effects... 5. On the Picture tab, click Select Picture... 6. Select the picture file, and OK your way back out. Hope this helps, Hutch "Louis111" wrote: hi i would like to insert a picture in a cell in excell and i need it to stay in that cell and act as text or numbers would act in that cell, or i would like the picture to be inserted in the comment box and it to be displayed if i mouse over the cell. Any help would be appreciated. Louis |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you make the picture small enough that it fits within the bounds of the cel
then formatits properties to move and size with the cell you can keep the picture with the cell. To place a picture in a Comment you can insertcomment. Right-click on edge of comment then format commentcolor and linesfill effectspictureslect picturebrowse to your picture and double-click on it. Gord Dibben MS Excel MVP On Tue, 4 Mar 2008 14:01:05 -0800, Louis111 wrote: hi i would like to insert a picture in a cell in excell and i need it to stay in that cell and act as text or numbers would act in that cell, or i would like the picture to be inserted in the comment box and it to be displayed if i mouse over the cell. Any help would be appreciated. Louis |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks,
it works inserting pic into comments, i would not have worked out how to do it without your help. Louis. "Gord Dibben" wrote: If you make the picture small enough that it fits within the bounds of the cel then formatits properties to move and size with the cell you can keep the picture with the cell. To place a picture in a Comment you can insertcomment. Right-click on edge of comment then format commentcolor and linesfill effectspictureslect picturebrowse to your picture and double-click on it. Gord Dibben MS Excel MVP On Tue, 4 Mar 2008 14:01:05 -0800, Louis111 wrote: hi i would like to insert a picture in a cell in excell and i need it to stay in that cell and act as text or numbers would act in that cell, or i would like the picture to be inserted in the comment box and it to be displayed if i mouse over the cell. Any help would be appreciated. Louis |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Thanks it works, i would not have found out how to do this myself. Louis "Tom Hutchins" wrote: To insert a picture in a comment (xl2003): 1. Insert a comment in a cell. 2. The comment is surrounded by diagonal lines. CLick on the diagonal lines. NOw the comment should be surrounded by dense dots. 3. Select Comment from the Format menu. 4. On the Colors and Lines tab, select Color, then Fill Effects... 5. On the Picture tab, click Select Picture... 6. Select the picture file, and OK your way back out. Hope this helps, Hutch "Louis111" wrote: hi i would like to insert a picture in a cell in excell and i need it to stay in that cell and act as text or numbers would act in that cell, or i would like the picture to be inserted in the comment box and it to be displayed if i mouse over the cell. Any help would be appreciated. Louis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert a picture into an excel cell & have it stay there | Excel Discussion (Misc queries) | |||
How do I post a picture into a cell and have it stay there? | Excel Worksheet Functions | |||
How do I make a picture stay inside a cell? | Excel Discussion (Misc queries) | |||
how to make a picture pop-up when selecting a cell? | New Users to Excel | |||
Cell Inset? | New Users to Excel |