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.