![]() |
Sort data with pictures in cells
There is already a post about this, but the advice didn't work for me.
I need to sort some data with pictures in some of the cells. I have made sure the pictures can be "moved with cells", and the row height is enough to include the whole picture in the cell. But when I sort the data, the pictures remain static. I can sort pictures perfectly in this way using Excel 2003, but not 2007. Any other ideas? Thanks very much. |
Sort data with pictures in cells
1) The sorting should work fine even with "2007" - as long as you keep the
pictures outer frame(s) away from the cells border(s) so they DO NOT(!) touch each other. 2) You might consider to hold the pictures in cell "COMMENTS" instead of inside cells. This will also assure correct sorting of the data. Micky "Hobbes" wrote: There is already a post about this, but the advice didn't work for me. I need to sort some data with pictures in some of the cells. I have made sure the pictures can be "moved with cells", and the row height is enough to include the whole picture in the cell. But when I sort the data, the pictures remain static. I can sort pictures perfectly in this way using Excel 2003, but not 2007. Any other ideas? Thanks very much. |
All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com