Microsoft Excel is a strong data organizing, analysis, and presentation application. Among its numerous capabilities, one of the most useful is the ability to emphatically incorporate hyperlinks into your spreadsheet. Additionally, you may also create a link that takes the reader directly to a certain section of the text or spreadsheet. Type or paste the whole file path and file name of the document or workbook you want to connect to, then an exclamation mark(!) and the cell reference of the location you want to link to, into the connect to box. Excel, even more so, allows you to insert a URL into a picture. To achieve this, select the desired image via the Browse button in the Link to box. Do you want to know more about inserting hyperlinks in Excel? Indeed, this article is for you.
This comprehensive blog post discusses how to insert a hyperlink in Excel.
Insert a Hyperlink in Excel
In this part, we’ll chiefly go through two methods for inserting a hyperlink in Excel: the right-click menu and the insert tab. Hyperlinks make it easier to navigate Excel documents by connecting cells, online pages, locations, and existing files. When working on a large Excel spreadsheet, inserting hyperlinks is critical.
Select the cell where you wish to insert the hyperlink and right-click it to open the context menu.
Using the Context Menu in Microsoft Excel to Create Hyperlinks
1. Go to the “Link” menu and select “Insert Link.”
2. This command displays the “Insert Hyperlink” dialog box.
3. Enter a description for the cell content in the “Text to display” field.
4. Select the type of connection you wish to create from the options below:
- Existing document or web page: Enter the URL of the file or webpage to which you want to link.
- Location of the link – Existing file or Web Page
- Place in this report: By supplying the cell reference, you can link to a specific position within your workbook.
- Hyperlinks – Current workbook
- Email address: Enter the email address that will be accessed when you click the link.
- After you’ve made your choice, click “OK” to insert the hyperlink.
- To insert the hyperlink, press the “OK” button.
#2. Making Use of the Insert Tab
Follow these procedures to insert hyperlinks via the “Insert” tab:
1. Open the Excel document and pick the cell where you want the hyperlink to appear.
2. Select the “Insert” tab from the toolbar.
3. Navigate to the “Links” section and select the “Link” icon.
4. In the “Insert Hyperlink” dialog box, provide a description for your cell content in the “Text to display” field.
5. As with the right-click menu technique, select the type of connection you wish to create and enter the required information.
6. You may furthermore add a “ScreenTip” for a more extensive description that appears when the mouse is hovered over the hyperlink.
Click the “ScreenTip” button, provide a description in the text area, and then click “OK.” Finally, use the “OK” button to enter the hyperlink into the specified cell.
To insert the hyperlink, press the “OK” button.
You can easily insert hyperlinks in Excel to increase navigation and accessibility in your spreadsheets by following these simple steps.
#3. Using Excel’s Hyperlink Function
Excel’s Hyperlink feature allows users to directly create and change links to other locations, such as websites or other documents, from within a cell. This Excel function allows you to specifically reference external resources and navigate between different areas of a spreadsheet or related files. The HYPERLINK() function has the following syntax:
HYPERLINK(link_location, [friendly_name])
#4. Using Excel’s Hyperlink Shortcut
To quickly insert a Hyperlink in a certain cell at times, you can similarly use the Excel keyboard shortcut. To insert a hyperlink using this method, do the following:
1. Choose the cell into which you wish to enter the hyperlink.
2. Hold down Ctrl + K. You must press the Control key and the letter “K” simultaneously. Excel will thereafter show the “Insert Hyperlink” dialog box.
3. In the Text to Display box, type the text that you wish to appear in the hyperlink.
4. In the cell reference box, enter the file location or cell address.
5. To insert the hyperlink, click OK.
6. Following this, on the selected cell, you will see the Hyperlink with the friendly name. You can easily navigate to the link’s destination by further clicking it.
The shortcut for inserting a hyperlink in Excel Unlike the Hyperlink function, the link destination cell address is not visible in the formula bar. You will only see the hyperlinked text.
How to Hyperlink a Cell to Another Sheet in Excel
Hyperlinking to an Already-Existing File or Webpage
#1. Open an Excel spreadsheet.
Double-click the Excel document where you want to put the hyperlink.
- Open a new document by double-clicking the Excel icon and then selecting Blank Workbook.
- Hyperlinks are an excellent way to organize and connect data from several Excel pages.
#2. Choose a cell.
This is the cell where you wish to place your hyperlink.
This tab is located at the top of the Excel window on the green ribbon. Insert brings up a toolbar just beneath the green ribbon.
- If you’re using a Mac, you’ll notice an Excel Insert tab and an Insert menu item in the menu bar. Choose the Excel Insert tab.
#4. Select Link.
It’s in the “Links” area on the right side of the Insert toolbar. This brings up a pop-up menu.
#5. Select Insert Link.
It can be found at the bottom of the Link pop-up menu. This brings up the Insert Hyperlink dialog box.
#6. Select an existing file or web page.
It is located on the left side of the window.
#7. Fill in the Text for the Hyperlink.
Fill in the “Text to display” field with the text you want to see displayed.
- If you don’t do this, the content of your hyperlink will just be the folder path to the referenced item.
#8. Choose a Location.
You can select a file location on your computer, enter a file or web page address, or even more explore the internet. Here are some possible destinations:
- .Current Folder – Look in your Documents or Desktop folders for files.
- .Browsed Pages – Look through the most recently visited web pages.
- Recent Files – Search for Excel files that have recently been opened.
In the “Address” field, enter the URL and name of a web page or file. This might be a web page URL, for example. Navigate to the Browse the Web button. Return to Excel after visiting the web page you’re linked to. Don’t shut down your browser!
#9. Choose a File or a Website.
Select the file, folder, or web address you want to link to. The folder’s path will eventually be displayed in the “Address” text box at the bottom of the window.
#10. Select OK.
It is located at the bottom of the page. This places your hyperlink in the cell you specify.
Comparatively, it should be noted that if you move the item to which you connected, the hyperlink will on the negative side, no longer function.
How Do You Create a Hyperlink?
Choose the text or image you want to use as a hyperlink. You may also access the shortcut menu by right-clicking the text or image and selecting Link. Type or paste your URL in the Address box in the Insert Hyperlink box.
What Is the Shortcut Key to Insert a Hyperlink in a Spreadsheet?
Ctrl + K – This shortcut inserts a hyperlink in the cell you’ve selected. Simply choose the cell into which you wish to enter the hyperlink and press Ctrl + K. A dialog box will certainly appear in which you can input the URL or cell phone number to which you want to link.
What Are the First 3 Steps in Creating a Hyperlink?
How to Create a Hyperlink
- Launch the text editor. To make a hyperlink, first open the text editor.
- Highlight text. You can link the text by highlighting it.
- Look for the link icon. The link icon can be found in your text editor’s toolbar.
- Insert the link here. Click on the link icon once you’ve found it.
What Are the Two Ways to Create Hyperlinks?
To create a hyperlink to a Web page, select Link to a URL and then enter the URL. To link to a PDF, Microsoft Word, or other document, identically click Link to a Document and enter or browse to the document’s location.
How Do I Create a Hyperlink Directly to a Document?
Create a link to another document’s location.
- Choose the text or image you want to use as a hyperlink.
- Select the Message tab of the ribbon.
- Click Existing File or Web Page under Link to.
- Click the down arrow in the Look in box and navigate to and likewise choose the file you want to connect to.
Which Is a Hyperlink Type Available in Excel?
In Excel, use the ‘Insert Hyperlink’ dialog box to insert a hyperlink to an existing file, a web page, or a location within this document. The HYPERLINK function can also be used.
How Do I Create a Hyperlink to an Image in Excel?
To insert an image in Excel, firstly, use the Insert option to insert an image. The Link option is equally available from the same Insert menu. Clicking on it will surely bring up the Insert Hyperlink dialog box. Subsequently, select the type of hyperlink you want to insert and add it afterward.
Conclusion
It is explained in the article “How to Insert a Hyperlink in Excel” how to include hyperlinks in Excel spreadsheets. Simple instructions are otherwise provided, especially choosing the text or cell, clicking the “Insert Hyperlink” button, and subsequently entering the link address. The article additionally shows how to modify and get rid of the hyperlinks. To get the most out of the Excel hyperlink feature, follow the recommended practices. Excel will perform better if you use all the hyperlink features!
- HOW TO UNHIDE COLUMN A IN EXCEL: EASY Guide
- HOW TO ADD TIME IN EXCEL: Fast & Easy Guide
- HOW TO EMBED A VIDEO IN GOOGLE SLIDES: EASY Guide
- HOW TO ADD CHECKBOX IN WORD: Easy Steps & Tricks
References
