Enable copying a cell and inserting it as a hyperlink in same or different worksheet through a right click or paste Special option
In Excel for Mac 14.6.0 - I can't seem to be able to just copy a cell and paste it as a hyperlink whilst maintaining the original cell address & description. Current process is complicated and not working correctly as described in Help; when using INSERT> HYPERLINK, you have to paste cell description, then LOCATE where you can only specify another worksheet and then manually complete the location with the cell reference! I'm sure you could just paste the whole cell address before. Also, you cannot just enter/paste the 'defined name' as described in Help.