View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Maui Dave[_2_] Maui Dave[_2_] is offline
external usenet poster
 
Posts: 4
Default Link To Cell In Same Spreadsheet

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" wrote:

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)


"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