Forum Discussion
Sorting with images
Try these steps and tell me why it does this and how/if it can be fixed.
1. Open the attached spreadsheet (Test_Excel_Images.xlsx)
2. Filter column B so that you only see "Upper" (uncheck "Lower")
3. Notice that it still leaves row 6 visible but with only the image inside cell C6
Why does the image in C6 not get hidden along with the rest of the row? It should be getting filtered out.
4 Replies
Hey Tyler-
1.Right Click on the image.
2.Select move and size with cells
See attached file for reference.
That fixed the filtering problem (thanks) but now when I sort one of the columns (say, column A) alphabetically A-Z, the images don't appear in the correct rows anymore. Any ideas?
Image size shall be not more than cell size, see https://excel.tips.net/T002954_Sorting_with_Graphics.html
And attached
