Link To Cell In Same Spreadsheet

[Guest]

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

 

[Chip Pearson]

Try

=HYPERLINK("#K20","Click Me")

to go to cell K20 on the same sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Bernard Liengme]

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

 

[Guest]

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

 

[Guest]

Chip, I copied and pasted what you put below, but I get an error message (I
did put the appropriate cell number in there). Does the =HYPERLINK need to
be in there?

 

[Chip Pearson]

What I posted was the hyperlink FUNCTION, not the hyperlink OBJECT. The two
are different (coming in to being in different version of Excel). You need
the entire formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)