In Excel 2003, is it possible to store a picture in a cell so that if a 
spreadsheet is sorted, the picture will sort with the rest of the cells?
Thanks,

Excel doesn't support storing pictures in cells: they are always positioned 
over the cells.

If you need to support sorting with pictures, you'll need some kind of event 
macro to reposition the pictures after sorting.
For this to work you'd also need some way of tying the pictures to the 
correct cell - how you do this depends on what else is in the table being 
sorted.

For example, you could name the pictures based on the cell content (provided 
there's some unique value you can use to find the correct cell to reposition 
each picture over.


Tim

"JackGombola" <Gumby@verizon.net> wrote in message 
news:78BA0E38-4C6B-4F14-A863-CEA96406068D@microsoft.com...
> In Excel 2003, is it possible to store a picture in a cell so that if a
> spreadsheet is sorted, the picture will sort with the rest of the cells?
> Thanks, 

Pictures actually float on top of cells, so cannot be 
inserted" in a cell.

But............You can sort pictures with cells if the image is small enough
to fit within the confines of the cell.

And properties are set to "move and size with cells"


Gord Dibben  MS Excel MVP


On Fri, 15 Jan 2010 18:10:01 -0800, JackGombola <Gumby@verizon.net> wrote:

>In Excel 2003, is it possible to store a picture in a cell so that if a 
>spreadsheet is sorted, the picture will sort with the rest of the cells?
>Thanks,

On Sat, 16 Jan 2010 12:38:16 -0800, Gord Dibben <gorddibbATshawDOTca>
wrote:

>Pictures actually float on top of cells, so cannot be 
>inserted" in a cell.
>
>But............You can sort pictures with cells if the image is small enough
>to fit within the confines of the cell.
>
>And properties are set to "move and size with cells"
>
>
>Gord Dibben  MS Excel MVP


  It also works with "move but do not size"