I can add images to a sheet but wondered whether it was possible to fix the images to a cell, so that when the data is sorted the images will move with the sort. I am using Excel 2003 SP2.
I can add images to a sheet but wondered whether it was possible to fix the images to a cell, so that when the data is sorted the images will move with the sort. I am using Excel 2003 SP2.
Make sure each picture is completely within the cell or row. And include its column in the range to sort. When my pictures don't sort correctly, it's usually because the picture was just a bit outside the row/cell.
Well the way Excel handles image is different. It does not take them as text or values. So the result which you will get will be different. But if you had placed properly a image inside a cell then there can be hope of using sorting feature. You can insert links of image inside the sheet and then make the sorting arrangement as you want. Trying to do that directly in Excel can be complicated.
Bookmarks