Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Tables in Numbers '09 can be copied and pasted between sheets, spreadsheets and even between the other applications in the iWork '09 suite such as Pages and Keynote. We will start with a spreadsheet that's under construction for 2009. Instead of creating a new table from scratch down below, we can save some time and effort by copying an existing table from another spreadsheet and pasting it into our new spreadsheet. The old spreadsheet is called Energy Saving Plan. Here we have a table called Utility Costs by Type. Note the style and formatting.
The first step to copying this table is to select it. By clicking Utility Costs by Type in the Sheets pane, you would be selecting the entire table. Now we need to copy it. This can be done from the Edit menu or from the keyboard using Command+C. Once copied, we are ready to paste. So we'll move over to our new spreadsheet Energy Saving 2009 and click the Edit menu. Notice we can Paste or Paste and Match Style. Paste will paste the table the way it appears. Paste and Match Style will apply the style that's defaulted for our current sheet so that it looks like the other table on our spreadsheet.
Choose Paste and Match Style and Utility Cost by Type to paste it into the new spreadsheet. Now we can also copy tables from other applications such as Keynote or Pages. If you have got a table in either of those applications, you can again save time and effort by bringing it into Numbers. So let's go back to our Energy Saving Plan spreadsheet and click the Energy Savers sheet. Here we have got some content but we don't have a table. We'll get that table from a Pages document. You can use Alt+Tab or launch Pages using the Energy Saving Report document. We'll move down to Page 2. Now here we find a table using its own formatting and the first step again is to select the table.
Click once to select the table and you will see the handles appearing around the outside. Again, you can use Command+C from the keyboard or choose Copy from the Edit menu. Now we'll switch back to our spreadsheet. We are ready to paste. Now, it would be best if the table took on the formatting and style of our current spreadsheet as opposed to the formatting that was applied in the Pages document. So when we click Edit, we'll be sure to choose Paste and Match Style. This pastes the table and restyles it to match our current sheet. You can deselect the table by clicking anywhere on the canvas.
So that was simple. Just think of the time and effort you can save by copying tables between your existing spreadsheets or even between the other iWork '09 applications.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74986 Viewers
80 Video lessons · 129950 Viewers
52 Video lessons · 64131 Viewers
59 Video lessons · 49922 Viewers
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.
Your file was successfully uploaded.