Inserting a picture-using sort function
 

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?

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?

Inserting a picture-using sort function
 

You got it spot on Tom.

"Must fit entirely within the cell"


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 13:20:02 -0700, Tom Hutchins
wrote:

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?