SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Tips 'n' Tricks » Microsoft Office » Create a Hyperlink to a Different Document in an Excel Worksheet

Microsoft Office

tips on microsoft office suite

Comment
 
LinkBack Tip Tools
 

Create a Hyperlink to a Different Document in an Excel Worksheet

By dothy1005
03-18-2011
There would be times when you want to share data from other document in Excel. This short guide will teach you how you can create a hyperlink to another file.

First, launch your excel document and click on the cell where you want to insert the link. Go to the Insert tab and select the Hyperlink button. This will open the Insert Hyperlink box and this is where you may add the text to display. Then, look for the location of the file where you want to link too.

Once this is done, you will notice the text inside the cell is shown as a link. Hover the mouse pointer over the link and it will display the path going to the file.

If you click on the link, you will be brought to the file that you want to share. To go back to the original file that was opened, simply minimized the linked file and you will be brought back to the original file.

You can create a link in Excel to anywhere such as a webpage or a network location.
Comment





Similar Threads
Tip Tip Starter Category Tips Last Post
How to Create Custom Document Properties in Word dothy1005 Microsoft Office 0 01-24-2011 02:24 AM
How to convert Excel Worksheet into a graph sheet? dwarkarao Microsoft Office 0 03-17-2010 03:58 AM
What to do if: Word document does not open macsmith85 Articles 0 01-11-2010 05:11 AM
How to Create A Microsoft Excel Macro in 7 Steps dwarkarao Microsoft Office 0 12-03-2009 08:20 AM
How to deal with “The document you are opening contains macros..” error in MS Word macsmith85 Articles 0 11-06-2009 02:32 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are on



» Ads



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54