View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Inserting a picture-using sort function

As far as I know (which may not be very far):
- The picture must fit entirely within the cell. If it covers more than one
cell, it won't move when the cells are sorted.
- Right-click on the picture and select Format Picture. On the Properties
tab, click "Move but don't size with cells", then click OK.

Hope this helps,

Hutch

"amast" wrote:

How do I "tie" a picture to a cell so when I use a sort functions in another
column the picture will stay with the proper data?