Start learning with our library of video tutorials taught by experts. Get started
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 manipulate cells in a Numbers '09 table to better organize your data. This can be done by splitting cells, merging cells together, even adding comments. Let's start with splitting cells using this Current Listings table. It would appear some of the cells have already been split. Let's do the rest. First we need to select the cells. Click and drag from the first address that appears in it's own cell, all the way down to the bottom row. This is cell A5, all the way down to A15. Now we have a choice to make. Click Table where you will find two options for slitting, Split into Rows and Split into Columns. Splitting into rows will split our cells horizontally. We want to split them vertically into columns, so choose Split into Columns. Now it's just a matter of taking some of the content from our cells in the A column and moving that over into the B column.
The opposite of splitting is merging. Let's merge the two cells above our addresses to make this look cleaner. We'll select cells A2 to B2 and we can merge from the Table menu as well. This time choose Merge Cells. The two cells become one and the label which was centered is now centered would appears to be across two columns down below. Let's repeat this using a different method for our top row. In this case we want to select all the cells in the top row and this time we'll use the Table Inspector, click the Inspector button on the Toolbar make sure the Table Inspector is selected, down below you will find a section for Merging and Splitting.
Here you will find two buttons for splitting vertically and horizontally, as well as a Merge button. Click the Merge button to merge all of these cells together into one. The title appears centered across the entire table now. Let's close the Table Inspector and deselect the table to get a better look at the end result. Now one other useful option when working with cell data is to add comments but to add them without affecting the cell contents themselves. In this case you can attach comments to a cell that you select. Let's go to one of our addresses in this table and now we'll insert a comment. That can be done from the Insert menu or from the Toolbar. Click the Comment button and a brand new comment will appear attached to the cell that was selected. All you need to do now is type in your comment. Let's type Sale Pending.
There are two buttons that appear on the top corners of your note. In the top left, a Minimize button, which will hide the comment. In the right hand side, a Delete button to remove the comment. Another option for hiding your comments is to use the View menu or the View button on the Toolbar. Click the View button and choose Hide Comments. You will notice cells with a triangle in the top right corner are the cells containing comments. To bring those back, use the View menu or the View button and choose Show Comments.
When you are done with your comments, you can delete them by clicking the Delete button in the top right corner. So although tables consist of rows and columns when inserted into a sheet, you can always use Splitting and Merging to change their appearance and adding comments allows you to take notes without affecting cell content.
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.