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

Using the HYPERLINK Function 461
After you have selected the cell or graphic with the hyperlink, you can move the link by clicking the Cut command button on the Home tab of the Ribbon (Ctrl+X) or copy it by clicking the Copy command button (Ctrl+C) and then paste it into its new position by clicking the Paste command button (Ctrl+V). When moving or copying hypertext from one cell to another, you can just click the cell where the link is to be moved or copied and then press the Enter key.
To move the selected link by using the drag-and-drop method, drag the cell or object with the mouse pointer (in the shape of a white arrowhead point- ing to a black double-cross) and then release the mouse button to drop the hypertext or graphic into its new position. To copy the link, be sure to hold down the Ctrl key (which changes the pointer to a white arrowhead with a plus sign to its right) as you drag the outline of the cell or object.
When attempting to move or copy a cell by using the drag-and-drop method, remember that you have to position the thick, white-cross mouse pointer on one of the borders of the cell before the pointer changes to a white arrow- head pointing to a black double-cross. If you position the pointer anywhere within the cell’s borders, the mouse changes to the hand with the index finger pointing upward, indicating that the hyperlink is active.
Using the HYPERLINK Function
Instead of using the Hyperlink command button on the Insert tab of the Ribbon, you can use Excel’s HYPERLINK function to create a hypertext link. (You can’t use this function to attach a hyperlink to a graphic object.) The HYPERLINK function uses the following syntax:
HYPERLINK(link_location,[friendly_name])
The link_location argument specifies the name of the document to open on your local hard drive, on a network server (designated by a UNC address), or on the company’s intranet or the World Wide Web (designated by the URL address — see the sidebar, “How to tell a UNC from a URL address and when to care,” for details). The optional friendly_name argument is the hyperlink text that appears in the cell where you enter the HYPERLINK function. If you omit this argument, Excel displays the text specified as the link_location argument in the cell.
Book IV Chapter 2
Using Hyperlinks