Forum Discussion
Tyler Lybbert
Jul 18, 2018Copper Contributor
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...
Matt Mickle
Jul 18, 2018Bronze Contributor
Hey Tyler-
1.Right Click on the image.
2.Select move and size with cells
See attached file for reference.
Tyler Lybbert
Jul 18, 2018Copper Contributor
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?
- SergeiBaklanJul 18, 2018Diamond Contributor
Image size shall be not more than cell size, see https://excel.tips.net/T002954_Sorting_with_Graphics.html
And attached
- Tyler LybbertJul 18, 2018Copper Contributor
That worked! Thanks to both of you!