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.
When it comes to working with text in a table in Numbers '09, there are a number of time savers for adding, removing and selecting text. Let's use our Running Club Data spreadsheet where we have three tables. In the first table you can see we have some text appearing in the first column and down below we have an empty cell and at the very bottom where the word total should go -- the easiest way to add text is to click the cell where you want to add that text and type. Let's type in the word Total. Now, we'll click another cell to lock that in. Let's click cell A2 where January appears. Using Auto-fill, we can automatically fill cells and Numbers '09 will pick up a pattern. Let's move to the bottom right corner when the black cross appears, we'll click and drag straight down to automatically fill the remaining cells with the appropriate months. Numbers was smart enough to pick up that pattern.
Now with these cells selected, we can copy them to fill other cells. Let's right click or Ctrl-click with a single button mouse and choose Copy, you can also use Command+C on the keyboard or use the Edit menu. Now, we'll click the first cell where we want this range to be pasted, in this case cell A2 of the second table called, Distance Run - Women and now we can paste. Again, Ctrl-click or right click the cell, or if you prefer use the Edit menu where you can also choose to Paste and Match Style.
If the second table uses a different style, you will be able to paste the contents and match the style of the destination table. In this case the formatting is the same, so paste or Paste and Match Style will accomplish the same thing. Another option for copying selected cells is to move to the border and when the hand appears, click and hold your mouse button down to create that fist; you have now grabbed the range of cells. So we can move them to another location such as the third table, or if you want to copy them, hold down your Option key, let go off the mouse button first and you have copied the contents to that destination table.
Let's deselect by clicking the canvas. And when it comes to selecting cells, there are a number of options, for example, if we wanted to remove the contents of the first column in the Goals table. We can click and drag straight down to select the cells and press Delete. So this works for a single cell or a range of cells. If you want to select a range of cells using your keyboard, click the first cell, in this case A2 in our second table, hold down your Shift key and click to select the entire range of cells from the first to the last. Now press your Delete key to remove those contents.
Another option is to select specific text within a cell. In that case, you first select the cell by clicking, then click again to get inside. Now you can click and drag over portions of the cell and press Delete to remove just a portion. With Jan appearing we can now move to the bottom right corner and automatically fill with the short forms for each month. Let's copy those using the keyboard Command+C and now we'll click in the first cell of the next table, Command+V to paste. And we'll do the exact same thing for our third table. We'll deselect by clicking the canvas.
So keep these shortcuts in mind when it comes to adding, removing and selecting text in a table 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.