Work with links in Excel - Microsoft Support
Absolute and relative links. An absolute URL contains a full address, including the protocol, the Web server, and the path and file name. A relative URL has one or more missing parts. The missing information is taken from the page that contains the URL.
Save all or part of a workbook to a static Web page
Hyperlinks to Web sites on other servers — for example, a list of your favorite places on the Web — are maintained as absolute links — that is, fixed file locations. When you save your Web pages to a different location, links that can't be converted to relative links remain as absolute links.
Create or change a cell reference - Microsoft Support
Make it easier to create cell references between worksheets and workbooks. The Link Cells command automatically pastes the correct syntax for you.
Create workbook links - Microsoft Support
You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.
Create a 3-D reference to the same cell range on multiple ...
A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.
HYPERLINK function - Microsoft Support
To quickly update all formulas in a worksheet that use a HYPERLINK function with the same arguments, you can place the link target in another cell on the same or another worksheet, and then use an absolute reference to that cell as the link_location in the HYPERLINK formulas.
Break a link to an external reference in Excel - Microsoft Support
On the Data tab, in the Connections group, click Edit Links. Note: The Edit Links command is unavailable if your file does not contain linked information. In the Source list, click the link that you want to break.
Switch between relative, absolute, and mixed references
Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Use absolute or relative cell references in formulas, or a mix of both.
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Remove or turn off hyperlinks - Microsoft Support
You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of …