how to inset a picture in a cell and make it stay in that cell
 

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

how to inset a picture in a cell and make it stay in that cell
 

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

how to inset a picture in a cell and make it stay in that cell
 

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

how to inset a picture in a cell and make it stay in that cell
 

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

how to inset a picture in a cell and make it stay in that cell
 

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