![microsoft excel clickable link to other spreadsheet microsoft excel clickable link to other spreadsheet](https://assets-global.website-files.com/61f27b4a37d6d71a9d8002bc/626c289118a5eae21a962c43_Screenshot%202022-04-29%20at%2016.35.03.png)
The second argument is the name that is the displayed name given to the hyperlink. The first argument should include the targeted reference cell or external link (Email address / URL, document file path). To insert a HYPERLINK function, select the intended cell you’d like to contain the hyperlink and insert the following syntax: =HYPERLINK(link_location,) This is particularly useful to link to a list of locations/need the hyperlink to refer to an Excel Table range. You can also created Hyperlinks using the HYPERLINK function. This lets you copy a hyperlink into multiple locations in your model (such as a “Return to Main Menu” link).
![microsoft excel clickable link to other spreadsheet microsoft excel clickable link to other spreadsheet](https://www.lifewire.com/thmb/QYYcsCv4RpuJZnrFooNqQgh3-VQ=/1864x1243/filters:no_upscale():max_bytes(150000):strip_icc()/TableData-5bdf3e074cedfd002660ccec.jpg)
Hyperlinks that use a defined name also create the flexibility to copy/cut and paste the link to other worksheet(s) while keeping the reference cell(s) unchanged. Just like we did earlier, the referred cell(s) for the hyperlink is unaffected. Now, you can add any extra rows between the “Balance Sheet Check” link and the balance sheet segment.
![microsoft excel clickable link to other spreadsheet microsoft excel clickable link to other spreadsheet](https://excelfind.com/wp-content/uploads/2020/07/excelfind_hyperlink_function-min-1024x421.png)
The defined name should now appear on the menu bar under “Defined Names”.
![microsoft excel clickable link to other spreadsheet microsoft excel clickable link to other spreadsheet](https://excelfind.com/wp-content/uploads/2020/07/excelfind_hyperlink_function-min-600x247.png)
However, with the addition of 2 rows to insert a link for the Income Statement in row A7, the hyperlink still points to cell A45 rather than the desired cell A47 as illustrated in the image below. Using the example below, we insert the hyperlink in cell A5 to refer to the Balance Sheet Check (cell A45). Placing a standard hyperlink is useful if your primary purpose is to navigate to other tabs or when your model is locked for adding/deleting rows and columns. cut and paste), you need to ensure that your reference points are dynamic. This powerful technique has one potential shortfall: if you insert/delete columns or rows or move cells around in the spreadsheet (i.e. Specifically, we reviewed ways to i) insert a hyperlink ii) make the link more user-friendly and informative and iii) prepare a table of contents for navigation purposes. To summarize, we explained how you can access different worksheets or schedules within a worksheet by inserting a hyperlink. You can refer back to the first part by clicking here. This is the second part of our hyperlink resource on our website. This article will show you the steps needed to ensure your reference cell/section does not stay static, and how to create dynamic hyperlinks in Excel. Creating a Dynamic Hyperlink in Excel & Use of Hyperlink Function