| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graphic Images: Can I Put One in a Cell as Mouse Rollover Only? | New Users to Excel | |||
| inserting images into a single cell | New Users to Excel | |||
| display different images based on cell value? | Excel Worksheet Functions | |||
| Extracting multiple entries in a cell into their component pieces | Excel Worksheet Functions | |||
| images on a cell | Excel Discussion (Misc queries) | |||
Linear Mode
