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.
If you plan to print your spreadsheet and it contains multiple sheets or multiple pages, you might consider using headers, footers and page numbering to help you stay organized. Let's work with our Milea Sales Data spreadsheet. It has multiple sheets and will print on multiple pages. Let's explore this by moving into Print View. Click the View menu and choose Show Print View. Here in our first sheet you will notice that we have got 2 pages. When we move to the second sheet called Current Listings we need to switch to Print View from here as well. This time click File and choose Show Print View. Altogether we have got three pages.
We will move back to our Sales Data sheet by selecting it in the Sheets pane. When we are in Print View and we move our mouse pointer to the top of the page, the header area will appear. Any content we want repeating at the top of every page can be entered here. Let's add some content now. We'll start by clicking inside the header area. Next let's ensure our content is centered. Click the Center button on the Format Bar. And now let's click Insert and choose Filename. This will insert the name of our file in the header section. Let's leave a space and add a dash and leave another space and this time we'll insert the current date.
Again click Insert. This time choose Date & Time. This will appear at the top of the second page as we scroll down and view that header area as well. We can also work with the footer area. Let's move to the bottom of the first page. When the footer area appears, click inside. Again, we want our content centered. Let's click the Center text button on the Format bar. And this time we'll insert the Page Number and the Page Count. Let's start with some text. Type in the word Page and leave a space. Now we'll click Insert and choose Page Number. Let's leave a space, type the word of and leave another space and insert the page count. Click Insert and choose Page Count.
Notice a 3 appears. Automatically Numbers realizes we have got two pages in our first sheet and another page in our second sheet. As we scroll down to the bottom of Page 2, we'll see this content repeated at the bottom of the page. When we move to our Current Listing sheet, select it in the Sheets pane, you will notice we have nothing in the header or footer areas for this particular sheet. We need to add that. Let's move down to the bottom of this single sheet. Click at the bottom inside the footer area. Click the Center button to center our content. And let's type in the exact same thing here, Page. Leave a space. We'll insert the page number.
When you click Insert and choose Page Number, notice a 3 appears. Leave a space, type in the word of, leave a space and insert the Page Count. If you want numbering to start over on a new sheet, we can access options from the Inspector. Click the Inspector button on the Toolbar and make sure the Sheet Inspector is selected. Notice in the Page Numbers section automatically our numbering continues from the previous sheet. If we choose to Start at 1 and remain with the number 1, notice we are at Page 1 of 1 for this sheet.
So the choice is totally up to you. Close the Sheet Inspector when you are done. To get out of the footer or header area just click anywhere on your sheet and view the end results. So remember headers and footers when you need to display content at the top or bottom of every printed page in a sheet including page numbering when working with more than one printed page.
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.