ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Hyperlinks (https://www.excelbanter.com/excel-discussion-misc-queries/258239-excel-hyperlinks.html)

Nickbray

Excel Hyperlinks
 
Is there a way of linking an Excel cell to a particular location in another
document, for example a paragraph in a Word document or a page in a OneNote
notebook? Thanks!

Peter T

Excel Hyperlinks
 
Start to Insert a Hyperlink, Ctrl-k
In the address box enter the full path and file name of the dcoument and the
anchor location preixed with a #, eg

C:\Documents and Settings\Owner\My Documents\TmpLink.doc#myBookmark

In the Word document you will need to have already inserted and named a
Bookmark at the particular location.

Regards,
Peter T

"Nickbray" wrote in message
...
Is there a way of linking an Excel cell to a particular location in
another
document, for example a paragraph in a Word document or a page in a
OneNote
notebook? Thanks!




Nickbray

Excel Hyperlinks
 
Thanks, Peter! This works great for Word. OneNote doesn't have bookmarks,
so I posted a question in the OneNote forum for how to connect to a location
in OneNote.

"Peter T" wrote:

Start to Insert a Hyperlink, Ctrl-k
In the address box enter the full path and file name of the dcoument and the
anchor location preixed with a #, eg

C:\Documents and Settings\Owner\My Documents\TmpLink.doc#myBookmark

In the Word document you will need to have already inserted and named a
Bookmark at the particular location.

Regards,
Peter T

"Nickbray" wrote in message
...
Is there a way of linking an Excel cell to a particular location in
another
document, for example a paragraph in a Word document or a page in a
OneNote
notebook? Thanks!



.



All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com