Create one hyperlink for an entire row of data in Calc

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?

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.