How to Create a Link (Hyperlink) in Excel: 5 Clever Ideas

AUTHOR:  JASON MORRELL 

Jason Morrell

In this post you'll discover how to create a link from the current workbook to other content such as files, web pages, another location within the same workbook or create a new email that is pre-addressed and pre-subjected.

You'll also see how to create a link that can be activated from a text item or from a graphic (shape, picture etc.)

1. What are links (formerly called hyperlinks)?

A link is a special piece of text or a graphic (shape, picture, icon, 3D model etc.), that when clicked, takes the user to a specific place.

That ‘place’ might be another file, another place in the same file, a web page or a new e-mail message.

Links are most commonly found in websites.

Linked text is normally blue and underlined and changes to purple and underlined once the link has been visited.

2. Create a link to a specific cell in another workbook

1.  Click the Link icon on the Links group of the Insert ribbon or press Ctrl K.

Click the Link icon on the Insert ribbon, or press Ctrl K

    The Insert Hyperlink dialog box is displayed.

Create a link to another file

2.  In the Link To panel, on the left, select Existing file or web page.

3.  In the main area of the dialog box, navigate to file to be linked to. The path and filename will be displayed in the Address box.

4.  In the Text to Display box,  type the text that will be displayed in the cell(s) on the worksheet. If text was selected prior to opening this dialog box, it will already be displayed here.

6.  Click the Bookmark.. button. A list of worksheets available in the chosen workbook are displayed.

7.  Select a worksheet from the list.

8.  Select a cell within the worksheet.

9.  Click OK.

3. Create a screen tip

A screen tip can be provided, if required. A screen tip is the small label that appears when you hover the mouse pointer over a cell or graphic that contains a link.

Create a screen tip

1.  In the Insert Link dialog box, click the ScreenTip... button.

2.  Enter the screen tip text.

3.  Click OK twice.

Type the screentip text

4. Create a link to another place in the same workbook

1.  Click the Link icon on the Links group of the Insert ribbon  or press Ctrl K to open the Insert Hyperlink dialog.

2.  In the Link To panel, on the left, click Place in this document.

3.  The list of worksheets within the current workbook are displayed.

4.  Select a worksheet from the list.

5.  Select a cell or named cell / range within the worksheet.

6.  Set the Screen tip and Text to Display appropriately.

7.  Click OK.

Link to a specific cell within the same workbook

5. Create a link to a web page

1.  Click the Link icon on the Links group of the Insert ribbon  or press Ctrl K to open the Insert Hyperlink dialog box.

2.  In the Link To panel, on the left, click Existing file or web page.

3.  Type a web address in the Address box. NB. Just type the www address and the http:// or https:// component will be added automatically.

4.  Set the Screen tip and Text to Display appropriately.

5.  Click Ok

Create a link to a web page

6. Create a link to open up a new pre-configured email message

1.  Click the Link icon on the Links group of the Insert ribbon  or press Ctrl K to open the Insert Hyperlink dialog box.

2.  In the Link To panel, on the left, click E-mail address.

3.  Type in the addressee’s E-mail address.
The mailto: prefix is added automatically.

4.  Type in the Subject of the e-mail.

5.  Set the Text to display, if required.

6.  Click OK.

l

7. Edit an existing link

It is a little tricky to select a cell or graphic which has a link. It cannot be left-clicked because that would activate the Link. Instead:

1.  Right-click the text or graphic that contains the link. 

2.  Choose Edit Hyperlink from the context menu.

8. Remove a link

1.  Right-click the cell and choose Remove Hyperlink from the context menu.

9. Link to something from a graphic

  • Right-click on any graphic.
  • Choose Link, then build the link as described above.

10. Key Takeaways

  • To display the Link dialog box, press Ctrl K or click the Link icon (globe and chain link) on the Insert ribbon.
  • You can link to the following places:  - an existing  file, a file you haven't yet created, a web page, a location within your workbook and a pre-addressed and pre-subjected email.
  • You can activate the link from text or from a graphic.
  • A screen tip is a label that appears when you hover over a linked text or graphic.
  • To modify a Link, right-click on the linked text or graphic and choose Edit Link. Make your changes and click OK.
  • To delete a Link, right-click on the linked text or graphic and choose Edit Link. In the dialog box, click Remove Link and click OK.
  • To select a graphic that has a link, let’s say to resize it, first right-click the graphic, then left-click the graphic.

Please feel free to post any questions you have into the comments below. And before you leave this page, I want to give you one quick little action item! 

ACTION ITEM: Comment below with ONE thing you picked up from this post and share how it has helped, or will help, you. It's good to share your successes because it encourages others and provides an instant boost.

Enjoy the rest of your day!

Jason Morrell blog signature
About Jason Morrell

About the author

Jason Morrell


Jason loves to simplify the hard stuff, cut the fluff and share what actually works. Things that make a difference. Things that slash hours from your daily work tasks. He runs a software training business in Queensland, Australia, lives on the Gold Coast with his wife and 4 kids and often talks about himself in the third person!

SHARE

Check the RELATED articles below

Read More
How many rows and columns does Excel have?
Read More
Creating New Custom Excel Templates
Read More
10 Ways Excel Consultants Can Help You Fully Leverage Your Business Spreadsheets
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>