MrExcel's Learn Excel #940 - Sort Pictures with Data

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 30, 2009.
Steve wants to know how to sort pictures with the associated data. There is an obscure setting that controls if pictures sort with the cells or not. Episode 940 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Today, the question’s sent in by Steve.
Steve wants to know how I can have a picture in a cell and have that picture sort with the data, and we're going to talk about this.
Let’s insert a picture.
So, we come here to INSERT, insert PICTURE, we'll choose one of the pictures, and I want to resize that so I hold down the SHIFT key.
I make it small enough to fit in the cell.
There we go.
Okay.
By default, Steve, that picture is going to sort with the cell that it's in.
So, I have headings up here and I'm going to sort, let's say, AtoZ, so, go to DATA, click SORT ASCENDING, and you'll see that the pictures sorted with the cells that they were in.
Now, if that's not happening for you, someone has changed the property of the picture.
You want to right-click the picture.
In Excel 2003, go to FORMAT PICTURE, in Excel 2007, SIZE AND PROPERTIES, and go to the PROPERTIES tab.
In either place, you're going to go to the PROPERTIES tab, and someone's probably unchecked MOVE BUT DON’T SIZE WITH CELLS and you probably have DON’T MOVE OR SIZE WITH CELLS.
So, there is a way to turn off that ability to have the picture move but, provided you have a heading above the column of pictures and you haven't changed that setting, the pictures are going to sort with the associated cells and come right up to the top.
So, great question.
Obviously you have some sort of a product catalog and you want the picture of the product to travel with the data.
That's a great idea.
Not many people are using pictures in Excel, but if it's not working for you, then someone has gone into those pictures and changed that property.
You want to change it back so that way it'll move with the cells and you'll be good to go.
I want to thank Steve for sending that question in and I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top