Xiao asks how to have a picture appear when you hover over a cell. Episode 1062 shows how to solve this problem. This blog is the video 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!
Hey, welcome back to the Mr. Excel netcast. I’m Bill Jelen. Face it you, you start out with a massive amounts of data. Say, how are you going to analyze this, well, let’s fire up activity table and see if we can solve this problem. Hey, welcome back to the Mr. Excel netcast, I’m Bill Jelen. Great question today sent in by Shell. Now Shell has a series of cells and when he hovers over the cell, he’d like to see a picture of that item. Now, this is a cool trick, it’s been floating around for a while. And the way that we’re going to do it is we’re going to create a comment attached to that cell. New comment and actually I’ll going to back space through, so that way there’s nothing in the comment at all. Now, I want you to notice that initially the comment starts out with diagonal lines around it. That’s not what I wanted. I want to click on those diagonal lines, that way they change to dots. Once their dots, I want to format that. So I can either right click and say format or press control one. And in control one, back here in colors and lines. I can change the color of the comment. Alright, well, that’s cool. But what I really wanted to do is I want to come down here to fill effects. Under fill effects, I can go back to picture, select a picture, and then I’m going to browse and find a picture. I’ll just choose one here. There we go. Nice bright belt. Click OK. And then here’s what happens. We click away, now we have our comment, the comment indicator’s there. When we hover over the comment, there is a picture of the item. Very, very cool trick. Hey, I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.