Join David Rivers for an in-depth discussion in this video Headers, footers, and page numbering, part of Numbers '09 Essential Training.
- View Offline
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.
- Exploring and customizing the user interface
- Creating, importing, and laying out spreadsheets
- Working with, modifying, and reusing tables
- Using the Formula bar and Formula Editor
- Formatting chart attributes in 2D and 3D
- Inserting media files and manipulating objects in a spreadsheet
- Sharing spreadsheets via print, email, and iWork.com