Link To Cell In Same Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
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?
 
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)
 
Back
Top