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
|