Hyperlink. Use a formula to format hyperlinks: Hyperlink to an Excel sheet Hyperlink to a webpage 3 ways to enter hyperlinks in Excel (Easy steps) 1. Select cell B7. 2. On the Insert tab, in the Links group, click Link. Click link. The Hyperlink Insert dialog box appears. Hyperlink to Excel Sheet Hyperlink to a web page Hyperlink to WebPage 1. Click Link on the Insert tab. 2. On the Insert tab, click Hyperlink. 3. Type a cell reference. Hyperlink to Excel sheet. If you did not enter the cell, click Add a range. 4. Click the Cells tab. 5. Click the cells you want to hyperlink to. 6. Press Enter. 7. In the URL, type the complete Uniform Resource Locator (URL) to be the link. Hyperlink to Excel sheet URL Hyperlink to WebPage URL Hyperlink to Workbook Sheet Hyperlink to Excel Sheet Hyperlink to WebPage Hyperlink to Excel workbook link. If you click OK, the Hyperlink tab will close. Hyperlink to WebPage URL Hyperlink to Excel sheet Hyperlink to Excel sheet Hyperlink to Workbook Sheet Hover the mouse over this hyperlink to the left of the link in the cell 4 day ago — Using the HYPERLINK function is one of the simple way in Excel to create links between the workbook and the website that contains the data. Create custom Hyperlinks — When you want to create hyperlinks between different workbooks at the same time, here are the steps you need: 1. Select cell A2. 2. On the Insert tab, in the Links group, click Link. Click link. 3. Type an Excel hyperlink. 4. Click the cells you want to hyperlink to. 5. Press Enter. 6. In the URL, type the complete Uniform Resource Locator (URL), such as. 7. Click OK. 8. In the links group, right-click the hyperlinks group.