I don't see "Place In This Document" anywhere in the Insert | Hyperlink dialog.



"Bernard Liengme" wrote:

Move to the cell where the hyperlink is needed
Use Insert | Hyperlink (Or use the hyperlink tool)
In the left-hand side of the Hyperlink dialog, click on "Place in this
Document"
In the second box down "Type the cell reference", enter the cell reference
such as BB2 (please note it is not BB:2 with a colon between column and row)
You can change what is displayed in the linking cell by entering text into
the top box "Text to display", otherwise it will display JUNK!B22 where JUNK
is my file name.
Let's us know if you were successful
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Maui Dave" wrote in message
...
How do I hyperlink to a cell in the same spreadsheet? I know I go to
Insert/Hyperlink, but what's the syntax to go to cell BB:2 ?

Thanks in advance