How do I add a link in a Google Spreadsheet to a specific paragraph or header in a Google Doc?
migrated from superuser.com Aug 13 '11 at 2:54
To add a link in a Google Spreadsheet you can use the formula
For that link to point to a specific position in a Google Doc, use the Headings feature and create a Table of contents, from which you can take the anchor link to that specific part of the document.
To add a table of contents follow these steps:
From the man page: http://docs.google.com/support/bin/answer.py?hl=en&answer=106342
So, take the document's link and add to it the anchor from the respective heading.
Here is a document I've created, that opens to a specific point.
You can also get the URL of a header without creating a Table of Contents.
Put the cursor on the header itself, then look at the address bar of your browser. It should change to update the fragment (hash - #) at the end like