Companies that sell products or services often use photos and other images to help describe what they offer. In this video, learn how to add images to your worksheet and edit them afterward.
- [Instructor] Companies that sell companies or services will often use photos and other images to help describe what they offer. In this movie, I will show you how to add images to your worksheet and edit them afterwards. My sample file is the Manage Images workbook and you can find it in the chapter eight folder of the exercise files collection. This workbook is blank and it has one worksheet. And what I want to do is to add an image and then use that image as the source for later edits.
To insert an image, go to the Insert tab of the ribbon and then, on that tab, click the Pictures button. And then click Picture From File. I'm clicking Picture From File so that I can select a graphic or image from my computer. If I were to click Photo Browser, then I would get a web interface that would link me to other images that I could use. However, I want to be certain that I have all the rights required to use the image that I select, so I will click Picture From File.
When I do, a dialog box opened and it's essentially an open dialog box. And you can see here that I have three images I could select from. Light bulb, solar panels, and turbines and panels. I will click turbines and panels, which is a JPEG image, and click Insert. And when I do, it appears in the body of my worksheet. And also, you see that the Picture Format contextual tab of the ribbon has appeared as well. There are a lot of things that I can do. As you see, there are a lot of controls so I'll just go over a few of them.
Let's say I want to move the image. It's like any other object, you can just click it and drag to change it's position. If you want to resize it, you can either do that by dragging left or right with the handles. I've made two changes, so I'll press Command Z once and then twice to Undo them. If you want to change the height or width and maintain what's called aspect ratio, then, on the Picture Format contextual tab, you can go over almost all the way to the right side and you see here that there is a Shape Height box and a Shape Width box.
Within each of the boxes is the measure and I'm in the US, so we're using inches. Also, you see this check mark here and that is the Lock Aspect Ratio checkbox. If you want to keep the aspect ratio of your image and be able to change it without distorting the image, that is changing its proportions, then you need to keep that selected. In this case, let's say that I want to make my image so that it is only two inches high. So I will select the value in the height box.
Type two, press Return, and it changes, maintaining the aspect ratio. So I have two inches in height and 2.61 inches in width. If I want to apply a format, including a frame to the image, I can do that. I'll drag it a little bit closer to the center so you can see. To do that, I will go to this gallery here. I call it the Image Style gallery. So I'll click that and you see that there are a bunch of different images that are available.
I'll go for the first one on the second row, which is a thick, matte border or frame in black. So I'll click that. And when I do, you see the type of image that we get. If I wanted to go for a different style, I could click that. Click the down arrow for the gallery. And let's say that I will go for one with a drop shadow and rectangle. And there we go. So it's a slide-out line and you can see that there is also a very mild drop shadow behind it.
You can correct the color if the image doesn't look right on your monitor. You can go to Corrections and you can sharpen it or soften it or change brightness and contrast. In this case, I think the image looks pretty good, so I'll click away, but you could apply any of those by clicking them. You can also change the colors. You can go to No Color Saturation, which is almost black and white, it's basically the same. Or you can change the color tone by increasing its temperature and you can see how that effects the different colors.
At 8800, the yellow really pops out. And you can also change the color scheme entirely. So, for example, you can stay with no recolor. You can go to grayscale, sepia tones. Let's see what that looks like for this image. There we go. An old time, sepia photograph of windmills and solar panels. And as you can see, there are a lot of other changes that you could make. Photographs help bring your worksheets to life. If you use Excel to manage a product catalog, for example, displaying images of your products adds visual appeal beyond the information contained in your worksheet.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks