After you add images and shapes to your workbook, you need to arrange those objects on the page. You can arrange objects by dragging them around, but you can arrange the items more precisely by using some built-in Excel commands.
- [Instructor] After you add images and shapes to your workbook, you will need to arrange them on your page. You can arrange objects by dragging them around, but you can arrange them more precisely by using some built-in Excel commands. I will demonstrate how to align and distribute your images in this movie. My sample file is the Aligning workbook, and you can find it in the chapter eight folder of your exercise files collection. In this workbook, I have two images and a shape. On the left you can see a compact fluorescent light bulb, in the middle, solar panels, and on the right a shape with CFL to solar.
Let's say that I want to align these items so that they are centered, in other words, I want them to be centered vertically so that the middle of this shape is aligned with the middle, again vertical middle, of this photo and of this image. To do that, I can select the shapes. I'll start by clicking the light bulb, and then hold down the command key, and select the middle image and then the shape on the right, also holding down the command key to select them all.
And you can see that I get a couple of contextual tabs at the top, one is for shape format and one is for picture format. It doesn't matter which one I select, so I will click shape format, and you can see that I have a number of options. I'm gonna look about two-thirds of the way to the right and there I see the Align button, I'll click that, and you can see that I can align them horizontally so that they are left-centered or right-adjusted, and then what I'm interested in is vertical.
I can align them so the top edge, middle, or bottom edge is the same for all of the items here, all of the objects. I want to do the middle, so I'll click align middle, and you can see that they're aligned. They were pretty close before, but now they definitely are. If I want to align by the bottom, then I can, with them still selected, click the align button, click align bottom, and there we are, and as always, command Z will undo whatever was the last thing that you did.
Now let's see what happens if I move the images around, so I'll click away so that none of the images are selected, and I will drag the light bulb image to the right. And you can see as I do that it goes behind the solar panel image. The reason that happens is that I added this picture second, you can see it's title is Picture Two. If I want to bring this image to the front, then I can select it and then go to Picture Format, go to the reorder objects button, and here, you see that I have the light bulb at the bottom, then I have the solar panels in the middle, and the shape at the top, so let's say that I want to move the light bulb on top of the solar panels, and you can see that I just dragged it.
So if I drag it back it goes behind, if I drag it to the right it goes ahead. Now I'll click okay. There I have my images, and now if I drag the light bulb to the side, you will see that in fact, it goes in front of the solar panel image, and if I drag CFL to Solar, because it was at the top level, it goes atop of all of them. Now let's say that I want to distribute these images, and I'll distribute them horizontally.
To do that, I'll need to click the edge of the image and then drag it, there we go, and then I'll do the same thing for the light bulb, drag that over to the side, and I'll put that a little bit further away. So my goal is to distribute these images equally so that they are the same distance away from each other, so there's the same gap between the light bulb to solar panel and the solar panels and the shape. So I will select all three images, and once again, I will do command click, and then on the shape format, contextual tab, I'll click the Align button, and I will distribute them horizontally.
You can see that they are now distributed, and if I want to even them up, again, aligning by middle, I can click Align, click Align Middle under the Vertical subheader, and now they are both aligned and distributed. The techniques that I've shown you in this movie will help you arrange your images precisely, letting you focus on creating great documents instead of struggling to align and layer the images by hand.
- 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