Hyperlink in excel to another worksheet

Use the 'Insert Hyperlink' dialog box in Excel to create a hyperlink to an existing file, a web page or a place in this document. You can also use the HYPERLINK function.

Existing File or Web Page

To create a hyperlink to an existing file or web page, execute the following steps.

1.

Select cell A1.

2.

Excel link to another tab in same workbook

On the Insert tab, in the Links group, click Link.

The 'Insert Hyperlink' dialog box appears.

3a. To create a hyperlink to an existing file, select a file (use the Look in drop-down list, if necessary).

3b.

To create a hyperlink to a web page, type the Text to display, the Address, and click OK.

Result:

Note: if you want to change the text that appears when you hover over the link, click ScreenTip.

Place in This Document

To create a hyperlink to a place in this document, execute the following steps.

1.

Select cell A2.

2.

How to create a link to an excel file in an email

On the Insert tab, in the Links group, click Link.

The 'Insert Hyperlink' dialog box appears.

3. Click 'Place in This Document' under Link to.

4. Type the Text to display, the cell reference, and click OK.

Re

how to create link in excel to another cell

how to create link in excel to send email