Making images a cell component

[Ricardo]

I have set up a spreadsheet model for my pupils based on the F1 motor racing
season. As well as the other attributes I wish to add each driver's helmet
as an image. I would like these images to move with their driver each time
the data is sorted. Any ideas?

 

[Dave Peterson]

Make sure you put the image completely in the row or cell. Then include that
column when you sort the data.

 

[Ricardo]

Hmmm, I tried that but the image simply sits on top like a free-floating
entity.

 

[Ricardo]

Hmmm, I tried that but the image simply sits on top like a free-floating
entity.

 

[Dave Peterson]

Images will always float on top.

Did you select the range to sort or did you let excel guess?
Did you include the column with the pictures in the range to sort?
Are the rows high enough to make sure that each picture is within the row after
you sorted?

And check to make sure that the picture is set to move with the cells
rightclick on each picture
Format|Picture|Properties tab
Move and size with cells (or move but don't size with cells)

 

[Ricardo]

Excellent, thanks Dave

Got that working now.