Remove autoformatting (e-mail addresses)

[Guest]

Hi

I work as a teacher and use Excel for storing information about students. I also type in students' e-mail addresses but unfortunately Excel automatically makes an e-mail hyperlink. I'm not at all interested in having hyperlinks in my document so I manually remove them (undo after I've filled in one). This would all be fine but when I have a lot of students this extra procedure generates a lot of extra work.

The reason why I don't want extra hyperlinks is that when I accidentally activate one (press one), Excel opens a mailprogram and I'm not interested in sending individual mails to my students. It makes life difficult - I have to be careful with the links and it is more troublesome to edit the e-mail addresses

I tried to remove all autoformatting features but it didn't help. I tried to define the e-mail column as text and that didn't help either... Anyone have a tip
-Frasse

 

[Roger Govier]

Hi

One way would be to highlight a cell in the column where you have the
hyperlink removed, press the cion for the Format painter then click on the
column letter for that column.

All values entered would then have the hyperlink removed.

--
Regards
Roger Govier

Hi!

I work as a teacher and use Excel for storing information about students.

I also type in students' e-mail addresses but unfortunately Excel
automatically makes an e-mail hyperlink. I'm not at all interested in having
hyperlinks in my document so I manually remove them (undo after I've filled
in one). This would all be fine but when I have a lot of students this extra
procedure generates a lot of extra work.

The reason why I don't want extra hyperlinks is that when I accidentally

activate one (press one), Excel opens a mailprogram and I'm not interested
in sending individual mails to my students. It makes life difficult - I have
to be careful with the links and it is more troublesome to edit the e-mail
addresses.

I tried to remove all autoformatting features but it didn't help. I tried

to define the e-mail column as text and that didn't help either... Anyone
have a tip?

 

[Norman Harker]

Hi Frasse!

You can use Ctrl+Z to remove a hyperlink you typed as long as you do
it immediately after you bang the Enter key.

But in Excel 2002 and 2003 you can turn off automatic hyperlinking:

Tools > AutoCorrect Options
"AutoFormat as you type" Tab
Remove check from "Internet and Network paths with hyperlinks"
OK

For earlier versions see various options at:

Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperLinks


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.