Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you use Address Book on your Mac, you can insert data from Address Book fields into Numbers tables. We'll work with this version of our Milea Listing and Prospect spreadsheet. Currently we don't have a single table on our Prospect Mailing List sheet, but we can create a new table using fields that are used in Address Book, or even better, we can create a new table from an Address Book or even a single card in our Address Book application. For example, if you have Group setup, you can simply click-and-drag the group from Address Book onto the sheet and let it go. A table will be created with the fields used in Address Book. Now when we click inside the table, you will notice that the column headers indicate that some of the columns are hidden, of course, we can change that. Click Table and choose Unhide All Columns.
This will display all of the columns that are used in Address Book, whether there is content in them or not. And of course, you can select columns to either hide them or get rid of them altogether. With a group of columns selected, click any of the drop-down buttons and choose either Delete or Hide Selected Columns. And once you have got your table created, you can get additional addresses and bring them into the table. Let's go back to Address Book. If you've got a single card, for example, if we click a different group and want to drag the contact into our table, we simply click- and-drag. Once the table is highlighted with that blue border, release and the new record is added.
If you have got a vCard that was sent to you, you could do the exact same thing, drag it into the table and a new record is added. When we are done with the Address Book, we'll simply close it up and now when you need to create a table in the Numbers spreadsheet and the data already exists in Address Book or a vCard someone has sent you, remember you can drag it over to Numbers to either create a new table or add to an existing table.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70090 Viewers
80 Video lessons · 127452 Viewers
52 Video lessons · 62394 Viewers
59 Video lessons · 48098 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.