How do I remove all e-mail hyperlinks from excel spreadsheet
For a one-time solution, try this:
Copy a blank cell
Select the cells to be impacted.
From the Excel main menu:
<edit<paste special
Check: Add....then click [OK]
If you want to prevent email links from being created in the future.
From the Excel main menu:
<tools<options<spelling tab
Click the [autocorrect options] button
Select the "Autoformat as you type" tab
UNcheck: Internet and network paths with hyperlinks
Click the [OK] buttons to commit the settings
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Melanie" wrote:
I have tried everything in Help and the one option that i think may work
under Edit, Links. Has "links" greyed out!
Help
|