Wednesday, 15 August 2012

How to create a Hyper link from Excel to a specific Section of a Word Document

How to create a Hyper link from Excel to a specific Section of a Word Document in other Location
If you want to create a hyperlink from your Excel to a  particular context/section in some page of a word document , you have do the following things.

>> First open the Word document
>> Next select desired text for which you have to create a book mark for hyper link as follows.



>> Here I have Defined a Bookmark as P_Summary for Professional Summary section.
>> After defining the Bookmark Name save and close the word document.

Note: 
Bookmark name does not allow spaces ,numbers, special characters except underscore.

>> Now open the Excel sheet and select a cell where want insert the hyperlink.
>> Next select the file from the hyper link dialogue box to create link.

>> Now add the Bookmark name following by ‘#’ to the Filename in the Address bar shown below.

Ex: Temp\Resum.doc#P_Summary

>> In the Text to Display address bar you can give your desired name.


Now click ‘OK’  you will see a desired hyper link as shown below.


Thanks.,
TAMATAM






No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts