pictures in excel

  • Thread starter Thread starter ira
  • Start date Start date
I

ira

I am putting photos in cells but they donot stay. if I
delete a line they get all screwed up. I just want a
stock nUmber and a photo to be in the same cell and stay
there! Anyone know what to do?
 
You could type the PartNumber in the cell, then insert the picture into a
Comment Box attached to the cell........the Comment Box can be sized to suit
and left visible, or hidden to appear only when the cell is "moused
over"......the Comment Box will follow the cell whever it goes by adding or
deleting rows, sorting, etc.......

Vaya con Dios,
Chuck, CABGx3
 
Left click on a cell.....
Right click > Insert Comment.......this creates a Comment Box
Click on the border of the comment box to select it.......
Click on the arrow button next to the Fill Color button on the Drawing
Toolbar
Select "Fill Effects" > Picture tab > Select Picture button
Pick a picture from file > Insert > OK........

That gets the Comment box and a picture in it........then while it's
highlighted it can be sized by dragging one of the corners........and hidden
by Right Click > Hide comments..........

Debra Dalgleish taught me this one a long time ago........thanks Deb

hth
Vaya con Dios,
Chuck, CABGx3
 
Amazing..........
u da man

CLR said:
Left click on a cell.....
Right click > Insert Comment.......this creates a Comment Box
Click on the border of the comment box to select it.......
Click on the arrow button next to the Fill Color button on the Drawing
Toolbar
Select "Fill Effects" > Picture tab > Select Picture button
Pick a picture from file > Insert > OK........

That gets the Comment box and a picture in it........then while it's
highlighted it can be sized by dragging one of the corners........and hidden
by Right Click > Hide comments..........

Debra Dalgleish taught me this one a long time ago........thanks Deb

hth
Vaya con Dios,
Chuck, CABGx3

into
Click to expand...
 
Thanks, but it was Queen Debra who showed me the light........I was just
lucky enough to remember it and share..........it is really cool tho, I've
used it a number of times......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top