How to Insert Hyperlinks in Microsoft Excel

Link to new file

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 .

Select the cell where you want to insert the hyperlink.

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.

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

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

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.

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

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

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 .

Select the cell where you want to insert the hyperlink.

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.

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

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

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.

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.

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.

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

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 .

Select the cell where you want to insert the hyperlink.

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.

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

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

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.

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

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 .

Select the cell where you want to insert the hyperlink.

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.

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

Click E-mail Address . This option is on the left side of the window.

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.

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, the hyperlink will lead to a new email with the subject pre-populated.

Click the OK button at the bottom of the window.

Micah Soto

Update 11 November 2023

You should read it

May be interested

How to Insert Equations in Microsoft Word
modern versions of word have most of the symbols and equations that math experts need. you can enter these factors quickly using keyboard shortcuts or find them in the convenient equation menu, depending on your preference. the operation will be slightly different if you use a mac, or a word version from 2003 or lower. note, the 'insert object' method in word 2003 is not applicable to new versions. you can also write equations in word using the mobile app. this is an article showing how to insert equations in microsoft word in all cases.
How to Insert Symbols into Word Documents
today's tipsmake will show you how to insert symbols (such as copyright symbols or division signs) into microsoft word documents. you can do this in microsoft word on both windows and mac.
How to Insert Headlines in Excel
there are many ways to create titles in excel depending on different purposes. you can freeze a row so that it stays on the screen even if the reader scrolls down. if you want the title to appear on multiple pages, you can set up rows and columns to print on each page. if the data is organized into a table, you can use headers to filter the data.
How to Insert a Dotted Line in Word
today's tipsmake will show you how to add dotted or hyphenated lines anywhere in a microsoft word document. you can easily use keyboard shortcuts to add dotted lines across the page in word on both mobile devices and computers. if you want the line to be larger, stylized, or positioned differently, you can use the insert menu to add a line shape to the document and format the object in different styles.
How to Convert JPEG Images to Word Documents
sometimes, you get a headache because you can't change the content on a scanned file in jpeg format similar to when you edit an ms word document. ocr (optical character recognition) technology can help us convert scanned files in jpeg format into editable word documents to make the necessary changes. you can use an online ocr service, or download ocr software to convert.
How to Convert Word Documents to HTML Format
converting a .doc, .docx, or .odf file to html is simple, but there is no perfect method for completing this task. if you want to create a website that loads quickly and displays consistently across all browsers, you can use an online tool to convert word documents to html. if you want to store as many formats as possible, use word's built-in 'save as' function to convert this file.