• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Excel Tips / Sort Pictures in a List in Excel

Sort Pictures in a List in Excel

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

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
Sort pictures in a list in Excel

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:

  • IMAGE function in Excel
    Excel IMAGE Function - Insert Images from a Cell Value
  • Moving average in Excel thumbnail
    Moving Average in Excel
  • Compare dates in Excel feature
    How to Compare Dates in Excel
  • Case sensitive XLOOKUP feature
    Case Sensitive Lookup with XLOOKUP in Excel

Reader Interactions

Comments

  1. Gary says

    6 July 2013 at 12:28 am

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

    Reply
    • computergaga_blog says

      7 July 2013 at 7:06 am

      Hi Gary,
      Difficult to know why without seeing the file. Can you send it.
      Alan

      Reply
  2. Maqsood Ahmad says

    28 July 2013 at 6:36 am

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

    Reply
  3. CLF says

    8 January 2021 at 4:14 pm

    I stumbled across this post in January 2021 while trying to resolve the same problem. If anyone else having this problem is still reading this, I have found that making the pictures slightly smaller than the cell size (completely encased as in the original post) will allow the sort to work properly. Even going to the trouble of setting the pictures to “exactly” the size of the cells while in Page Layout view did not work. Unfortunately, the pictures no longer resize when the cells are resized (even though “Move and size with cells” is checked), but that is a minor inconvenience in the table I am developing.

    Reply

Leave a Reply Cancel reply

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

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·