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

Chapter 2: Using Hyperlinks In This Chapter
✓ Linking your spreadsheet to other Excel workbooks, Office documents, and web pages
✓ Linking to e-mail addresses
✓ Following the links that you create in the worksheet
✓ Editing hyperlinks in a worksheet
✓ Creating formulas that use the HYPERLINK function
The subject of this chapter is linking your worksheet with other docu- ments through the use of hyperlinks. Hyperlinks are the kinds of links used on the web to take you immediately from one web page to another or from one website to another. Such links can be attached to text (thus the term, hypertext) or to graphics such as buttons or pictures. The most impor- tant aspect of a hyperlink is that it immediately takes you to its destination whenever you click the text or button to which it is attached.
In an Excel worksheet, you can create hyperlinks that take you to a different part of the same worksheet, to another worksheet in the same workbook,
to another workbook or other type of document on your hard drive, or to a web page on your company’s intranet or on the World Wide Web.
Hyperlinks 101
To add hyperlinks in an Excel worksheet, you must define two things:
✦ The object to which you want to anchor the link and then click to activate
✦ The destination to which the link takes you when activated
The objects to which you can attach hyperlinks include any text that you enter into a cell or any graphic object that you draw or import into the worksheet. (See Book V, Chapter 2, for details on adding graphics to your worksheet.) The destinations that you can specify for links can be a new cell or range, the same workbook file, or another file outside the workbook.