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.
You can change your table's appearance by modifying the attributes of the table's style but you can then redefine the style with those changes and all of the tables in the spreadsheet that used that style will also be updated to reflect the changes. That's aside from any overrides that might have been applied of course. Let's work with the three tables that appear here on our Sales Data sheet. We'll make some changes to one of the table. So first, we'll move to the Sheets pane and select the 2006 - 2008 Sales Data table. With our table selected, we can start making changes.
Let's say we want to use a different font throughout the table. So with the entire table selected, we'll click the Font button on the Format Bar, let's change it to Arial. Type the letter A on your keyboard to move quickly to the fonts beginning with the letter A and click Arial. Now all of the contents throughout this table use the Arial font. Now we are going to make a change to a portion of our table. Let's use the header column. Here we see a beige background. We'll click and drag from the first cell in the column header all the way down to the last one, and with those cell selected we'll change the Fill to Black. We can also use the Format Bar for that. Click the Fill button and choose Black from the list of color swatches. You can see how that stands out.
Now let's say we want to turn off the alternating row colors we see throughout this table. In that case, we'll need the Table Inspector. Click the Inspector button, make sure the Table Inspector is selected and down at the bottom where we see Alternating Row Color, we'll deselect that checkbox. The alternating colors disappear from our table. So we can close our Table Inspector and let's deselect the table by clicking on the canvas to see those changes. All right, so far we've been overriding the attributes of the table style.
In this case, you can see when we select the table again the style being used is called Connor Real Estate. This is a style that was created specifically for the spreadsheet. Now if we want to redefine this style, we'll click the arrow to the right of the name, choose Redefine Style from Table and watch what happens to the other tables that used the Connor Real Estate style. You can see they are updated with those changes as well. The fonts are changed, the column header changes its background color and you can see the alternating row colors also disappear from those other tables. We've just redefined the style. That's how we change the table style attributes in Numbers '09.
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.