I need to sort this data by 2 columns - first by column B (ie: Product column) in alphabetical order and then by column D (ie: Quantity) smallest to largest.

Then select the Data tab from the toolbar at the top of the screen.

In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z).

In this example, we want to sort next by the Quantity column (column D) in Smallest to Largest.

Excel Lock Sort Download Arrow In

If you get a preview, look for the download arrow in the upper right hand corner.

Each row shows a different photo with a number, a random letter and the name of the photo.

I can sort the data range by the cell color, and again the photos will follow.

Ill select any one of the cells in column C (make sure to select the cell and not the photo), then click on the Data tab, then the sort command and set up the sort by the colors I want to rearrange my data by.

Here is an example of where the Flowers photo is a little too high in row 5.

Excel Lock Sort How To Tie Photos

If youd like to see two posts I did regarding how to tie photos to a Data Validation drop down list, check out these links.

Did you try to copy just a smaller subset of your file to see if the size has some affect Are all your images contained within the cell and not overlapping.

Excel For Mac Lock Sort