SysChat

SysChat (http://www.syschat.com/forum.php)
-   Microsoft Office (http://www.syschat.com/tips-n-tricks/microsoft-office/)
-   -   Create a Hyperlink to a Different Document in an Excel Worksheet (http://www.syschat.com/create-hyperlink-different-document-excel-worksheet-6736.html)

dothy1005 03-18-2011 02:39 AM

Create a Hyperlink to a Different Document in an Excel Worksheet
 
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.


All times are GMT -4. The time now is 12:11 AM.


Copyright © 2005-2013 SysChat.com


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