You are viewing the article How to Add Links in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
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,464 times.
Microsoft Excel is a fully functional spreadsheet application that allows users to organize, store and analyze many different types of data. You can add links to websites, other documents, or even other cells and pages in the same spreadsheet when you need to refer to another source for additional information, backup, and support for your data. Friend.
Steps
Insert a link to a location in the spreadsheet
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Add-Links-in-Excel-Step-1-Version-3.jpg/v4-728px-Add-Links- in-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/Add-Links-in-Excel-Step-1- Version-3.jpg/v4-728px-Add-Links-in-Excel-Step-1-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the cell where you want to create the link. You can create a shortcut link in any cell in the spreadsheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1a/Add-Links-in-Excel-Step-2-Version-5.jpg/v4-728px-Add-Links- in-Excel-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1a/Add-Links-in-Excel-Step-2- Version-5.jpg/v4-728px-Add-Links-in-Excel-Step-2-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Insert” tab and then click “Hyperlink”. The create link window will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Add-Links-in-Excel-Step-3-Version-5.jpg/v4-728px-Add-Links- in-Excel-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Add-Links-in-Excel-Step-3- Version-5.jpg/v4-728px-Add-Links-in-Excel-Step-3-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Place in This Document” option in the left menu. With it, you can link to every cell in the spreadsheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/51/Add-Links-in-Excel-Step-4-Version-4.jpg/v4-728px-Add-Links- in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/51/Add-Links-in-Excel-Step-4- Version-4.jpg/v4-728px-Add-Links-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the cell you want to link to. You can do it by:
- To type the location of a cell, select the page that contains the cell from the “Cell Reference” list. You can then enter a specific cell, such as “C23” in the “Type the cell reference” field.
- Or you can choose from the specified cell or range in the “Defined Names” list. When you select them, you won’t be able to manually type the location.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ee/Add-Links-in-Excel-Step-5-Version-4.jpg/v4-728px-Add-Links- in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ee/Add-Links-in-Excel-Step-5- Version-4.jpg/v4-728px-Add-Links-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Change the title (optional). By default, the title of the link will simply be the name of the cell you are linking to. You can change it by typing whatever you want into the “Text to display” field. [1] X Research Source
- You can click the “ScreenTip” button to change what appears when the user hovers over the link.
Insert link to website
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Add-Links-in-Excel-Step-6-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-6-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Add-Links-in-Excel-Step-6- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-6-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Copy the address of the page you want to link to. You can link to any page just by copying its address. This address can be copied from the address bar on a web browser. To copy the address from a link on the website, right-click the link and select “Copy address” or similar, depending on your browser.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/92/Add-Links-in-Excel-Step-7-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/92/Add-Links-in-Excel-Step-7- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-7-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the cell in the Excel spreadsheet that you want to insert the link into. You can insert into any cell in that spreadsheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b4/Add-Links-in-Excel-Step-8-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b4/Add-Links-in-Excel-Step-8- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Insert” tab and press the “Hyperlink” button. A window that allows you to insert different types of links will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c6/Add-Links-in-Excel-Step-9-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c6/Add-Links-in-Excel-Step-9- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select “Existing File or Web Page” on the left side of the window. The file browser will be displayed.
- If you are using Excel 2011, select “Web Page”.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9d/Add-Links-in-Excel-Step-10-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9d/Add-Links-in-Excel-Step-10- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Paste the link to the website in the “Address” field at the bottom of the window.
- If you’re using Excel 2011, paste the link in the “Link to” field at the top of the window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9c/Add-Links-in-Excel-Step-11-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9c/Add-Links-in-Excel-Step-11- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-11-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Change the title of the link (optional). By default, the link will show the full address. You can change it to something you like, such as “Company Website”. Click in the “Text to display” field and enter what you want to use as the title of the link.
- With Excel 2011, that would be the “Display” field.
- Click the “ScreenTip” button to change what appears when the user hovers the mouse pointer over the link.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Add-Links-in-Excel-Step-12-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Add-Links-in-Excel-Step-12- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “OK” to create the link. Your link will appear in the cell you selected earlier. You can try it by clicking on it or edit it by holding down the link and then clicking the “Hyperlink” button again.
Insert link to send email
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1a/Add-Links-in-Excel-Step-13-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1a/Add-Links-in-Excel-Step-13- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the cell where you want to insert the link. You can insert a link to send an email into any cell on the spreadsheet. Click any cell to select it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d7/Add-Links-in-Excel-Step-14-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d7/Add-Links-in-Excel-Step-14- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Insert” tab. Items that you can insert into the spreadsheet are displayed.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Add-Links-in-Excel-Step-15-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/26/Add-Links-in-Excel-Step-15- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Hyperlink” button. A window that allows you to insert different types of links will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Add-Links-in-Excel-Step-16-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c2/Add-Links-in-Excel-Step-16- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the email address you want to link to in the “E-mail address” field. The “Text to display” field will be populated automatically when you add the address. “mailto:” (sent to) will be automatically added to the beginning of the address.
- If you’ve entered addresses before, you can now select them from the list at the bottom of the window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Add-Links-in-Excel-Step-17-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Add-Links-in-Excel-Step-17- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-17-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter a pre-made theme in the “Subject” field – optional. You can leave the link as default if you want, or set a pre-made theme to make it more convenient for users.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Add-Links-in-Excel-Step-18-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Add-Links-in-Excel-Step-18- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-18-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Change the title to be displayed (optional). By default, the link will show “mailto: address@example.com ” but you can change it to anything you want, such as “Contact Us”. Click on the “Text to display” field and change it to whatever you want.
- Click the “ScreenTip” button to change what appears when the user hovers the mouse pointer over the link.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Add-Links-in-Excel-Step-19-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Add-Links-in-Excel-Step-19- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-19-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “OK” to insert your link. A new email link will be created and when you click on it, your website or mailer will appear with new messages sent to the email address you entered.
Insert a link to somewhere on your computer or server
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/32/Add-Links-in-Excel-Step-20-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-20-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/32/Add-Links-in-Excel-Step-20- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-20-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Check the box where you want to insert the link. You can insert a link to a document or a location on a computer or server into any cell in the spreadsheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/29/Add-Links-in-Excel-Step-21-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-21-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/29/Add-Links-in-Excel-Step-21- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-21-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Insert” tab and click “Hyperlink”. The window that allows creating links in the spreadsheet will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e6/Add-Links-in-Excel-Step-22-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-22-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e6/Add-Links-in-Excel-Step-22- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-22-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select “Existing file or webpage” from the left menu. This option allows you to link to any location or document on your computer (or server).
- With Excel 2011 for OS X, click “Document” and then select “Select” to browse the file on your computer.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f3/Add-Links-in-Excel-Step-23-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-23-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f3/Add-Links-in-Excel-Step-23- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-23-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Use your browser to select a folder or file to link to. The fastest way to link to a specific file or folder is to use the file browser to navigate to the desired file/folder. You can link the folder to open it on click or select a specific file to open with the link.
- You can switch between display methods to see files opened nearby, as well as change the folder you’re viewing.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fa/Add-Links-in-Excel-Step-24-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-24-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fa/Add-Links-in-Excel-Step-24- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-24-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Type or paste the address for the file or folder. You can enter the address for the file or folder instead of navigating to the file or folder using the browser. This is especially useful for content that resides on other servers.
- To find the actual address of a local file or folder, open an Explorer window and navigate to that folder. Click the folder path at the top of the Explorer window for the address to appear: now you just copy and paste the address.
- To link to a location on the server, paste the address for the directory or location that is accessible to readers.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/af/Add-Links-in-Excel-Step-25-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-25-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/af/Add-Links-in-Excel-Step-25- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-25-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Change the title displayed (optional). By default, the link will display the entire address to the linked file or folder. You can change this in the “Text to display” field.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6c/Add-Links-in-Excel-Step-26-Version-2.jpg/v4-728px-Add-Links- in-Excel-Step-26-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6c/Add-Links-in-Excel-Step-26- Version-2.jpg/v4-728px-Add-Links-in-Excel-Step-26-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “OK” to create the link. The link will appear in the cell you selected. When you click that box, the file/folder you specified will be opened.
- Users of your spreadsheet should have access to the linked file from the location of the file used in your association. In cases where you plan to send a document to other users, embedding the file may be more useful than adding a link to it.
X
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,464 times.
Microsoft Excel is a fully functional spreadsheet application that allows users to organize, store and analyze many different types of data. You can add links to websites, other documents, or even other cells and pages in the same spreadsheet when you need to refer to another source for additional information, backup, and support for your data. Friend.
Thank you for reading this post How to Add Links in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: