Geekers - – Hyperlink is a way to link a section in a file or document. The Hyperlink function creates a shortcut that goes to another location in the current worksheet, or opens a document stored on a network, intranet, or Internet server. When you click a cell containing the hyperlink function, Excel will move to the listed location, or open the specified document.
To beautify the appearance of applications made in Office Excel, we can also use click buttons or hyperlinks. In addition, this click button also functions to make it easier for users if they want to go to another Sheet. But it is not recommended to make hyperlinks if there are very few Sheets in the application that is created.
The main function of the hyperlink is as a substitute for the Sheet click button if it turns out that there are a large number of Sheets in one application. Many Sheets in one application will make it difficult for users later, so instead of that you should make a hyperlink or click button to go to other Sheets. Then, how do you make hyperlinks in Excel?
How to Create Hyperlinks in Microsoft Excel
Well, this time I will share about how to make hyperlinks in Microsoft Excel very easily. how do? Just follow the steps below.
1. First, please make some posts that you want to make links. For example, as in the image below.
How to Create Hyperlinks in Microsoft Excel How to Create Hyperlinks in Microsoft Excel
2. Then, please go to the Insert menu which is at the top. As in the picture below.
insert inserts
3. Then, please click "Hyperlink". As in the picture below. However, beforehand make sure you have directed to the article you want to make a link.
hyperlinks hyperlinks
4. Then, the insert hyperlink window will appear. Please select the link like what you want. There will be 4 types of link options. For example, you want the link to a file. Please click on the “Existing File or Web Page� section. Then, please select the file you want. Then, please click “Ok�. As in the picture below.
How to Create Hyperlinks in Microsoft Excel How to Create Hyperlinks in Microsoft Excel
5. Then, you can also make the link to another worksheet. Please select the "Place in this document" section. Then, please select the sheet you want. Then, please click “Ok�. As in the picture below.
select sheet select sheet
6. Or you can also make the link to a new file. Please click on the “Create new document� section. Then, please fill in the name of the new file you want. Then, please click Ok. As in the picture below.
new file new file
7. Or you can also make the link go directly to the email address. Please click on the “Email Address�. Then, please enter the destination email address you want. Then, please click Ok. As in the picture below.
How to Create Hyperlinks in Microsoft Excel How to Create Hyperlinks in Microsoft Excel
8. Done.
Can We Delete Hyperlinks That Have Been Created?
Of course you can. We can remove the hyperlink or restore it. how do? The method is very easy. Immediately, see the steps - the following steps.
1. Please right-click on the text that contains the hyperlink. Then, please click "Remove Hyperlink".
remove hyperlinks remove hyperlinks
2. Then, the hyperlinks in your writing will be automatically deleted.
And you can also edit the hyperlinks that you have created.
1. Please right-click on the posts that have hyperlinks. Then, please click “Edit Hyperlink�. As in the picture below.
edit hyperlinks edit hyperlinks
2. Then, an insert hyperlink window will appear which you can edit again.
Well, how? The method is quite easy and very simple, right? Now we can make hyperlinks in Excel very easily.
That's how to easily create hyperlinks in Microsoft Excel that you can try. If this article can help you, please share it with your friends so they also know how to make hyperlinks in Microsoft Excel. Hopefully this article can be useful for all of us. If there is a writing error please forgive. Thank you 🙂
RELATED TUTORIALS
* How to Make Diagrams in Excel, Suitable for Beginners
* 2 Ways to Change the Display Theme in Microsoft Excel
* Tutorial on How to Make a Pivot Table in Microsoft Excel
* How to Make a Number Receipt in Microsoft Excel