Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove hyperlink from all entries in the column
Message
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01006225
Message ID:
01006329
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform