{"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":"
\n

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

Create a hyperlink to a webpage by simplest way<\/strong><\/h3>\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

\"Excel<\/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

\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

Create links by Hyperlink button to URL or files<\/strong><\/h3>\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

\"Excel<\/p>\n

You will see the Insert Hyperlink<\/strong> dialog:<\/p>\n

\"insert<\/p>\n

You can see many options there for creating hyperlinks to various targets including:<\/p>\n