Picture to remain with row after resort

G

Guest

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
 
G

Guest

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
 
J

Jim Rech

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

--
Jim
|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top