Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Tables are the fundamental building blocks of Numbers spreadsheets. They provide numerous ways to organize and help you interpret your data. And of course, you can have more than one table on a sheet. We'll use this Energy Savings Plans spreadsheet to explore adding tables. When you create a new spreadsheet from a template in the Template Chooser, at least one sheet with one table is added for you. But let's say we need to display Utility Costs by type, just as we have displayed them by month in the only table on this sheet so far. Notice the labels in the top row in the first column of this table. We could call this a header row and a header column. You will notice there is some math being performed in the bottom row.
We will keep this in mind as we add our new table, trying to keep the same look and feel. To insert a table you have the couple of options. You can access the Insert menu or click the Tables button on the Toolbar. Here you will see the different table formats to choose from. Headers has a header row and a header column already built-in for us. Basic table has a header row. Sums allows you to calculate totals of numbers that might appear in the various columns in a table. To start from scratch, you might select Plain and there is a couple of Checklist options here as well.
We are going to select Headers. When you choose Headers a default table is inserted for you. The default number of columns and rows. You will also notice the header row across the top and the header column using the formatting that's built in the template that was used to create this spreadsheet. Notice also in the Sheets pane that the table is automatically named and numbered for you. Of course, you can change the name of your table. Just double-click the current name in the Sheets pane and type over. Let's type in Utility Costs by Type. When you press Return the table is renamed. It also appears selected on the sheet and if you notice the table above, it has the table name appearing in the top left corner.
To do that we can take our selected table, move to the Format Bar and click the Name checkbox in the very far right hand side. Now the name of our table that we just created appears in the top left corner. You can deselect your table by clicking anywhere on the sheet outside the selected table. Another thing to keep in mind as well, every time you add a new sheet to your spreadsheet, click the Sheet button, a new table is added and created for you as well. So adding a table to a sheet in Numbers '09 is quite simple, but of course, there is so much more we can do with tables in Numbers '09.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70024 Viewers
80 Video lessons · 127422 Viewers
52 Video lessons · 62364 Viewers
59 Video lessons · 48067 Viewers
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.
Your file was successfully uploaded.