Sunday, 4 May 2014

Sort Data along with pictures

Hi !

A yet another common problem that people face in their data is why pictures do not get sorted when we sort the data. Specially in product industry, where each and every depiction is via pictures, work become really tedious when it comes to task like sorting and filtering data.
What practically happens is data gets sorted while the placement of pictures gets distorted.

So here's a simple solution:

Before performing the task of Sort/Filter we need to ensure following things in our data:


  1. Cells are not merged
  2. Every individual picture appropriately fit in exactly one cell
  3. For pictures, the property is set to "Move but don't size with cells". To do this you may right-click the picture , select "Size and Properties" option and change the property under "Properties" Tab. Below is the screenshot for reference.
            
Size and Properties window for picture


Now, try using filters or sort your data based on any field and you will notice pictures moving along with it.
Below is a capture of sample data file with ideal settings:

 

So, this is how the column that contains pictures should look like.

Hope this helps !!All the best !!