Excel: Sort Pictures With Data

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: My manager wants me to add employee pictures to the department phone list. I need the pictures to sort with the data.

Strategy: By default, this will work. Each picture has a property that will cause it to move but not size with cells. To see the property, select the picture and press Ctrl+One. There are 16 categories in the left bar of the Format Picture dialog. Near the bottom, choose Properties. The Move But Don't Size with Cells should already be selected.

  1. Sort the list alphabetically.

    Gotcha: I am guessing that you wouldn't be looking up this topic unless the sort already failed for you. I've had to troubleshoot this before and it always comes down to one issue.

    Select one cell in column A and sort with the AZ button. The pictures should move with the names.

  2. The pictures will sort with the rows.

    The process of inserting and resizing pictures is a mind-numbing process. You must be certain that every picture is completely contained within one cell. If the picture extends by even one pixel over the top edge of a cell, it will not be sorted correctly.

  3. This picture is a few pixels too high. It will not sort..

For more resources for Microsoft Excel