Forum Discussion
connecting sheets
how to use Hyperlink to jump to sheets in the same workbook
=HYPERLINK( "#Sheet2!A1", "Link Text to Display")
The # and " " are critical
Also, safest approach is to name the cell you want to link to e.g. hypSht2
Then your formula is =HYPERLINK( "#hypSht2", "Link Text to Display")
The # and " " are critical
Also, safest approach is to name the cell you want to link to e.g. hypSht2
Then your formula is =HYPERLINK( "#hypSht2", "Link Text to Display")
- thank you very much for your quick response
