When I enter a string of text that contains the @ symbol, Excel automatically turns it into a hyperlink to my email program. Is there a way to disable this?
depends on your Excel version:
Excel 2003: Goto 'Tools - Autocorrect - Auto format as you type' and
disable this option
Before that (though as I don't use Excel 2002 maybe the tip for Excel
2003 will work):
a) Use the following macro to remove hyperlinks of a chosen selection
(after your data entry)
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub
b) Without macro:
- Type the number 1 in a blank cell and copy this cell
- Select all your cells with hyperlinks
- goto 'Edit - Paste Special'
- choose multiply
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
