Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove hyperlink from all entries in the column
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01006225
Message ID:
01006329
Vues:
21
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>Do you know how can I remove hyperlink from all entries in the column? I found a way to do it per each cell, but I need to do it for the whole column.
>
>Thanks a lot in advance.

First turn off the auto correct feature that creates the hyperlinks.
Tools Menu, Options, Spelling Tab, Auto Correct Options button,
AutoFormat as you type tab, uncheck Internet and network path with hyperlinks.

Close the spreadsheet and reopen it so the change is in effect.

Copy the cells, then paste special, select values. That should do it.
___________________________
Kenneth Wonderley
http://www.wonderley.com


...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform