Apple iWork 08 Tutorials
Create Dynamic Spreadsheets / Format a Table
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Apple iWork 08 / Create Dynamic Spreadsheets / Format a Table)
Alright. I've started to create a dynamic spreadsheet here and I've done that by using a template that we already have premade for us and I added a blank sheet and then started to add a table to that sheet and apply a style. Now, the style that I created or the type of table I created was a basic table. Now, if I want to change my mind later on and I say, you know what? I want a sums table instead and I add it, what happens is this. You'll get a new table that's in the spreadsheet. So I'll select it and make it go away with delete. How do I do that same thing to this basic table if I want a little section for adding up all of the numbers that might be in this column right here? Well, I can do that using the format bar and if I look at these buttons over here on the right-hand side and in this resolution I've got to click and drag my Numbers window all over the screen as you can see. So it shouldn't be as big a deal to be able to do this on your screen resolution, but nonetheless, I select the table and then I have the ability to add a first column for row names and a row that remains at the bottom of the table for sums. Typically, but it doesn't have to be sums. You can put anything you want to in that footer row. So I've got these elements. I could also have done the same thing by using the table menu here. You can have header rows, footer rows and so on. And so now, if you apply different styles, of course those styles are going to dictate how the table looks and of course we'll create those styles as we go along. What you also have the ability to do is give the table a name and you do that by double clicking on the table name in the styles menu here, so give this a double click and this is new table we'll call it and press return to make it effective. Now, you don't see that show up in the document itself, but again, I can do that by using these buttons, select the table and give that a checkbox. So now I see that new table is indeed the title of the table, just like it is right here. Now, you don't edit this directly, as you can see, but you edit it right over here if you want to change name, then the name changes up here a well. So now that goes with the tables so if I decide to move the table around and resize it, whatever the case may be, the title goes with and again I can toggle that on and off with that checkbox that was in the right-hand portion of my format bar.
Tutorial Information
| Course: | Apple iWork 08 |
| Author: | Brian Culp |
| SKU: | 33851 |
| ISBN: | 1-934743-50-X |
| Release Date: | 2008-02-07 |
| Duration: | 6.5 hrs / 105 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
