Store a picture in a cell
 

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,

Store a picture in a cell
 

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" wrote in message
...
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,

Store a picture in a cell
 

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 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,

Store a picture in a cell
 

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"