Tip:
Highlight text to annotate it
X
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.