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.
The way you layout your sheets in a Numbers '09 spreadsheet can be very important, especially if you plan on printing them out. Let's explore some Layout options using our Running Club Data spreadsheet, which as you can see from the Sheets pane is comprised of a single sheet containing a couple of tables and a chart. This content, as we scroll down appears to fit nicely. What we don't see is what this will look like if we were to print it out on paper. To see that, we need to change to Print View, which can be done from the File menu or from the View menu, you will find Show Print View; Show Layout is the exact same thing.
Or, if you prefer, click the Print View button at the bottom of your screen on the Status bar. In Print View, we can see the actual pages, the way they will appear if printed. Notice that our table at the bottom of Page 1 gets cut off and continues on the second page. We can rectify this problem by changing some of the Layout options. One way to do this is to use the Inspector. Click the Inspector button and choose the Sheet Inspector. Let's start with our Page Layout.
Currently our pages are laid out in a landscape or horizontal orientation. If we change this to portrait or vertical, notice that the full length of our table now fits on the first page, but content is getting cut-off on the right hand side. Currently, we need to print four pages to see all of our content as is displayed by the Content Scale field here. At 100% we require four pages, but we can adjust Content Scaling by using the slider, the Up and Down arrows or the Content Scale slider that appears now at the bottom of our screen on the Status bar.
When we drag the button to the left, we reduce scaling of the content till eventually it all fits on a single page. Notice this is at 88%. Now we see one page appearing above the field where 88% shows up. Another option is to adjust Page Margins. If you wish to increase the amount of space for your content, you can change the values for each of the margins for Left, Right, Top and Bottom by using the Up and Down arrows or by entering a value yourself.
Let's change the Left and Right margins to 0.5. One option is to select the contents and type in 0.5, another option is to use the Up and Down arrows. We can also do the same for the Top and Bottom. Let's adjust the Top margin down to 0.5. Everything still fits nicely on a single page, but it's spaced out nicely as well. When you are done with the Sheet Inspector, click the Close button and if you want to return to Standard View, you can click the same button on the Status bar or access Hide Print View from the File or View menus.
So if you plan on printing out your sheets in a Numbers '09 spreadsheet, remember some of the Layout options available through the Inspector and the Status bar at the bottom of your screen.
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.