Store a picture in a cell

  • Thread starter Thread starter JackGombola
  • Start date Start date
J

JackGombola

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
 
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
 
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
Click to expand...


It also works with "move but do not size"
 
Back
Top