Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Jan 1, 2019 6:22 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 1, 2019 10:41 PM

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.

Similar questions

4 replies
Sort By: 
Question marked as Top-ranking reply

Jan 1, 2019 10:41 PM in response to Community User

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.

Reply

Jan 2, 2019 10:16 PM in response to Yellowbox

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.





Reply

Jan 2, 2019 10:26 PM in response to Community User

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.

Reply

Jan 2, 2019 10:51 PM in response to Yellowbox

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.

;-)



Reply

How to remove hyperlinks in Numbers Version 5.3 (Mojave)

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.