Page 476 - Excel 2013 All-in-One For Dummies

458 Hyperlinks 101
Now all that you need to do is to specify the destination for your link. How you do this depends on which type of link you’re adding; see the following instructions for details.
• Linking to a cell or named range in the current workbook: After clicking the Place in This Document button in the Link To panel, enter the address of the cell to link to in the Type the Cell Reference text box and then click the name of the sheet that contains this cell listed under the Cell Reference range in the Or Select a Place in This Document list box. To link to a named range, simply click its name under Defined Names in the Or Select a Place in This Document list box.
• Linking to an existing file: After clicking the Existing File or Web Page button in the Link To panel, open its folder in the Look In drop- down list box and then click its file icon in the list box that appears immediately below this box. If you’re linking to a web page, click the Address text box and enter the URL address (as in http:// and so on) there. If the file or web page that you select contains bookmarks (or range names, in the case of another Excel workbook) that name specific locations in the file to which you link, click the Bookmark button and then click the name of the location (bookmark) in the Select Place in Document dialog box before you click OK.
• Creating a new document: After clicking the Create New Document button in the Link To panel, enter a filename for the new document in the Name of New Document text box. Include the three-letter filename extension if this new document is not an Excel workbook, such as .doc to create a new Word document or .txt to create a new text file. To specify a different folder in which to create the new document, click the Change button to the right of the current path and then select the appropriate drive and folder in the Create New Document dialog box and click OK. If you want to edit the contents of the new document right away, leave the Edit the New Document Now option button selected. If you prefer to edit the new document at a later time, click the Edit the New Document Later option button.
• Creating a new e-mail message: After clicking the E-Mail Address button in the Link To panel, enter the e-mail address (as in gharvey@ mindovermedia.com) in the E-Mail Address text box and then click the Subject text box and enter the subject of the new e-mail message.
5. Specify the destination for the new hyperlink by using the text boxes and list boxes that appear for the type of link destination that you selected.
Now you’re ready to create the link.
6. Click the OK button in the Insert Hyperlink dialog box.