Discussion Locked

MS Word type "bookmarks" in Excel

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do you create a "bookmark" in an Excel cell that can be referenced (hyperlinked) in an MS Word document? I've tried naming an Excel cell, but can only find a way to hyperlink to the Excel file but not down to the cell level from MS Word. I want to be able to click onto a link in a Word document that will bring the user to the specific cell in an Excel spreadsheet.

6 replies

by dklippert

I named my range Target. I then used the Insert Hyperlink function (Ctrl+K) and entered:

C:\Documents and Settings\Administrator\My Documents\test.xls#Target

The resulting hyperlink will look different if you look at the underlying code, but just use the code above.

by marwalk

I tried naming a cell in the Name box and used the #Name format in the hyperlink reference in MS Word, but the link just goes to the Excel file itself but not to the referenced named cell. Is there a different way to create and internal anchor in the Excel document that will go directly to the cell?

by dklippert

Make sure that your Excel range name really exists. Put the name in the Name box and then hit Enter. You can also verify by going to Insert>Name>Define

This discussion is closed to new replies.