Hi-
We use Excel for student grades here and we like to print the pictures
of each student in their assigned small group. These small groups
change membership frequently and the "Sort" function in excel is an
easy way to keep track of which student is assigned to ehich small
group tutor.
I've placed a small thumbnail photograph of each student into a column
"PHOTO".
The thumbnails have been converted to "picture metafile" format and are
entirely contained within the cell. Each picture property is set to
"Move, but don't resize". Tools-Options-Edit has "Cut, copy and sort
objects with cells" checked.
I can manually cut and paste such a cell in another location and the
thumbnail travels with the cell.
Unfortunately, when I sort the worksheet, nearly all the photos end up
in the top row. (A few travel with their respective student name, but
I can't discern Any difference between these correctly sorted
thumbnails and the incorrectly sorted thumbnails.)
We're running Office 2003 SP1.
Any suggestions would be much appreciated!