Thread: Hyperlink formula for multiple cells and/or ranges

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

Welcome to the forum, danj.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.