![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: May 2002
Location: Iowa
Posts: 118
|
Is it possible to create a hyperlink from a cell in excel to a specific bookmark in a multipage word file? If so how do I do this?
|
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Posts: 7,743
|
Yes you can create a hyperlink to Word. Not sure about a specific page though.
In a cell, enter a name and save the workbook. click on the cell and click Insert Hyperlink, it's the one with the icon of the "world". Type in the path to the Word document. The name in the cell should be blue and underlined. |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: May 2002
Location: Iowa
Posts: 118
|
I've been able to link to the Word document but I want to be able to link to a specific section of the document. Does anyone know if this is possible?
|
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 1,802
|
yes this is possible, use the HYPERLINK formula, example:
=HYPERLINK("C:My DocumentsTheFile.doc #TheBookMark") |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|