Hyperlinks play a crucial role in enhancing the functionality and navigability of Excel spreadsheets. It can help you link to a separate page in the workbook, a different cell in the same worksheet, or even another website. Using it to its full potential can help you organize your data and create more interactive, user-friendly spreadsheets. We will teach you how to hyperlink on Excel in 5 easy ways.
How to Hyperlink on Excel in 5 Ways
Inserting hyperlinks in Excel to access information on other documents is very easy. Now let’s explore the world of Excel hyperlinks and see how we can make the most of your data!
Option 1: To a Webpage
Follow the steps mentioned below to insert a hyperlink in Excel to a webpage:
1. Open the Excel worksheet and select the cell where you want to insert the hyperlink.
2. Click on Insert in the tab and select the Link option.
3. Select Insert Link…
Note: You can also right-click on the cell in which you want to insert a link and select Link.
4. Select Existing File or Web Page under Link to.
5. Either click on browsed pages and select the web page or enter the web address in the address bar.
6. Click on OK.
Now you will be able to hyperlink the webpage to a cell in Excel.
Option 2: To a File
Follow the steps mentioned below to insert a hyperlink in Excel to a file:
1. Follow steps 1-3 from the previous heading.
2. Select Create New Document.
3. Type the text you want to display under Text to display.
4. Enter the name of the document under Name of new document.
5. Enter the location of the document under Full path.
6. Choose among two editing options: Edit the new document later or Edit the new document now.
7. Click on OK.
Now you will be able to hyperlink a file to a cell in Excel.
Also Read: How to Clear Formatting in Excel Using Shortcut
Option 3: To a New Email Message
Follow the steps mentioned below to insert a hyperlink to a new email message:
1. Follow Steps 1-3 from the previous heading.
2. Select E-mail Address under Link to.
3. Enter the text you want under the Text to display option.
4. Enter the Email address in the email address box.
5. Under Subject, type the subject line.
6. Click on OK.
Now you will be able to hyperlink email addresses to a cell in Excel.
Option 4: To a Specific Location in Workbook
Follow the steps mentioned below to insert a hyperlink in Excel to a specific location in a workbook:
1. Follow steps 1-3 from the previous heading.
2. Select Place in This Document.
3. Under Type the cell reference, enter the cell reference.
4. Under Cell Reference, select the sheet you want to link to.
5. Enter the text you want under the Text to display option.
6. Click on OK.
Now you will be able to hyperlink a file to a cell in Excel.
Option 5: With Hyperlink Function
The easiest way to combine text and hyperlinks in Excel is by using the insert hyperlink dialog box. Follow the steps mentioned below:
1. Open Excel and place your link and text next to each other.
2. Type =HYPERLINK( and click on the cell where you have placed the link.
3. Now, put a comma in the formula and click on the text. Here we have chosen Techcult.
4. Enter the closing bracket and hit Enter.
Your text will be converted into a hyperlink.
Also Read: 10 Ways to Fix Excel Opening in Protected View Stuck
What is the Shortcut for Hyperlink in Excel?
The shortcut to insert hyperlinks in Excel is CTRL + K keys.
How to Insert Hyperlink in Excel Cell with Other Text
You can use the Hyperlink function to insert hyperlinks in Excel with other text i.e. =HYPERLINK() in the cell where you want to insert.
How to Create Multiple Hyperlinks in Excel Spreadsheet All at Once
Excel does not allow you to add multiple hyperlinks in the spreadsheet at once. But you can also insert several hyperlinks on Excel with other text over cells. Follow the steps under Option 5: With Hyperlink Function and then hover your cursor at the bottom right corner of that first cell. Once the cursor turns into a plus sign, drag to the last row up to which you want to hyperlink.
How to Insert Multiple Hyperlinks into the Same Cell in Excel
You can also use shapes to create multiple hyperlinks over texts in a single cell using shapes. Here’s how:
1. Click on Insert > Shapes and select rectangle shape.
2. Place the shape over the word you wish to link on.
3. Click on Shape Fill and select No Fill.
4. Right-click on the shape and select Link.
5. Paste your link and click on OK.
6. Now, right-click on your shape and select Format Shape…
7. Select Line and click on No Line.
Note: The text won’t appear in blue or have a line under it. So, you can manually change the color and apply the underline.
Also Read: 5 Ways to Remove Hyperlinks from Microsoft Word Documents
How to Change the Appearance of Link Text in Excel
Follow the steps mentioned below to change the appearance of link text in Excel:
1. Under the Home tab, go to Styles.
2. Select Cell styles.
3. Right-click on the hyperlink option under Data and Model and select Modify.
4. Select Format… in the Style dialog box.
5. Edit the changes that you want and click on OK.
The appearance of your cell link will be changed.
How to Change the Text or Graphic for a Link in Excel
To change the text for a link in Excel, right-click on that cell and select Edit Hyperlink. In the Text to display field, you can the text for the link. You can also use the hyperlink shortcut (Ctrl + K keys) to edit the hyperlink text in Excel.
Note that the above method won’t work if you have linked using the Hyperlink function.
To change the text or graphic for a link in Excel, follow the same steps in the above heading. Then, go to Font or Fill to change the graphic or font style of your link and click on OK.
Now the graphics or font of your hyperlink will be changed according to your choice.
Also Read: How to Create Hyperlinks to Anchor Text on Facebook
We hope our comprehensive guide on how to hyperlink on Excel has cleared all your doubts. Give these methods a try and let us know which one of these worked the best for you. Keep reading our blog for more information and leave your queries and suggestions below in the comments section.
