Sort Pictures in a List in Excel

2 Flares 2 Flares ×

If you are storing pictures in a list in Excel, then you need to make sure that you can sort the pictures in the list. Unless a few steps are taken in advance you will not be able to sort pictures in a list.

Imagine you have a list of products and you have a picture of that product in one of the columns. When you sort the list by product name, price, or number sold you will want the pictures to move with the appropriate product.

There are two things you need to ensure are setup before this can happen;

  • The picture is completely encased within the cell like in the image below

List of pictures

If the picture overlaps any of the cell borders at all then the sorting will not work. Resize the width and height of each cell as necessary

  • The Move but don’t size with cells setting must be on in the picture properties

Set the Picture to Move with Cells

The following instructions and images are based on using Excel 2010. A similar procedure can be followed for Excel 97-2003 and for 2007.

  1. Select the picture you want to format
  2. Click the Format tab under Picture Tools on the Ribbon
  3. Click the Dialogue Box Launcher arrow in the corner of the Size group on the far right of the Ribbon

Opening the Picture Properties dialogue box

  1. Select the Properties category in the dialogue box

Set the picture to move with cells in a list

  1. Ensure that the Move but don’t size with cells option is selected
  2. Click Close

The picture properties dialogue box can also be opened by right clicking on the picture and selecting Properties in most versions of Excel.

Related Posts

Lookup a Picture in Excel

3 thoughts on “Sort Pictures in a List in Excel

  1. Hi,
    I have been looking everywhere for assistance on this exact subject.
    I have finally found your detailed answer, unfortunately I still cannot get this to work.
    I am using Excel 2007. When I sort the data the pictures remain static.
    Please help me..!!

  2. Hi , Garry

    i was looking for solution for Sort Pictures in a List in Excel ,tried what you mentioned but pictures still remain static , Please help ,it will be of great favor.


Leave a Reply

Your email address will not be published. Required fields are marked *