I would like the picture in one of the cells to stay with the data in it's
original row after I resort column. Not it's original cell. How can I do this?

I hope the question is clear.

Thank-you in advance

Brett

There are 3 things to look for here.

First, in the Picture Object Properties, make sure you've selected either
"Move and size with cells" or "Move but don't size with cells". Right-click
on the picture, and then select "Format Picture". Select the "Properties"
Tab.

Second, the picture will only sort with a row if it is completely contained
within that row. If the borders of the picture overlap with a different row,
then it will not sort.

Third, when performing the sort, make sure you include the column that the
picture is stored in. If your data is in Column A and your Picture is in
Column B, you must highlight both columns A and B, then do the sort.

HTH,
Elkar


"Brett" wrote:

I would like the picture in one of the cells to stay with the data in it's
original row after I resort column. Not it's original cell. How can I do this?

I hope the question is clear.

Thank-you in advance

Brett

Right click the picture and pick Format Picture. On the Properties tab you
can select how the picture moves with cells.

--
Jim
"Brett" wrote in message
...
|I would like the picture in one of the cells to stay with the data in it's
| original row after I resort column. Not it's original cell. How can I do
this?
|
| I hope the question is clear.
|
| Thank-you in advance
|
| Brett