How to remove hyperlinks in Numbers Version 5.3 (Mojave)
Hi,
I would like to remove all existing email and URL hyperlinks from my spreadsheet.
I can't find anywhere to do this.
Thanks,
iMac Pro
Hi,
I would like to remove all existing email and URL hyperlinks from my spreadsheet.
I can't find anywhere to do this.
Thanks,
iMac Pro
Hi vxiansheng,
In Numbers 5.3, there is no way to remove all hyperlinks with a single command. However, you can select (say) a column or row of hyperlinks, Copy, then Menu > Edit > Paste and Match Style. That will remove those links and replace them with text.
Regards,
Ian.
Hi vxiansheng,
In Numbers 5.3, there is no way to remove all hyperlinks with a single command. However, you can select (say) a column or row of hyperlinks, Copy, then Menu > Edit > Paste and Match Style. That will remove those links and replace them with text.
Regards,
Ian.
Thanks, Yellowbox. That worked....
Would you mind enlightening me on what is really the meaning or rationale behind "Paste and Match Style"? What style is being matched? It's very nebulous, ambiguous and confusing to me.
Hi vxiansheng,
Glad it worked and thanks for the green tick!
"Paste and Match Style" matches the style of the destination cell.
The original cell B2 is bold. Copy and Paste to B3 and it pastes the style of the original.
Paste and Match Style to B4 and it matches the non-bold style of B4.
With Hyperlinks, I assume it matches the "non-Hyperlink" style, whatever that is!
Regards,
Ian.
Ah, thank you, Ian.
Perhaps I'm overly rigid, but I would like to see the function named "Paste and Match Destination Style" or something like that.
;-)
How to remove hyperlinks in Numbers Version 5.3 (Mojave)