{"id":5002,"date":"2017-12-17T05:14:17","date_gmt":"2017-12-17T05:14:17","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=5002"},"modified":"2023-11-28T16:19:56","modified_gmt":"2023-11-28T16:19:56","slug":"4-ways-create-hyperlink-excel-5-examples","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/4-ways-create-hyperlink-excel-5-examples\/","title":{"rendered":"Creating Hyperlinks in Excel"},"content":{"rendered":"
The hyperlinks are useful for linking the other sheets or files and external URLs in the cells of Excel.<\/p>\n
There are a number of ways to create Excel hyperlinks.<\/p>\n
Let us look at these ways one by one with examples.<\/p>\n<\/div>\n
For creating a link to a webpage in an Excel cell follow this.<\/p>\n
One Simple Step:<\/strong><\/p>\n Type the URL in a cell and press Enter. Excel should automatically create a hyperlink to that webpage. For example:<\/p>\n <\/p>\n You can see that I created links by typing different texts. If you type www.example.com, Excel will automatically create that URL.<\/p>\n If you start with http:\/\/ or https:\/\/<\/strong><\/em>, it will be converted to a link as well.<\/p>\n If you just type google.com (without www or http:\/\/ or https:\/\/), Excel will not convert this into hyperlink automatically, as shown in A5 cell.<\/p>\n<\/div>\n You may create hyperlinks with many options by using the Insert --> Hyperlink<\/strong> button.<\/p>\n For that, select the cell where you want to create a hyperlink.<\/p>\n Now go to Insert in the ribbon<\/strong> and press the Hyperlink<\/strong> as shown below:<\/p>\n <\/p>\n You will see the Insert Hyperlink<\/strong> dialog:<\/p>\n <\/p>\n You can see many options there for creating hyperlinks to various targets including:<\/p>\n First, let us create the hyperlink to the Existing file or web page; the first tab that is already opened.<\/p>\n Enter the text in the \u201cText to Display\u201d textbox. This is the text that appears in the cell to be clicked by the user.<\/p>\n You may also create a screen tip that appears as the mouse hovers over the text in the cell. There, you may describe the purpose of the link etc. You may omit this if not important.<\/p>\n Below the \u201cText to display\u201d textbox, you can see three more tabs for:<\/p>\n If you want to link to the content for any of the above options then click it. Upon clicking any content, it will appear in the \u201cAddress<\/strong>\u201d box.<\/p>\n If you want to enter the URL\/filename yourself, just type in the Address box as shown below:<\/p>\n <\/p>\n A link in the A2 cell should have been created with a screen tip as shown below:<\/p>\n <\/p>\n Similarly, you may choose a file by pressing the \u201cRecent Pages\u201d or press the \u201cBrowse for File\u201d button to locate other files in the system. Press Ok, and a link to that file in the system should be created.<\/p>\nCreate links by Hyperlink button to URL or files<\/strong><\/h3>\n
\n
\n