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.
Formatting text in a table cell can be accomplished by selecting a single cell or a range of cells. Let's format some text appearing in our tables in the Running Club Data spreadsheet. We will begin with a single cell. Let's click cell A2 in our first table named Distance Run - Men. Here we see the abbreviation for January on the left side of the cell. With our cell selected, we can use the Format bar to both view and change a wide range of formatting options. Notice the first button displays the font family being used. We can click this button to see a long list of font family names listed in alphabetical order.
Let's choose Arial Black. This updates the change instantly in our cell and the name now appears on the button. Let's say we want to make this a little bit smaller, we can access the Size button here. Let's change the point size from 12 points down to 11. We also have the ability to change the color of our text in this cell. Let's choose the Text Color button where we a list of swatches, but if you want to access few more colors, click the Show Colors button at the bottom to open up the Colors window.
Now you have a wide range of opportunity to choose a different color. From the crayon box, let's choose a nice dark gray. When we are done, we can close the Colors window. We can also adjust alignment of our cell text. Notice the Left Align button currently appears shaded, but we can Center it or even Right Align our text. Let's choose Right Align to move it to the right side of our cell. Now we can adjust Vertical Alignment as well, if we were to adjust the row height for our table, we might want our text to be centered vertically.
Currently, you can see the first button appears shaded indicating that out our text is going to be aligned to the top of our table cell. Let's choose center. Now if we were to move down, in between rows 2 and 3, for example, where we see the double arrow and drag this down. Our text remains centered in the cell vertically. Let's drag that up a little bit. And move on to the Format menu where we'll find some additional formatting options. Our cell still selected. Click Format. And at the top you will see Font.
Let's try changing Capitalization. At the bottom of the sub-menu Capitalization appears a check mark next to None. The only capitalization we see is the capitalization we applied manually. But if we wanted this to appear in small caps, where each character is capitalized but the first character appears a little larger than the rest we would select Small Caps. It's a nice effect. Now there are some additional options available through the Text Inspector. With the same cell still selected click the Inspector button and ensure the Text Inspector is selected. Now with the Text button selected we can adjust the Color & Alignment from here as well. But we also have access to some Spacing options such as Character spacing currently defaulted at 0%. We can spread the characters out a little bit by dragging the slider to the right. Let's go to about 10%. Line, Paragraph Spacing and Margins applied to paragraph text, so we'll leave that for now and close the Text Inspector.
Now the really nice thing in Numbers is if we like the end result of our formatting, we can copy it to other cells. So with cell A2 still selected, let's go to the Format menu and choose Copy Style. Now we can paste that style to the remaining cells in this column, click and drag from Feb down to Sep, go back to the Format menu and choose Paste Style this time. The same styling that we applied to our first cell is now applied to the remaining cells.
Our style is still copied, so all we need to do now select the other cells in the other tables and paste it there as well. We'll repeat that for our Goals tables. And now deselect the table by clicking the canvas anywhere to view the end results better. So with Numbers '09 text formatting options, the possibilities are endless.
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.