Excel Tutorials
Learn Excel - Chapter 10
Excel Hyperlink
For quick access to related information in another file or on a web page, you can insert a hyperlink in a worksheet cell. You can also insert hyperlinks in specific chart elements.How to Create a Hyperlink to a New File
1) On a worksheet, select the cell where you want to create a hyperlink.We can also select an object e.g. a picture or an element in a chart, that you want to use to represent the hyperlink.
2) Click Hyperlink which is present On the Insert tab, in the Links group.
You can also right-click the cell or graphic and then click Hyperlink on the shortcut menu, or you can press Ctrl+K.
3) Under Link to, click Create New Document.
4) In the Text to display box, type the text that you want to use to represent the hyperlink.
In the Name of new document box, type a name for the new file.
Under When to edit, click Edit the new document later or Edit the new document now to specify when you want to open the new file for editing.
5) The Screentip command can be used to display helpful information when you rest the pointer on the hyperlink. Type the text that you want in the ScreenTip text box, and lastly click OK.
Create a Hyperlink to an existing file or web page
1) On a worksheet, click the cell where you want to create a hyperlink.You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.
2) On the Insert tab, in the Links group, click Hyperlink.
You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press Ctrl+K.
3) Under Link to, click Existing File or Web Page.
Do one of the following:
- To select a file, click Current Folder, and then click the file that you want to link to.
- You can change the current folder by selecting a different folder in the Look in list.
- To select a web page, click Browsed Pages and then click the web page that you want to link to.
- To select a file that you recently used, click Recent Files, and then click the file that you want to link to.
- To enter the name and location of a known file or web page that you want to link to, type that information in the Address box.
- To locate a web page, click Browse the Web icon , open the web page that you want to link to, and then switch back to Excel without closing your browser.
- If you want to create a hyperlink to a specific location in the file or on the web page, click Bookmark, and then double-click the bookmark that you want.
4) In the Text to display box, type the text that you want to use to represent the hyperlink.
5) To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.
Create a hyperlink to a specific location in a workbook
To link to a location in the current workbook or another workbook, you can either define a name for the destination cells or use a cell reference.To use a name, you must name the destination cells in the destination workbook.
How to name a cell or a range of cells
Select the cell, range of cells, or nonadjacent selections that you want to name.Click the Name box at the left end of the Formula bar
In the Name box, type the name for the cells, and then press Enter.
Note: Names can't contain spaces and must begin with a letter.
1) On a worksheet of the source workbook, click the cell where you want to create a hyperlink.
You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.
2) On the Insert tab, in the Links group, click Hyperlink.
You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press Ctrl+K.
3) Under Link to, do one of the following:
- To link to a location in your current workbook, click Place in This Document.
- To link to a location in another workbook, click Existing File or Web Page,locate and select the workbook that you want to link to, and then click Bookmark.
Do one of the following:
- In the Or select a place in this document box, under Cell Reference, click the worksheet that you want to link to, type the cell reference in the Type the cell reference box, and then click OK.
- In the list under Defined Names, click the name that represents the cells that you want to link to, and then click OK.
5) To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.
Create a hyperlink to an email address
When you click a hyperlink to an email address, your email program automatically starts and creates an email message with the correct address in the To box, provided that you have an email program installed.1) On a worksheet, click the cell where you want to create a hyperlink.
You can also select an object, such as a picture or an element in a chart, that you want to use to represent the hyperlink.
2) On the Insert tab, in the Links group, click Hyperlink.
You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press Ctrl+K.
3) Under Link to, click E-mail Address.
In the E-mail address box, type the email address that you want.
In the Subject box, type the subject of the email message.
Note: Some web browsers and email programs may not recognize the subject line.
4) In the Text to display box, type the text that you want to use to represent the hyperlink.
5) To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.
Change Hyperlink
You can change an existing hyperlink in your workbook by changing its destination, its appearance, or the text or graphic that is used to represent it.Change the destination of a hyperlink
1) Select the cell or graphic that contains the hyperlink that you want to change.2) On the Insert tab, in the Links group, click Hyperlink.
You can also right-click the cell or graphic and then click Edit Hyperlink on the shortcut menu, or you can press Ctrl+K.
3) In the Edit Hyperlink dialog box, make the changes that you want.
Delete Hyperlink
To delete a hyperlink, do one of the following:- To delete a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and then click Clear Contents on the shortcut menu.
- To delete a hyperlink and the graphic that represents it, hold down Ctrl and click the graphic, and then press Delete.
- To turn off a single hyperlink, right-click the hyperlink, and then click Remove Hyperlink on the shortcut menu.
- There is also Remove Link command in the Edit Hyperlink window.
To Learn Advanced Excel - Goal Seek / Data Table Whatapp/Call 8422000829. Disount Code WEBSAB501
Home Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Excel Shortcuts
Keeping Learning...