Ask Your Question

Create one hyperlink for an entire row of data in Calc

asked 2016-04-19 17:02:22 +0200

Penname gravatar image

How can I select an entire row of cells (or perhaps multiple cells) and add a hyperlink to the data (without disturbing the data display, but making an active link?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-20 14:43:44 +0200

JohnSUN gravatar image

Try function HYPERLINK()

For example you can write something as

=HYPERLINK("#<sheetname>.<celladdress1>:<celladdress2>";"jump to range") or

=HYPERLINK("#<sheetname>.$<rownumber>:$<rownumber>";"jump to row").

For me formula

=HYPERLINK("#$'Sheet 2'.$10:$10";"jump to row 10")

work fine.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-19 17:02:22 +0200

Seen: 38 times

Last updated: Apr 20 '16