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

456 Hyperlinks 101
The destinations that you can specify for hyperlinks that take you to another place in the same workbook file include
✦ The cell reference of a cell on any of the worksheets in the workbook that you want to go to when you click the hyperlink.
✦ The range name of the group of cells that you want to select when you click the hyperlink. The range name must already exist at the time you create the link.
The destinations that you can specify for hyperlinks that take you outside the current workbook include
✦ The filename of an existing file that you want to open when you click the hyperlink. This file can be another workbook file or any other type of document that your computer can open.
✦ The URL address of a web page that you want to visit when you click the hyperlink. This page can be on your company’s intranet or on the World Wide Web and is opened in your web browser.
✦ A new document that you want to create in Excel or some other pro- gram on your computer when you click the hyperlink. You must specify the filename and file extension (which indicates what type of document to create and what program to launch).
✦ An e-mail address for a new message that you want to create in your e-mail program when you click the hyperlink. You must specify the recipient’s e-mail address and the subject of the new message when you create the link.
Adding hyperlinks
The steps for creating a new hyperlink in the worksheet are very straightfor- ward. The only thing you need to do beforehand is to add the jump text in the cell where you want the link or to draw or import the graphic object to which the link is to be attached (as described in Book V, Chapter 2). Then, to add a hyperlink to the text in this cell or the graphic object, follow these steps:
1. Position the cell pointer in the cell containing the text or click the graphic object to which you want to anchor the hyperlink.
After you have selected the cell with the text or the graphic object, you’re ready to open the Insert Hyperlink dialog box.
2. Click the Hyperlink command button on the Ribbon’s Insert tab or press Alt+NI or Ctrl+K.