Here is a handy trick with spreadsheets. First off, you should get
Open Office if you don't yet have it. It's free and comes in so many languages! Anything you make in Open Office can be saved in Microsoft format, for use by your inadequate friends who insist on using the self-centered MS Office (meaning that it does not care about other formats except archaic ones).
Next,
imagine you have a cell that you want to hyperlink to a location in a document. You could put some text in the cell, highlight the text and insert hyperlink. However, that would require the user to click on the words themselves. You want the user to be able to click anywhere within the cell itself to jump to the link in the document. You should set up two things for this to work: a bookmark in your document and a rectangle drawing overlaying your cell.
To make a
bookmark in your document, place your cursor where you would like the bookmark. Then choose Insert-->Bookmark. In the dialog box type in what you would like to name your bookmark and click Ok.
Back in your spreadsheet you may have to make the Drawing toolbar visible. Go to View-->Toolbars-->Drawing. A toolbar should appear at the bottom of the program. Click on the
rectangle and draw a rectangle from one corner to the opposite of your cell. It will likely be filled with a color. That's alright, since we'll just make it transparent anyway.
Now you need to make the rectangle almost completely
transparent. Right-click the rectangle and choose Area. Then click on the Transparency tab. 95% should be perfect, since it will allow you to still see that the cell is different from the rest.
Lastly, you must make the
hyperlink. In your spreadsheet program you must have the rectangle selected (you'll see about 8 tiny green squares around it). If it is not selected then right-click on it, ignoring the menu that pops up. Next, choose Insert-->Hyperlink. In the dialog box choose Document (on the left), set the Path to the document, click on the Target icon (looks like a target for darts) and select from the Bookmarks section your bookmark and click Apply and Close.
That's it! Now test it.