Picture to remain with row after resort
 

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

Picture to remain with row after resort
 

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

Picture to remain with row after resort
 

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