Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Numbers '09 can automatically recognize email and web addresses when you type them to create working hyperlinks and this can be particularly useful when sharing your spreadsheets electronically with others. Now we'll use our Milea Listings and Prospects spreadsheet, but the first step is to ensure Numbers is set up to recognize e-mail addresses in websites. So click Numbers and choose Preferences and then choose Auto-correction, and ensure there is a check mark next to Automatically detect e-mail and web addresses. Without a check mark, you won't automatically see hyperlinks created when you type in e-mail and web addresses.
So with the check mark in there, we'll close up our Preferences window and now at the bottom of our current listing sheet, you'll see a text box. First, we'll click once to select the text box and now we'll click inside the text box where we want to type in our email address which is after the colon, before the word or. Now, as we type in an email address, let's type in Info @, and the at symbol is what Numbers uses to recognize an email address, type in milearealestate.com.
Watch what happens when you press the Spacebar now to leave a space. Automatically the hyperlink is created and our text is formatted in blue with the underline to show up as a hyperlink. Now, the same thing will happen when we add a website at the end. We'll click at the end of our text string and type in www.milearealestate.com. When you hit the Spacebar again, a hyperlink is created. So let's click the Canvas anywhere to deselect our text box. Notice as you hover over these hyperlinks, you'll see the actual URL for the website and as you hover over the hyperlink for the email address, you'll see your mouse-pointer turn into a little hand. This means you can actually use the hyperlink. It works.
So let's click our email address and what should happen is your default email application will load up with a brand new message, automatically addressed to the email address you typed-in waiting for you to enter a subject and the body of your message, and send that message off. You can close your default email application to return to the spreadsheet. So if you plan on sharing your spreadsheets electronically with others, hyperlinks can provide quick and easy access to websites and email correspondence.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73647 Viewers
80 Video lessons · 129303 Viewers
52 Video lessons · 63673 Viewers
59 Video lessons · 49431 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.