I would like to use the hyperlink formula to link to a range of cells in the same sheet.
This should be simple and works when I press ctrl+K and enter A1:A2 for the cell reference; but not with the formula.
=hyperlink(A1:A2,"Link to A1:A2")
ALSO, if there's a way to hyperlink from one cell to multiple non-contiguous ranges that would be amazing!!! Something like pressing a hyperlinked cell A1 and selecting C1:C3 and E1:E3.
Any help is much appreciated...
Thanks,
Dan
Bookmarks