There you can see text boxes for entering the: Press the “E-mail Address” under “Link to:”. The example of creating hyperlink to an email addressįor creating a hyperlink linking to an email address, again go to the “Insert Hyperlink” dialog box by right-clicking or from the Insert ribbon. If you click on that link, it will take to that named range in the sheet where you created it. After selecting the name, press OK.Ī link in the selected cell should be created. You should see the names there (as we just created “linked”). Press “Place in This Document” tab and select the “Defined Names” on the right side (shown below). To link this named cells range, select the cell in your current sheet where you want to create the link and open Hyperlink dialog box by “Insert –> Hyperlink”. In above graphic, the “linked” is the name for A3 to A6 rows. The name can be given in the textbox adjacent to the formula bar. To create names containing multiple cells, select cells in the sheet that you want link to and give it a name as shown below: You may also link to the defined names on another sheet. If you click on that link, the focus will move from current sheet to the selected sheet’s specified cell. Press OK and a link should be created with given text to that sheet.
In the “Type the cell Reference”, enter the cell that you want link to in that selected sheet e.g. You should see the list of all sheets that you have created in this workbook under the “Cell reference”. Below this is the “Type the cell reference”. One for the entering text to display in the cell “Text to display”. If you look at the right side, two text boxes should display. Now press the “Places in this document” tab:
Create a hyperlink in word 2013 how to#
After that, I will show you how to link to some other workbook.Īgain, open the “Insert Hyperlink” dialog by Insert in the ribbon –> Hyperlink or right-click in the cell where you want to create the hyperlink and click Hyperlink as shown below: For example, as referring to the sales by salespersons, you may require opening the detail sheet containing salesperson profiles.įollow the steps below for creating the hyperlink to the specific range in Excel for the same workbook. Linking to the specific part of an Excel sheet is also quite common. Ensure that, as you open the “Browse” dialog, press “All files” adjacent to “File name” textbox.īy default, it displays only the office files.Īn example of hyperlink to the specific location in Excel sheet text file, MS word file, another Excel document, a media file etc. Press Ok, and a link to that file in the system should be created. Similarly, you may choose a file by pressing the “Recent Pages” or press the “Browse for File” button to locate other files in the system. If you want to enter the URL/filename yourself, just type in the Address box as shown below:Ī link in the A2 cell should have been created with screen tip as shown below: Upon clicking any content, it will appear in the “Address” box. If you want to link to the content for any of the above options then click it. You may omit this if not important.īelow the “Text to display” textbox, you can see three more tabs for: There, you may describe the purpose of the link etc. You may also create a screen tip that appears as the mouse hovers over the text in the cell. This is the text that appears in the cell to be clicked by the user. You may also open the “Insert Hyperlink” dialog by right clicking on the cell and press “Hyperlink”.įirst, let us create the hyperlink to the Existing file or web page the first tab that is already opened.Įnter the text in the “Text to Display” textbox. You can see many options there for creating hyperlinks to various targets that include: Now go to Insert in the ribbon and press the Hyperlink as shown below: You may create hyperlinks with many options by using the Insert –> Hyperlink button.įor that, select the cell where you want to create a hyperlink. If you just type (without www or or Excel will not convert this into hyperlink automatically, as shown in A5 cell.Ĭreate links by Hyperlink button to URL or files If you start with or it will be converted to a link as well. If you type the Excel will automatically create that URL.
You can see, I created links by typing different texts. Excel should automatically create a hyperlink to that webpage. The Example of hyperlink in other spreadsheet’s cellĬreate a hyperlink to a webpage by simplest wayįor creating a link to a webpage in an Excel cell follow these steps. Creating a hyperlink by HYPERLINK function The example of creating hyperlink to an email address An example of hyperlink to the specific location in Excel sheet Create links by Hyperlink button to URL or files Create a hyperlink to a webpage by simplest way