how do I sort an excel list that includes pictures (name-picture)

A

Angelke

I have a list with names of persons and pictures. Is there any possibility to
sort this list without shifting around the pictures? The picture should stay
next to the correct name even when sorting the list of last name etc.
 
D

Dave Peterson

Make sure the pictures are totally with in the row (or cell)--no overlapping to
the cell above or below.

Then make sure each picture is marked to move and size with cells.

Right click on a picture|Format Picture|Properties tab|move an size with cells.

An alternative that you may like better:
http://contextures.com/xlcomments02.html#Picture
(From Debra Dalgleish's site)
 

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

Sorting Pictures 2
Multiple Pictures and Text 1
Using clips in Excel 3
How to sort a list with Mr, Mrs, Miss ? 5
Automating finding pictures 1
add picture via drop down list 3
Matching Names 5
Copy a named picture 2

Top