You are viewing the article How to Insert Hyperlink in Microsoft Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,879 times.
This wikiHow teaches you how to create a link to a new file, folder, web page, or document in Microsoft Excel. You can do it on Excel Windows and Mac versions.
Steps
Link to new file

- You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .


- If you use a Mac, you need to avoid confusing the Insert tab in Excel with the Insert menu item located in the menu bar of your computer.



- If you skip this step, the name of the new document will become the text of the hyperlink.


- You can also select “Edit the new document later” before clicking OK to create the spreadsheet and link without opening a new document.
Link to an existing file or web page

- You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .


- If you use a Mac, you need to avoid confusing the Insert tab in Excel with the Insert menu item located in the menu bar of your computer.



- If you skip this step, the text of the hyperlink will just be the directory path to the linked content.

- Current Fpder – Search for files in Documents or Desktop folders.
- Browsed Pages – Search through recently viewed web pages.
- Recent Files – Search through recently opened Excel files.

- You can also copy the URL from the Internet and paste it into the “Address” text frame.

- Note: if you move linked content, the hyperlink will be disabled.
Links within documents

- You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .


- If you use a Mac, you need to avoid confusing the Insert tab on Excel with the Insert menu item located in the computer’s menu bar.



- If you skip this step, the text of the hyperlink will simply be the target cell name.

Create a hyperlink to an email address

- You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .


- If you use a Mac, you need to avoid confusing the Insert tab on Excel with the Insert menu item located in the computer’s menu bar.



- If you skip this step, the email address will display as hyperlink text.

- You can also add a predefined subject to the “Subject” field, a hyperlink that will lead to a new email pre-populated with the subject.

Advice
- You can also insert hyperlinks using the HYPERLINK feature: enter the formula =HYPERLINK(link_location, name) in the cell, where “link_location” is the file, directory or web page path, and “name” is the text displayed in the hyperlink.
Warning
- In case the file connected to the Excel spreadsheet by the hyperlink is moved to a new location, you need to edit the new path of the content in the hyperlink.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,879 times.
This wikiHow teaches you how to create a link to a new file, folder, web page, or document in Microsoft Excel. You can do it on Excel Windows and Mac versions.
Thank you for reading this post How to Insert Hyperlink in Microsoft Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: