How to Insert Hyperlinks in Microsoft Excel

Today's TipsMake will show you how to create links to new files, folders, websites or documents on Microsoft Excel. You can do it on Windows and Mac versions of Excel.

Link to new file

How to Insert Hyperlinks in Microsoft Excel Picture 1

Open the Excel document. Double-click the Excel document where you want to insert a hyperlink.

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

How to Insert Hyperlinks in Microsoft Excel Picture 2

Select the cell where you want to insert the hyperlink.

How to Insert Hyperlinks in Microsoft Excel Picture 3

Click Insert . This tab is in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the blue ribbon.

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

How to Insert Hyperlinks in Microsoft Excel Picture 4

Click Hyperlink . This option is to the right of the Insert toolbar in the "Links" section. A window will open.

How to Insert Hyperlinks in Microsoft Excel Picture 5

Click Create New Document. This card is on the left side of the pop-up window.

How to Insert Hyperlinks in Microsoft Excel Picture 6

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 becomes the hyperlink text.

How to Insert Hyperlinks in Microsoft Excel Picture 7

Name the new document in the "Name of new document" field.

How to Insert Hyperlinks in Microsoft Excel Picture 8

Click the OK button at the bottom of the window. By default, this creates and opens a new spreadsheet document, then creates 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 links without opening a new document.

Link to an existing file or web page

How to Insert Hyperlinks in Microsoft Excel Picture 9

Open the Excel document. Double-click the Excel document where you want to insert a hyperlink.

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

How to Insert Hyperlinks in Microsoft Excel Picture 10

Select the cell where you want to insert the hyperlink.

How to Insert Hyperlinks in Microsoft Excel Picture 11

Click Insert . This tab is in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the blue ribbon.

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

How to Insert Hyperlinks in Microsoft Excel Picture 12

Click Hyperlink . This option is on the right side of the Insert toolbar in the "Links" section. A window will open.

How to Insert Hyperlinks in Microsoft Excel Picture 13

Click Existing File or Web Page . Options are on the left side of the window.

How to Insert Hyperlinks in Microsoft Excel Picture 14

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 hyperlink text will simply be the directory path to the linked content.

How to Insert Hyperlinks in Microsoft Excel Picture 15

Select destination. Click one of the following cards:

Current Folder - Search for files in the Documents or Desktop folder .

Browsed Pages - Search through recently viewed web pages.

Recent Files - Search through recently opened Excel files.

How to Insert Hyperlinks in Microsoft Excel Picture 16

Select file or website. Click the file, folder, or web address you want to link. The folder path 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 box.

How to Insert Hyperlinks in Microsoft Excel Picture 17

Click the OK button at the bottom of the page. The hyperlink will be created in the specified cell.

Note: if you move content that is already linked, the hyperlink will be disabled.

Links within documents

How to Insert Hyperlinks in Microsoft Excel Picture 18

Open the Excel document. Double-click the Excel document where you want to insert a hyperlink.

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

How to Insert Hyperlinks in Microsoft Excel Picture 19

Select the cell where you want to insert the hyperlink.

How to Insert Hyperlinks in Microsoft Excel Picture 20

Click Insert . This tab is in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the blue ribbon.

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

How to Insert Hyperlinks in Microsoft Excel Picture 21

Click Hyperlink . This option is on the right side of the Insert toolbar in the "Links" section. A window will open.

How to Insert Hyperlinks in Microsoft Excel Picture 22

Click Place in This Document . This option is on the left side of the window.

How to Insert Hyperlinks in Microsoft Excel Picture 23

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 hyperlink text will simply be the destination cell name.

How to Insert Hyperlinks in Microsoft Excel Picture 24

Click OK . The link will be created in the selected cell. If you click a hyperlink, Excel automatically highlights the linked cell.

Create hyperlinks to email addresses

How to Insert Hyperlinks in Microsoft Excel Picture 25

Open the Excel document. Double-click the Excel document where you want to insert a hyperlink.

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

How to Insert Hyperlinks in Microsoft Excel Picture 26

Select the cell where you want to insert the hyperlink.

How to Insert Hyperlinks in Microsoft Excel Picture 27

Click Insert . This tab is in the green ribbon at the top of the Excel window. When you click Insert , a toolbar will appear just below the blue ribbon.

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

How to Insert Hyperlinks in Microsoft Excel Picture 28