Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
Cropping an image usually means cutting parts off, but in Numbers you can crop images without actually changing the image files by masking the edges instead to get rid of unwanted parts. Let's say we want to focus more on the house here at 1871 Meadow View Drive and we want to mask out the edges that appear around the outside of this image. Well in that case, we first select the image, then click Format and from the Format menu, select Mask. When you choose Mask from the Format menu, you are choosing the default shape to mask with, in this case the rectangle.
So you can see the rectangle and the mask and we can modify now the image itself as well as the mask. So for example, if we move down to the slider that appears with our Mask tool, we can click and drag that to the left to allow us to see more of the house. We can also go inside the mask and move that image around. So we can move the part of the house we want to focus on into the mask and when you click the Edit Mask button, you have the ability now to resize your image without affecting the mask. Once you have got it looking the way you want, then deselect by clicking anywhere on the canvas to see the end result. That looks pretty good.
Now that default mask, which is a rectangle in shape is only one option. You can actually choose any type of predefined shape if you want as a mask and you do that by first selecting the image. Let's focus this time on the house at 2799 Camino Court. Click that image first. This time we'll go to Format and choose Mask with Shape. Then you will see all of those predefined shapes available in Numbers '09 including a Rounded Rectangle.
So if you want rounded corners for example, you would choose this shape. Now you will see down below, we have got our mask. Of course, it needs to be adjusted and moved around. Let's size it first of all and we'll move our image inside the mask and if we want to use the slider to increase or decrease the size of the image until we get it exactly where we want, we can then click Edit Mask to move this into position and resize it.
Notice the rounded corners. If at any time you need to get back in there to make some adjustments, for example, we are seeing a little too much of the lawn down below, click Edit Mask again and make the adjustment. When you are done, click the canvas to deselect. Now you will notice that the image has rounded corners instead of those square corners that appear by default. And you can even mask an image with a shape that you have already drawn. Notice in this spreadsheet, we have got a pre-drawn shape. So if we want to use this as a mask, first we select the image that we want to mask.
Let's click the image at 1630 Maxwell Street. Hold down your Shift key and select the shape by clicking and now when you go to the Format menu, you will notice an option to Mask with Selected Shape. Go ahead and select that one and you will notice the shape stays over there on the right-hand side, but of course, you can click and drag to move that on top of your image right where it needs to go. You still have the slider and the Edit Mask button if you need to make adjustments. When you are done click the canvas to deselect and view the end result.
Now each time you select an image that has a mask, those tools will appear. So you can always adjust the mask or simply adjust the image itself and deselect at any time. So although there is no Cropping tool in Numbers '09, you can achieve the same effect with your images by using the various Masking options.
There are currently no FAQs about Numbers '09 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.