| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Objects with the rest of the cells
Hi,
I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Objects with the rest of the cells
The object must reside entirely within the boundries of a cell to sort. Also
it must be formatted to move with the cells. What type of object are you using? -- HTH... Jim Thomlinson "Garrett" wrote: Hi, I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Objects with the rest of the cells
THANK YOU!! That worked perfectly. I was linking word docs to accounts. I
used an icon to represent the file but I did not have the cell big enough. Once I adjusted the size of the cell the data sort perfectly. Thanks again!! "Jim Thomlinson" wrote: The object must reside entirely within the boundries of a cell to sort. Also it must be formatted to move with the cells. What type of object are you using? -- HTH... Jim Thomlinson "Garrett" wrote: Hi, I have a spread sheet that contains links to files on each row. These objects have been inserted in and link to a specific file that is related to that row, however when I sort my columns the objects do not sort with everything else. Bascially after i sort, say alphabeticlly, the object is still in the same place even though what it relates to has moved. Can anyone please help! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping objects with cells | Excel Discussion (Misc queries) | |||
| how do I copy all cells and all objects in a sheet together? | Excel Discussion (Misc queries) | |||
| Can I lock data into few cells in sheet and clear the rest | Excel Discussion (Misc queries) | |||
| Linking then Sorting Objects of the Link - Is this feasible? | Excel Discussion (Misc queries) | |||
| Thumbnail pictures in cells don't sort with rest of row | Excel Discussion (Misc queries) | |||
Hybrid Mode
