View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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