Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
Where does excel store the pictures of a userform's 'Picture' property? | Excel Programming | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
store cell contents and cell address for comparsion & suming | Excel Programming |