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.
Header and footer rows and header columns in a table can be used when you want to label rows and columns. They are automatically formatted to standout from the other rows and columns in your table. Let's use our Energy Saver spreadsheet here to explore using header and footer rows and header columns in our List Of Energy Savers table here. First step is to select the table. You can click anywhere in the table or click the name of the table in the Sheets pane. Now with our table selected, we can start adding header or footer rows and columns by using the Table menu.
Click Table and let's add a brand new header row. When we move down to Header Rows you will notice that our table currently has 0 Header Rows but we can choose up to 5. Let's add 1. We'll click 1 and notice the top row is added and it's formatted differently from the other rows in this table. We can do the same for our first column. Again we'll return to the Table menu, this time move down to Header Columns and we'll select 1. Notice the formatting is different here as well and a brand new column is inserted.
Now we do have the option to take all of the labels that already appear in our table and move them over into the first column, same thing for our top row, but there is a better option. So let's click Edit and Undo, Command+Z on your keyboard is another option to undo the last two steps and instead of adding new rows or columns, we might consider converting a row or a column into a header row or a header column. So we'll click anywhere in the top row.
Now when you move to the very far left hand side you will notice that our first row is labeled 1 and a little drop-down button appears. Select this and choose Convert to Header Row to convert the first row into a header row. Not only is it converted but it's reformatted and you can see the contents also appear nicely in our brand new header row. We don't have to shift any of the contents now. We can do the same for our column A; we'll move up to the header at the top of the column, move to the Drop- down button on the right side and choose Convert to Header Column. Formatting is applied and we now have a header row and a header column.
Let's just click anywhere inside the table itself, as if we were editing data. Now we'll use our down arrow to move down to the bottom of this table and you notice as we move down to the bottom we can no longer see a header row, we do have at the very bottom of this table some content. For it to move to the right hand side using the right cursor key on your keyboard you will notice the header column on the left starts to disappear, but when we are adding additional content or editing content, it can be very useful to see those labels.
So another option when working with header rows and columns is to freeze them. So first, we'll move up to the very top of our table, click anywhere in the header row, move up to the Table menu and this time we'll choose Freeze Header Rows. Nothing really changes in our table but now as we move down with the cursor key down to the bottom of our table, you will notice we'll always be able see that header row even though we continue passed what would fill up in entire screen.
We can do the same for our column on the left. Click the Table menu and choose Freeze Header Columns. Now as we move to the right, we'll always be able to see the full contents of column A. We can also create footer rows. This is row that will be formatted differently but at the bottom of your table. We can have up to five of them as well. Again, we'll click Table and choose Footer Rows then 1. You will notice as we scroll down now a new row has appear, this might be a good place for us to put in some formulas for totals and so on.
Another option for working with header rows, footer rows and columns is to use the Inspector. Click the Inspector button on the Toolbar, make sure that the Table Inspector is selected and you will see there is a Headers and Footers section. Here you have got three buttons. One for the Header Columns, one for the Header Rows and one for the Footer Rows. If you click these buttons, you will be able choose the numbers of rows or columns you need. Let's close up the Table Inspector. Now we are going to explore another scenario where you might be printing out the content in your table. In this case, we'll check out Print Preview.
In Print View mode click the button at the very bottom. You will notice that the content actually takes up four different pages and you will notice that as we scroll down to the next page that the header row appears on the next page, even though the table is cut off. Same thing as we move to the right hand side to those pages. We keep our header columns. Also in Print View mode, when we click the Table menu, you will notice it doesn't say Freeze Header Rows or Columns on Each Page but Repeat Header Rows and Header Columns on Each Page.
So depending on your view you will see different options from the Table menu. Let's switch back now to our Standard View. So header rows and columns in a table can be used for much more than just formatting.
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.