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!

Your sure your pictures are within the cells (maybe turning on gridlines to
double check would help).

And (second guess): Did you select your range to sort and did you include the
column with the pictures?

(It worked fine for me when I did it.)

Don wrote:

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!

--

Dave Peterson

Thanks for responding Dave-
Every thumbnail has visible whitespace between the outside edge of the
photo and the gridline (I moved each manually to achieve this)
The sort range extends four couluns beyond the thumbnail column and
those columns sort correctly.
-Don

I tried what you described and it worked ok for me.

I don't have a guess why it's not working for you. Sorry.

Maybe someone can chime in with what I'm doing different???

Don wrote:

Thanks for responding Dave-
Every thumbnail has visible whitespace between the outside edge of the
photo and the gridline (I moved each manually to achieve this)
The sort range extends four couluns beyond the thumbnail column and
those columns sort correctly.
-Don

--

Dave Peterson