• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Add Links in Excel

February 3, 2024 by admin Category: How To

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.

Table of Contents

  • Steps
    • Insert a link to a location in the spreadsheet
    • Insert link to website
    • Insert link to send email
    • Insert a link to somewhere on your computer or server

Steps

Insert a link to a location in the spreadsheet

Image titled Add Links in Excel Step 1

Image titled Add Links in Excel Step 1

{“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.
Image titled Add Links in Excel Step 2

Image titled Add Links in Excel Step 2

{“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.
Image titled Add Links in Excel Step 3

Image titled Add Links in Excel Step 3

{“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.
Image titled Add Links in Excel Step 4

Image titled Add Links in Excel Step 4

{“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.
Image titled Add Links in Excel Step 5

Image titled Add Links in Excel Step 5

{“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.
READ More:   How to Start Texting With Someone You Like

Insert link to website

Image titled Add Links in Excel Step 6

Image titled Add Links in Excel Step 6

{“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.
Image titled Add Links in Excel Step 7

Image titled Add Links in Excel Step 7

{“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.
Image titled Add Links in Excel Step 8

Image titled Add Links in Excel Step 8

{“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.
Image titled Add Links in Excel Step 9

Image titled Add Links in Excel Step 9

{“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”.
Image titled Add Links in Excel Step 10

Image titled Add Links in Excel Step 10

{“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.
Image titled Add Links in Excel Step 11

Image titled Add Links in Excel Step 11

{“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.
Image titled Add Links in Excel Step 12

Image titled Add Links in Excel Step 12

{“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

Image titled Add Links in Excel Step 13

Image titled Add Links in Excel Step 13

{“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.
Image titled Add Links in Excel Step 14

Image titled Add Links in Excel Step 14

{“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.
Image titled Add Links in Excel Step 15

Image titled Add Links in Excel Step 15

{“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.
Image titled Add Links in Excel Step 16

READ More:   How to Make a Happy Girlfriend

Image titled Add Links in Excel Step 16

{“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.
Image titled Add Links in Excel Step 17

Image titled Add Links in Excel Step 17

{“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.
Image titled Add Links in Excel Step 18

Image titled Add Links in Excel Step 18

{“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.
Image titled Add Links in Excel Step 19

Image titled Add Links in Excel Step 19

{“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

Image titled Add Links in Excel Step 20

Image titled Add Links in Excel Step 20

{“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.
Image titled Add Links in Excel Step 21

Image titled Add Links in Excel Step 21

{“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.
Image titled Add Links in Excel Step 22

Image titled Add Links in Excel Step 22

{“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.
Image titled Add Links in Excel Step 23

Image titled Add Links in Excel Step 23

{“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.
READ More:   How to Get Free Internet Access
Image titled Add Links in Excel Step 24

Image titled Add Links in Excel Step 24

{“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.
Image titled Add Links in Excel Step 25

Image titled Add Links in Excel Step 25

{“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.
  • Image titled Add Links in Excel Step 26

    Image titled Add Links in Excel Step 26

    {“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:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « What is a visa ? Visa exemption how?
    Next Post: What is cold pressed oil? Features of cold pressed oil »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge