When referring another cell, how to retain its hyperlink

[ZhangWeiwu]

Suppose Sheet1.A1 is a link, title “Google” with content “http://www.google.com”, and Sheet2 is empty.

Now I set Sheet2.A1 to be ‘=Sheet1.A1’

Its content will be plain text “Google”, without the URL link.

Now, if I wish to make Sheet2.A1 clickable and leads to the URL, is there a way to do so?

I can image:

1. Maybe there is a way to refer to the whole cell Sheet1.A1, with style and link?
2. Maybe there is a way to make Sheet2.A1 a link, that, when clicked, switch to Sheet1, and focus on Sheet1.A1?

Googled for a while with no luck. Thanks.

[karolus]

Ref 2.
change Formula in Sheet2.A1 to =HYPERLINK("#Sheet1.A1")