Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,069
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a picture into an excel cell & have it stay there elizaj13 Excel Discussion (Misc queries) 4 April 13th 10 11:53 PM
How do I post a picture into a cell and have it stay there? rtk Excel Worksheet Functions 1 January 29th 07 12:21 AM
How do I make a picture stay inside a cell? Davdi Keltner Excel Discussion (Misc queries) 2 October 7th 05 08:19 PM
how to make a picture pop-up when selecting a cell? tendercare New Users to Excel 1 September 6th 05 12:47 PM
Cell Inset? davewill New Users to Excel 8 August 23rd 05 07:35 PM


All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"