I've just started using excel to organize my music library. In one of the columns I have a list of hyperlinks each leading to a different cell in another worksheet. However, while it works just fine with the Cmd + K (I'm on Mac) keyboard shortcut, it simply doesn't work when I use this formula:
=HYPERLINK('Commenti e link relativi'!B2; "1")
("'Commenti e link relativi'" is the name of a worksheet)
Anyway, when I run the formula, it will arbitrarily edit the formatting of the cell to look like a hyperlink, but will remain completely inert when clicked on.
I have to make several hundreds hyperlinks, so using Cmd + K for each one of them is not really an aoption.
=HYPERLINK('Commenti e link relativi'!B2; "1")
("'Commenti e link relativi'" is the name of a worksheet)
Anyway, when I run the formula, it will arbitrarily edit the formatting of the cell to look like a hyperlink, but will remain completely inert when clicked on.
I have to make several hundreds hyperlinks, so using Cmd + K for each one of them is not really an aoption.