Watching:

Laying out sheets


show more Laying out sheets provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Laying out sheets

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.

Laying out sheets
Video duration: 3m 7s 3h 53m Beginner

Viewers:

Laying out sheets provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...