Making images a cell component
 

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?

Making images a cell component
 

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

Ricardo wrote:

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

Making images a cell component
 

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

"Dave Peterson" wrote:

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

Ricardo wrote:

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

Making images a cell component
 

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

"Dave Peterson" wrote:

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

Ricardo wrote:

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

Making images a cell component
 

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 wrote:

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

"Dave Peterson" wrote:

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

Ricardo wrote:

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


--

Dave Peterson

Making images a cell component
 

Excellent, thanks Dave

Got that working now. :-)

"Dave Peterson" wrote:

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 wrote:

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

"Dave Peterson" wrote:

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

Ricardo wrote:

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


--

Dave Peterson