Sort Pictures in an Excel List

If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list.

The good news is that you can sort pictures in an Excel list just like you would sort text and numbers. However there are some settings you need to make sure are set before you go sorting that list.

Let’s look at sorting the list below from largest to smallest (descending) by the sales column.

Unsorted Excel list including pictures
Unsorted Excel list including pictures

Sort Pictures in Excel

Firstly you need to ensure that the pictures are completely inside the cells. If they touch any of the borders of the cells they will not sort with the list. Change the size of the pictures and the height and width of the cells as necessary.

The next step is to make the pictures move with the other cells when you sort the list.

  1. Right mouse click on the picture and select Size and Properties
  2. Click the Properties tab
  3. Select either the Move and size with cells or Move but don’t size with cells option
  4. Click Ok

Move pictures with the cells when sorting the list
Move pictures with the cells when sorting the list

The pictures will now be sorted with the other data in the list.

Sort pictures in an Excel list
Sort pictures in an Excel list

3 Resources to Make you Awesome in Excel

Excel School

Excel School is structured and comprehensive online training program for learning Microsoft Excel. It is full of real world examples.

Online Excel Training

Hundreds of online video training from real world experts in Excel and many other applications.

Microsoft Excel Training

Microsoft Excel training guides and quizzes. Training on all versions and levels of Excel.

More by this Author


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working