Tnhelearning.edu.vn - Various useful general information portal

How to Insert Hyperlink in Microsoft Excel

by Category: How To

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 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.

Link to new file

Image titled Insert Hyperlinks in Microsoft Excel Step 1

Image titled Insert Hyperlinks in Microsoft Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c0/Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c0/Insert-Hyperlinks-in-Microsoft- Excel-Step-1-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document where you want to insert the hyperlink.

  • You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .
Image titled Insert Hyperlinks in Microsoft Excel Step 2

Image titled Insert Hyperlinks in Microsoft Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Insert-Hyperlinks-in-Microsoft- Excel-Step-2-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the cell where you want to insert the hyperlink.
Image titled Insert Hyperlinks in Microsoft Excel Step 3

Image titled Insert Hyperlinks in Microsoft Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3e/Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3e/Insert-Hyperlinks-in-Microsoft- Excel-Step-3-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Insert . This tab is located in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the green ribbon.

  • 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.
Image titled Insert Hyperlinks in Microsoft Excel Step 4

Image titled Insert Hyperlinks in Microsoft Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/aa/Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/aa/Insert-Hyperlinks-in-Microsoft- Excel-Step-4-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Hyperlink . This option is to the right of the Insert toolbar under “Links”. A window will open.
Image titled Insert Hyperlinks in Microsoft Excel Step 5

Image titled Insert Hyperlinks in Microsoft Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Insert-Hyperlinks-in-Microsoft- Excel-Step-5-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Create New Document . This tab is on the left side of the pop-up window.
Image titled Insert Hyperlinks in Microsoft Excel Step 6

Image titled Insert Hyperlinks in Microsoft Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4d/Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4d/Insert-Hyperlinks-in-Microsoft- Excel-Step-6-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter text for the hyperlink. Enter the text you want to display in the “Text to display” data field.

  • If you skip this step, the name of the new document will become the text of the hyperlink.
Image titled Insert Hyperlinks in Microsoft Excel Step 7

Image titled Insert Hyperlinks in Microsoft Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/95/Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/95/Insert-Hyperlinks-in-Microsoft- Excel-Step-7-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Name the new document in the “Name of new document” field.
Image titled Insert Hyperlinks in Microsoft Excel Step 8

READ More:   How to Make Breasts Look Smaller

Image titled Insert Hyperlinks in Microsoft Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Insert-Hyperlinks-in-Microsoft- Excel-Step-8-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the OK button at the bottom of the window. By default, this will create and open a new spreadsheet document, and then create a link to this content in the cell you selected in the previous spreadsheet document.

  • 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

Image titled Insert Hyperlinks in Microsoft Excel Step 9

Image titled Insert Hyperlinks in Microsoft Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c9/Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c9/Insert-Hyperlinks-in-Microsoft- Excel-Step-9-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document where you want to insert the hyperlink.

  • You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .
Image titled Insert Hyperlinks in Microsoft Excel Step 10

Image titled Insert Hyperlinks in Microsoft Excel Step 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7a/Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7a/Insert-Hyperlinks-in-Microsoft- Excel-Step-10-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-10-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 insert the hyperlink.
Image titled Insert Hyperlinks in Microsoft Excel Step 11

Image titled Insert Hyperlinks in Microsoft Excel Step 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4c/Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4c/Insert-Hyperlinks-in-Microsoft- Excel-Step-11-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Insert . This tab is located in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the green ribbon.

  • 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.
Image titled Insert Hyperlinks in Microsoft Excel Step 12

Image titled Insert Hyperlinks in Microsoft Excel Step 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Insert-Hyperlinks-in-Microsoft- Excel-Step-12-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Hyperlink . This option is to the right of the Insert toolbar in the “Links” section. A window will open.
Image titled Insert Hyperlinks in Microsoft Excel Step 13

Image titled Insert Hyperlinks in Microsoft Excel Step 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d1/Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d1/Insert-Hyperlinks-in-Microsoft- Excel-Step-13-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Existing File or Web Page . Options are on the left side of the window.
Image titled Insert Hyperlinks in Microsoft Excel Step 14

Image titled Insert Hyperlinks in Microsoft Excel Step 14

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/45/Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/45/Insert-Hyperlinks-in-Microsoft- Excel-Step-14-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter text for the hyperlink. Enter the text you want to display in the “Text to display” data field.

  • If you skip this step, the text of the hyperlink will just be the directory path to the linked content.
Image titled Insert Hyperlinks in Microsoft Excel Step 15

Image titled Insert Hyperlinks in Microsoft Excel Step 15

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Insert-Hyperlinks-in-Microsoft- Excel-Step-15-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select destination. Click one of the following cards:

  • 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.
Image titled Insert Hyperlinks in Microsoft Excel Step 16

Image titled Insert Hyperlinks in Microsoft Excel Step 16

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/99/Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/99/Insert-Hyperlinks-in-Microsoft- Excel-Step-16-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select a file or web page. Click the file, folder, or web address you want to link. The path to the folder will appear in the “Address” text box at the bottom of the window.

  • You can also copy the URL from the Internet and paste it into the “Address” text frame.
READ More:   How to Write a Love Letter
Image titled Insert Hyperlinks in Microsoft Excel Step 17

Image titled Insert Hyperlinks in Microsoft Excel Step 17

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Insert-Hyperlinks-in-Microsoft- Excel-Step-17-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the OK button at the bottom of the page. The hyperlink will be created in the specified cell.

  • Note: if you move linked content, the hyperlink will be disabled.

Links within documents

Image titled Insert Hyperlinks in Microsoft Excel Step 18

Image titled Insert Hyperlinks in Microsoft Excel Step 18

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/14/Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/14/Insert-Hyperlinks-in-Microsoft- Excel-Step-18-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document where you want to insert the hyperlink.

  • You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .
Image titled Insert Hyperlinks in Microsoft Excel Step 19

Image titled Insert Hyperlinks in Microsoft Excel Step 19

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0a/Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0a/Insert-Hyperlinks-in-Microsoft- Excel-Step-19-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-19-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 insert the hyperlink.
Image titled Insert Hyperlinks in Microsoft Excel Step 20

Image titled Insert Hyperlinks in Microsoft Excel Step 20

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6f/Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6f/Insert-Hyperlinks-in-Microsoft- Excel-Step-20-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Insert . This tab is located in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the green ribbon.

  • 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.
Image titled Insert Hyperlinks in Microsoft Excel Step 21

Image titled Insert Hyperlinks in Microsoft Excel Step 21

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/25/Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/25/Insert-Hyperlinks-in-Microsoft- Excel-Step-21-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Hyperlink . This option is to the right of the Insert toolbar in the “Links” section. A window will open.
Image titled Insert Hyperlinks in Microsoft Excel Step 22

Image titled Insert Hyperlinks in Microsoft Excel Step 22

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e6/Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e6/Insert-Hyperlinks-in-Microsoft- Excel-Step-22-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Place in This Document . This option is on the left side of the window.
Image titled Insert Hyperlinks in Microsoft Excel Step 23

Image titled Insert Hyperlinks in Microsoft Excel Step 23

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Insert-Hyperlinks-in-Microsoft- Excel-Step-23-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter text for the hyperlink. Enter the text you want to display in the “Text to display” data field.

  • If you skip this step, the text of the hyperlink will simply be the target cell name.
Image titled Insert Hyperlinks in Microsoft Excel Step 24

Image titled Insert Hyperlinks in Microsoft Excel Step 24

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3b/Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3b/Insert-Hyperlinks-in-Microsoft- Excel-Step-24-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click OK . The link will be created in the selected cell. If you click the hyperlink, Excel will automatically highlight the linked cell.

Create a hyperlink to an email address

Image titled Insert Hyperlinks in Microsoft Excel Step 25

Image titled Insert Hyperlinks in Microsoft Excel Step 25

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d2/Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d2/Insert-Hyperlinks-in-Microsoft- Excel-Step-25-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document where you want to insert the hyperlink.

  • You can also open a new document by double-clicking the Excel icon and clicking Blank Workbook .
Image titled Insert Hyperlinks in Microsoft Excel Step 26

Image titled Insert Hyperlinks in Microsoft Excel Step 26

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/26/Insert-Hyperlinks-in-Microsoft- Excel-Step-26-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-26-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 insert the hyperlink.
Image titled Insert Hyperlinks in Microsoft Excel Step 27

Image titled Insert Hyperlinks in Microsoft Excel Step 27

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Insert-Hyperlinks-in-Microsoft- Excel-Step-27-Version-3.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Insert . This tab is located in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the green ribbon.

  • 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.
READ More:   How to Talk to Strangers
Image titled Insert Hyperlinks in Microsoft Excel Step 28

Image titled Insert Hyperlinks in Microsoft Excel Step 28

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Insert-Hyperlinks-in-Microsoft- Excel-Step-28-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Hyperlink . This option is to the right of the Insert toolbar in the “Links” section. A window will open.
Image titled Insert Hyperlinks in Microsoft Excel Step 29

Image titled Insert Hyperlinks in Microsoft Excel Step 29

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/71/Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg/v4-728px-Insert- Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/71/Insert-Hyperlinks-in-Microsoft- Excel-Step-29-Version-2.jpg/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click E-mail Address . This option is on the left side of the window.
Image titled Insert Hyperlinks in Microsoft Excel Step 30

Image titled Insert Hyperlinks in Microsoft Excel Step 30

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/04/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg/v4-728px-Insert-Hyperlinks-in- Microsoft-Excel-Step-30.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/04/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg/ v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter text for the hyperlink. Enter the text you want to display in the “Text to display” data field.

  • If you skip this step, the email address will display as hyperlink text.
Image titled Insert Hyperlinks in Microsoft Excel Step 31

Image titled Insert Hyperlinks in Microsoft Excel Step 31

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ed/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg/v4-728px-Insert-Hyperlinks-in- Microsoft-Excel-Step-31.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ed/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg/ v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter your email address. Enter the email address you want to link to in the “E-mail address” field.

  • 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.
  • Image titled Insert Hyperlinks in Microsoft Excel Step 32

    Image titled Insert Hyperlinks in Microsoft Excel Step 32

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5b/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg/v4-728px-Insert-Hyperlinks-in- Microsoft-Excel-Step-32.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5b/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg/ v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
    Click the OK button at the bottom of the window.

    • 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 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:

    Related Posts

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