Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

How do I add a link in a Google Spreadsheet to a specific paragraph or header in a Google Doc?

share|improve this question

migrated from superuser.com Aug 13 '11 at 2:54

This question came from our site for computer enthusiasts and power users.

2 Answers 2

up vote 1 down vote accepted

To add a link in a Google Spreadsheet you can use the formula =HYPERLINK( "www.google.com" ; "Search Google" ).

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:

  1. Add headings to your document by clicking Format > Paragraph styles in the toolbar, and selecting a heading.
  2. Click Table of contents from the Insert menu. The table of contents appears wherever you've clicked in the document, so make sure you place your cursor where you want to add the table of contents. If you need to move the table of contents, select it as you would select text and either move it with your cursor or cut it and paste it.
  3. You can continue to add headings to your document or change current headings. However, if you'd like a change to become part of the table of contents, you need to click first the table and then the Update now button.
  4. Each item in your table of contents links to the titled sections of your document that use the heading styles (that you added in step 1 above).

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.

share|improve this answer
    
a ha! many thanks good sir –  sys13 Aug 13 '11 at 19:56

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 #heading=h.abc32def4 -- this should correspond to the link created in the Table of Contents. Copy that entire url and use as suggested by the accepted answer.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.