Microsoft Office Tutorials and References
In Depth Information
If you transpose cells containing formulas, Excel transposes the formulas and adjusts
cell references. If you want the transposed formulas to continue to correctly refer to
nontransposed cells, be sure that the references in the formulas are absolute before
you copy them. For more information about absolute cell references, see “Using cell
references in formulas” in Chapter 12.
The Hyperlink command on the Insert tab has a specific purpose: to paste a hyperlink that
refers to the copied data in the location you specify. When you create a hyperlink, it’s as
though Excel draws an invisible box, which acts like a button when you click it, and places it
over the selected cell.
Hyperlinks in Excel are similar to web links that, when clicked, launch a webpage. You can
add hyperlinks in your workbooks to locations on the web—a handy way to make related
information readily available. You can use hyperlinks to perform similar tasks among your
Excel worksheets, such as to provide an easy way to access other worksheets or workbooks
that contain additional information. You can even create hyperlinks to other Microsoft
Office documents, such as a report created in Microsoft Word or a Microsoft PowerPoint
Within Excel, you create a hyperlink by copying a named cell or range, navigating to the
location where you want the hyperlink (on the same worksheet, on a different worksheet,
or in a different workbook), and then clicking Insert, Hyperlink. To create a hyperlink in
and among Excel worksheets and workbooks, you must first assign a name to the range to
which you want to hyperlink. (The easiest method is to select the cell or range and type a
name in the Name box at the left end of the formula bar.) Note that hyperlinks differ from
Excel links, which are actually formulas.
For more information, see “Pasting links” earlier in this chapter. For information about
defining names, see “Naming cells and cell ranges” in Chapter 12. For more information about
hyperlinks, see Chapter 31, “Linking, hyperlinking, and embedding.”
When you rest your pointer on a hyperlink, a ScreenTip appears showing you the name and
location of the document to which the hyperlink is connected, as shown in Figure 8-6.