Inserting a picture-using sort function

A

amast

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?
 
T

Tom Hutchins

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
 
G

Gord Dibben

You got it spot on Tom.

"Must fit entirely within the cell"


Gord Dibben MS Excel MVP
 
Top