Excel hyperlinks can be attached to a range of cells -- what is the use case for this?
- by John Machin
In Excel 2003 and 2007 (and presumably 2010), it is possible to attach a hyperlink to a single cell; this is well known.
Excel also allows you select a range for insertion. In that case, clicking on any cell in the range will jump to the target of the hyperlink. I can't find any web reference to this possibility.
My question is: What is the use…