Forum Discussion

Copper Contributor

Jul 18, 2018

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...

Test_Excel_Images.xlsx34 KB

excel

Matt Mickle

Bronze Contributor

Jul 18, 2018

Hey Tyler-

1.Right Click on the image.

2.Select move and size with cells

See attached file for reference.

Test_Excel_Images v1.xlsx34 KB

Tyler Lybbert
Copper Contributor
Jul 18, 2018
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?
- SergeiBaklan
  Diamond Contributor
  Jul 18, 2018
  Image size shall be not more than cell size, see https://excel.tips.net/T002954_Sorting_with_Graphics.html
  
  And attached
  Test_Excel_Images v1.xlsx33 KB
  - Tyler Lybbert
    Copper Contributor
    Jul 18, 2018
    That worked! Thanks to both of you!