Benches Uncategorized

4

How to remove hyperlinks in Numbers Versi…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Hi,

I would like to remove all existing email and URL hyperlinks from my spreadsheet.

I can't find anywhere to do this.

Thanks,

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  2. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  3. 0

    vxiansheng

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  4. 0

    vxiansheng

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

    ;-)