In any Google Sheet, select a cell containing a formula, for example, =SUM(1,1). You'll see that both the Insert->Link menu

and the toolbar button for Insert Link (Ctrl K) are disabled.

Why is that?

PS:

1. I've spent considerable time on Google, but I haven't found this issue mentioned anywhere.
2. This problem occurs irrespective of whether the formula has been manually typed in the cell or been populated through Apps Script.

CodePudding user response：

This is intended behaviour

If you press Ctrl K when a cell with a formula is highlighted you get the following message: