4 Ways to Insert Hyperlinks in Excel

Table of contents:

4 Ways to Insert Hyperlinks in Excel
4 Ways to Insert Hyperlinks in Excel

Video: 4 Ways to Insert Hyperlinks in Excel

Video: 4 Ways to Insert Hyperlinks in Excel
Video: How To Type and Insert Trademark TM, Registered (R) and Copyright (C) Symbols For All Platforms 2024, May
Anonim

This wikiHow teaches you how to create a link to a new file, folder, web page, or document in Microsoft Excel. You can link to Microsoft Excel, both Windows and Mac versions.

Step

Method 1 of 4: Linking Text to a New File

Insert Hyperlinks in Microsoft Excel Step 1
Insert Hyperlinks in Microsoft Excel Step 1

Step 1. Open the Excel document

Double-click the document to which you want to add a link.

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

Insert Hyperlinks in Microsoft Excel Step 2
Insert Hyperlinks in Microsoft Excel Step 2

Step 2. Select the box

Click the box to which you want to add a link.

Insert Hyperlinks in Microsoft Excel Step 3
Insert Hyperlinks in Microsoft Excel Step 3

Step 3. Click Insert

This tab is on the green ribbon at the top of the Excel window. Once clicked, the toolbar will appear just below the ribbon.

If you are using a Mac computer, keep in mind that the " Insert "different from menu" Insert ” displayed on the computer's menu bar.

Insert Hyperlinks in Microsoft Excel Step 4
Insert Hyperlinks in Microsoft Excel Step 4

Step 4. Click Hyperlinks

This option is on the right side of the toolbar " Insert ” in the "Links" section. After that, a new window will open.

Insert Hyperlinks in Microsoft Excel Step 5
Insert Hyperlinks in Microsoft Excel Step 5

Step 5. Click Create New Document

This tab is on the left side of the pop-up window.

Insert Hyperlinks in Microsoft Excel Step 6
Insert Hyperlinks in Microsoft Excel Step 6

Step 6. Enter the link text

Type the text you want to display in the "Text to display" field.

If you do not enter different text, the name of the new document will be used as the link text

Insert Hyperlinks in Microsoft Excel Step 7
Insert Hyperlinks in Microsoft Excel Step 7

Step 7. Type in the name of the new document

Enter a name in the "Name of new document" field.

Insert Hyperlinks in Microsoft Excel Step 8
Insert Hyperlinks in Microsoft Excel Step 8

Step 8. Click OK

It's at the bottom of the window. By default, a new spreadsheet document will be created and opened, and a link to that worksheet will be added to the box you previously selected in the first document.

You can also select the “Edit the new document later” option before clicking “ OK ” to create a spreadsheet and its link, without opening it.

Method 2 of 4: Linking Text to an Existing File or Webpage

Insert Hyperlinks in Microsoft Excel Step 9
Insert Hyperlinks in Microsoft Excel Step 9

Step 1. Open the Excel document

Double-click the document to which you want to add a link.

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

Insert Hyperlinks in Microsoft Excel Step 10
Insert Hyperlinks in Microsoft Excel Step 10

Step 2. Select the box

Click the box to which you want to add a link.

Insert Hyperlinks in Microsoft Excel Step 11
Insert Hyperlinks in Microsoft Excel Step 11

Step 3. Click Insert

This tab is on the green ribbon at the top of the Excel window. Once clicked, the toolbar will appear just below the ribbon.

If you are using a Mac computer, keep in mind that the " Insert "different from menu" Insert ” displayed on the computer's menu bar.

Insert Hyperlinks in Microsoft Excel Step 12
Insert Hyperlinks in Microsoft Excel Step 12

Step 4. Click Hyperlinks

This option is on the right side of the toolbar " Insert ” in the "Links" section. After that, a new window will open.

Insert Hyperlinks in Microsoft Excel Step 13
Insert Hyperlinks in Microsoft Excel Step 13

Step 5. Click Existing File or Web Page

It's on the left side of the window.

Insert Hyperlinks in Microsoft Excel Step 14
Insert Hyperlinks in Microsoft Excel Step 14

Step 6. Enter the link text

Type the text you want to display in the "Text to display" field.

If you do not enter any other text, the link text will be displayed as the directory/folder address to the destination content

Insert Hyperlinks in Microsoft Excel Step 15
Insert Hyperlinks in Microsoft Excel Step 15

Step 7. Select the destination content

Click one of the following tabs:

  • ” Current Folder ” – Find files in the folder “ Documents " or " Desktop ”.
  • ” Browsed Pages ” – Browse recently visited web pages.
  • ” Recent Files ” – Browse for the most recently opened Excel files.
Insert Hyperlinks in Microsoft Excel Step 16
Insert Hyperlinks in Microsoft Excel Step 16

Step 8. Select a file or web page

Click the file, folder, or web page that you want to link to. The directory/folder address will be displayed in the " Address " field at the bottom of the window.

You can also copy the URL from the internet and paste it in the "Address" field

Insert Hyperlinks in Microsoft Excel Step 17
Insert Hyperlinks in Microsoft Excel Step 17

Step 9. Click OK

It's at the bottom of the page. After that, a link will be created in the box you selected.

Keep in mind that if you move the linked file, the link will no longer work

Method 3 of 4: Linking Text to Data in a Document

Insert Hyperlinks in Microsoft Excel Step 18
Insert Hyperlinks in Microsoft Excel Step 18

Step 1. Open the Excel document

Double-click the document to which you want to add a link.

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

Insert Hyperlinks in Microsoft Excel Step 19
Insert Hyperlinks in Microsoft Excel Step 19

Step 2. Select the box

Click the box to which you want to add a link.

Insert Hyperlinks in Microsoft Excel Step 20
Insert Hyperlinks in Microsoft Excel Step 20

Step 3. Click Insert

This tab is on the green ribbon at the top of the Excel window. Once clicked, the toolbar will appear just below the ribbon.

If you are using a Mac computer, keep in mind that the " Insert "different from menu" Insert ” displayed on the computer's menu bar.

Insert Hyperlinks in Microsoft Excel Step 21
Insert Hyperlinks in Microsoft Excel Step 21

Step 4. Click Hyperlinks

This option is on the right side of the toolbar " Insert ” in the "Links" section. After that, a new window will open.

Insert Hyperlinks in Microsoft Excel Step 22
Insert Hyperlinks in Microsoft Excel Step 22

Step 5. Click Place in This Document

It's on the left side of the window.

Insert Hyperlinks in Microsoft Excel Step 23
Insert Hyperlinks in Microsoft Excel Step 23

Step 6. Enter the link text

Type the text you want to display in the "Text to display" field.

If not entered, the link text will be displayed as the name of the linked box

Insert Hyperlinks in Microsoft Excel Step 24
Insert Hyperlinks in Microsoft Excel Step 24

Step 7. Click OK

A link will be created in the selected box. If you click on the link, Excel will automatically check the linked box.

Method 4 of 4: Creating Email Address Links

Insert Hyperlinks in Microsoft Excel Step 25
Insert Hyperlinks in Microsoft Excel Step 25

Step 1. Open the Excel document

Double-click the document to which you want to add a link.

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

Insert Hyperlinks in Microsoft Excel Step 26
Insert Hyperlinks in Microsoft Excel Step 26

Step 2. Select the box

Click the box to which you want to add a link.

Insert Hyperlinks in Microsoft Excel Step 27
Insert Hyperlinks in Microsoft Excel Step 27

Step 3. Click Insert

This tab is on the green ribbon at the top of the Excel window. Once clicked, the toolbar will appear just below the ribbon.

If you are using a Mac computer, keep in mind that the " Insert "different from menu" Insert ” displayed on the computer's menu bar.

Insert Hyperlinks in Microsoft Excel Step 28
Insert Hyperlinks in Microsoft Excel Step 28

Step 4. Click Hyperlinks

This option is on the right side of the toolbar " Insert ” in the "Links" section. After that, a new window will open.

Insert Hyperlinks in Microsoft Excel Step 29
Insert Hyperlinks in Microsoft Excel Step 29

Step 5. Click E-mail Address

It's on the left side of the window.

Insert Hyperlinks in Microsoft Excel Step 30
Insert Hyperlinks in Microsoft Excel Step 30

Step 6. Enter the link text

Type the text you want to display in the "Text to display" field.

If not changed or entered, the text of the link will appear as the email address to which you will link

Insert Hyperlinks in Microsoft Excel Step 31
Insert Hyperlinks in Microsoft Excel Step 31

Step 7. Enter your email address

Type the address you want to connect to in the " E-mail address " field.

You can also add the desired email subject in the " Subject " field. This means that the link will display a new email window with the subject field already filled in

Insert Hyperlinks in Microsoft Excel Step 32
Insert Hyperlinks in Microsoft Excel Step 32

Step 8. Click OK

It's at the bottom of the window.

Tips

You can also enter links using the “HYPERLINK” function or formula. Type " =HYPERLINK(link_location,name) ” in the desired box. The "link_location" code refers to the directory address of a file, folder, or web page, and the "name" code is the text displayed as a link.

Recommended:

4 Ways to Insert Custom Head or Footnotes in Microsoft Word

4 Ways to Insert Custom Head or Footnotes in Microsoft Word

Microsoft Word already has many head or footnotes that you can insert into a document. However, you can insert custom headings or footnotes into a Microsoft Word document by following these simple steps. Step Method 1 of 4: Insert Using the Toolbar Step 1.

3 Ways to Insert Text into Images

3 Ways to Insert Text into Images

This wikiHow teaches you how to place text on an image. You can do this using Paint for Windows, Preview for Mac, and an app called "Phonto" for iPhone and Android smartphones. Step Method 1 of 3: For Windows Computer Step 1.

How to Insert a Second Y-Axis in an Excel Chart: 12 Steps

How to Insert a Second Y-Axis in an Excel Chart: 12 Steps

Displaying multiple trend data on a single chart in Excel does help. Unfortunately, if your data has different units, you may find it impossible or difficult to create the necessary graphs. Calm! You can do it. The process of making graphics like this is quite easy!

How to Insert a Checkmark in Microsoft Excel: 9 Steps

How to Insert a Checkmark in Microsoft Excel: 9 Steps

This wikiHow teaches you how to insert a check icon in a box in a Microsoft Excel document. While not all fonts support this icon, you can use your computer's built-in Wingdings 2 font to add a check to any box on a spreadsheet. Step Step 1.

How to Insert SQL Query in Microsoft Excel: 13 Steps

How to Insert SQL Query in Microsoft Excel: 13 Steps

This article will guide users to insert SQL queries in Excel 2010 and create dynamic connections. Step Step 1. Click the Data tab, then select From Other Sources as shown in the following screenshot Step 2. Select “From Data Connection Wizard” from the drop down menu Step 3.