Excell 2007 Won't Sort All Of Cell Contents

[djrecon]

Hello,
I use an excel file for my list of movies I own. Each cell has the movie name and a picture of the DVD cover. In older versions of Excel I would type in the name of the movie and paste the pic in the cell. Then I would hit "Sort" to keep the list alphabetical.
But now in Excel 2007, when I hit sort, it sorts the text alphabetically but does nothing with the pics. So now the pics don't match the title.

Anyone know how to include the pics in a sort?

 

[AnotherHiggins]

I don't have 2007 yet, but try this:

-Right click on a picture
-Select Format Picture > Properties
- Check "Move and Size with Cells"

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[djrecon]

Yeah, I tried that. It was already checked. It will move with the cell fine. It's just when I sort that it doesn't move.
Thanks though

 

[TaylorDavidI]

Is the picture in the same cell as the movie title or in the cell beside it?

If it's in an adjacent cell you could try highlighting both columns before choosing to sort. I'm still using 2003 so I can't say this will work for sure.

David I. Taylor
A+, Network+, MCP Windows XP

 

[djrecon]

It's in the same cell. What's weird is that when I create a new document in Excel and add a few names and pics it works fine. It must be something to do with using an old excel file (office xp) in the new Excel. Also tried saving it as a new excel file and copying info from the old sheet to the new file sheet. It doesn't seem to like anything about an earlier version excel file.