How to Insert Hyperlinks in Microsoft 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
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 29
Click E-mail Address . This option is on the left side of the window.
How to Insert Hyperlinks in Microsoft Excel Picture 30
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.
How to Insert Hyperlinks in Microsoft Excel Picture 31
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.
How to Insert Hyperlinks in Microsoft Excel Picture 32
Click the OK button at the bottom of the window.
You should read it
- How to Insert Hyperlinks in Microsoft Word
- How to Insert Hyperlinks in Microsoft Excel
- This is a simple way to find and delete Hyperlink in Excel
- How to insert links, links, Hyperlinks in Gmail
- Hyperlink (Hyperlink) in PowerPoint 2016
- How to create hyperlinks in excel is extremely useful
- Create Hyperlink in Excel
- How to insert a Word document into an Excel file
- MS Word - Lesson 14: Create Web Pages
- How to insert watermark, logo sink into Excel
- How to insert trendlines in Microsoft Excel
- How to insert a batch image into Excel box