Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
- Power Bi (35+)
In our data in any cell if we want a user to be redirected to a web page when user clicks on it we need to insert hyperlinks on the cell, to insert a hyperlink on the cell we need to right-click on the cell and then click the hyperlink which is the last option which opens a wizard box for us to insert a hyperlink, in the box for address enter the URL for the hyperlink.
Excel Hyperlinks (Table of Contents)
How to Insert Hyperlinks in Excel
A hyperlink is a link that opens up another web page, file or section of a file when you click on it. It is a kind of shortcut created to go to a particular destination. The link can be for any web page, email address, file in your system, a section of a file or text. The type of destination file and your default settings decides which software the file will open into. Suppose you create a hyperlink for a web page, it will open up in a web browser (Internet Explorer/ Chrome/Firefox, etc.) depending upon your default web browser. If the file is a pdf file, it will open in Adobe reader if that is your default pdf reader. Creating links in Excel is very simple and commonly used. When you click a cell containing the link, Excel opens up the specified destination. In Excel, you can display any text and create a hyperlink in excel without displaying the actual destination. You can also create a hyperlink link on an image.
It is necessary to give the correct path of the destination document. The path can be to a file stored on a hard drive, a universal naming convention (UNC) path on a server (in Microsoft Excel) or a Uniform Resource Locator (URL) path on the Internet or an intranet. When you create a hyperlink, its destination is a URL, such as:
In Excel, you can insert a hyperlink, in specific chart elements or in inserted images. There are different ways to use a hyperlink. By default, the links in excel can be created by just typing in the web address. The link will be automatically created. For an illustration, just type in the web address “www.google.com”
and press Enter. You will realize that it has been automatically converted to a link in Excel.
This setting may be changed by clicking the scroll down menu in blue.
You can select “Undo Hyperlink” if you do not want a hyperlink or “Stop Automatically Creating Hyperlinks”. If you want to create links in excel automatically but it is not happening in your Excel, you can go to the AutoCorrect Options and change the setting.
Additionally, there are other ways to insert hyperlinks in Excel. You can select the text or cell where you want to insert a link in excel and press CTRL + k (or COMMAND + k for Mac). Alternatively, click on select and insert Hyperlink.
A window will pop up where you can insert a link in excel and what text to display.
Now, suppose you want to display “Google” and it will link to “http://www.google.com”. You can add Google to Display option and the web address to Link to option.
Then select OK. A link in excel will be created.
When hyperlinks are to be added iteratively, this task may become very tedious. In such cases, you may also use the Hyperlink function to do this task. Let us see how to use the hyperlink function.
How to Insert Hyperlinks using the Hyperlink Function?
Below is the hyperlink formula in excel.
Arguments used for hyperlink formula
link_location: the link to insert. Required
[friendly_name]: the jump text or numeric value to display to the link. Optional
Link_location can be a web page, a file name along with its path to open a document. It can also refer to a place, a cell in Excel or a bookmark in a document. Friendly_name can be a text string, a name, a value or a cell containing the jump text or value. If this is omitted in the Hyperlink function, the cell will display the link_location as the jump text. In case the friendly_name returns an error value, the cell will display the error instead of the jump text.
Examples of Hyperlinks
Let’ss understand the Hyperlinks in excel with examples.
To insert a hyperlink in excel of “www.google.com” with display name “Google” using the Hyperlink function in Excel, you can type
= HYPERLINK(“http://www.google.com”, “Google”)
and press Enter.
Another way to create hyperlinks in excel is to drag and drop. You can simply drag any document to the Excel sheet and drop. It will create a hyperlink in excel for that document. This strategy can be very convenient for images etc.
Suppose you have a list of URLs and their corresponding names. The data is shown as:
You are required to insert hyperlinks of these web pages and display their corresponding names as the jump text.
To do this, you can use the below hyperlink formula in excel:
= HYPERLINK (B3, A3) for the first one.
and press Enter.
You will realize that the hyperlink has been created in excel. Now, you can simply drag it to the rest of the cells.
Suppose you have the sales and revenue data for the past month for different products as shown below.
For easier lookup, you want to create a hyperlink in excel of the products- Product A, B, C, and D. The images for these products are saved as “A.png”, “B.png”, “C.png”, and “D.png” and the location of the folder is given in cell J12.
To insert hyperlinks in excel for images, you can use the Hyperlink Formula:
= HYPERLINK( ($J$12 & B5 & “.png”), “Product ” & B5)
When you press Enter, the link will be created for the image.
When you click at the link, the image will open for that product.
Now, you can drag it to the rest of the cells to create the hyperlinks in excel for the rest of the products.
Uses of Hyperlinks in Excel
You can use hyperlinks to navigate to a file or a web page on a network: internet or intranet. You can also start a file download or transfer directly by clicking at the link. create a hyperlink in excel for a file which you may want to add in the future. Hyperlinks are commonly used for email addresses. When you click on an email address, it starts to send an email to that address.
In Excel, one problem with the hyperlinks is that it automatically jumps to the hyperlink destination when you select the cell containing the hyperlink. To avoid this problem and select a cell containing a hyperlink without jumping to the hyperlink destination, you can click the cell and keep holding the mouse button until the pointer changes to a cross, then you can release the mouse button.
Sometimes in Excel, the hyperlink is created but when you click at it, it does not open the specified document. One of the reason could be that the permission to access that document of software or internet is denied. You need to change the permission settings in such cases.
Things to Remember About Hyperlinks in Excel
- The link in Excel can be created for any document on the hard drive or for any URL on the Internet or intranet
- A hyperlink can be created on any text in a cell, image or charts.
- A hyperlink can be created for any file, section of a file, email address, web page, etc.
- There are different methods to create hyperlinks in Excel. You can use the drag-drop option, or use excel shortcut CTRL + k or by using the HYPERLINK function.
This has been a guide on how to insert Hyperlinks in Excel. Here we discuss the top ways to create hyperlinks including drag and drop, excel short CTRL+k and Hyperlink Formula along with excel example and downloadable excel templates. You may also look at these useful functions in excel –