Create a Link to another file or cell in workbook

image_pdf

For quick access to releated information in another file or webpage or cell in different worksheet, we can use Hyperlink in worksheet cell.

To create a hyperlink, execute the following steps.

1. On the Insert tab, click Hyperlink.

2. The 'Insert Hyperlink' dialog box appears.

Text to display: Write text to display on worksheet cell. For Example, "Click Here to open file". Browse through the folder to select required file. Click OK.

Result: Hyperlink is created in cell A1. When you rest the mouse cursor on Hyperlink, it will display screentip. By default screentip is address of selected file.

3. You can change the Screentip to display more relevant information. Press Ctrl+K (Shortcut to Hyperlink file) to open Edit Hyperlink dialog box. Click on Screentip and change text.

Result: Screen tip is changed and more relevant to linked file.

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

Result:

Note: If you want to change the text appears when you hover the link, click Screen Tip

Place in this document

Type the Text to display cell reference and click OK.

Result:

Explore More, It's Amazing…

Share and Link Excel data with Word document

How to Share a Workbook and track changes in Excel

 

 

2,049 total views, 1 views today

5 thoughts on “Create a Link to another file or cell in workbook

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>