View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Display image thumbnails in Excel cells

The only way to sort images and have them stay with the cells is to reduce
the image size so's it fits within the confines of the cell.

It will then size and move with the cell.

The reason being..........images float on top of cells so if larger than the
cells they will continue to float.


Gord

On Tue, 12 Jan 2010 11:05:01 -0800, jonski
wrote:

"Gord Dibben" wrote:

Along with the hyperlink in the cell, insert a Comment and add the picture
to the Comment background.

InsertComment.

Right-click and Format CommentColors and LinesColorFill EffectsPicture

Browse to the image file and "OK"


Glad I found that great tip, and thank you, but I'm wondering it there's any
way of actually making the cell background "properly" the image? I also have
Excel 2010 Beta.

Reason being is that I've been given a badly made spreadsheet to sort out,
and one column has images, but even though the box "resize and keep aligned
with cell" (or similar), when I come to sort, it goes all random!

Also, the images must be displayed IN the cell, not in a comment.

Thank you.