Hyperlink a formula
I have a formula in a cell which is the result from another sheet. Is there an easy way of inserting a hyperlink to this sheet. I can't select the numbers in the cell as all I get is the formula pop up.
MacBook Air, macOS 14.3
I have a formula in a cell which is the result from another sheet. Is there an easy way of inserting a hyperlink to this sheet. I can't select the numbers in the cell as all I get is the formula pop up.
MacBook Air, macOS 14.3
Could you clarify what you are asking? A formula is a formula. It can't be a "result from another sheet."
You can add a link by going to Format > Add Link ...
In a formula you can refer to a cell in another table (on the same or another sheet) by simply clicking the target cell while you are in the formula editor.
SG
Hyperlink a formula