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 Best 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

Jan 2, 2019 10:26 PM in response to vxiansheng

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.

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 ID.