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