Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I stop EXEL 2000 from making an e-mail entry active

Status
Not open for further replies.

Ersbygubben

Programmer
May 8, 2001
20
0
0
FI
Can anyone tell me how to turn off this automatic formatting from a column or even a cell. I am compiling a memberlist with addresses, telephonenumbers etc. and e-mail addresses in Exel 2000 and as soon as I write the e-mailaddress, exel puts a line under (makes it into a link) which emediately is active. If I try to rewrite the cell, my e-mailprogram jumps in and I have to kill it before I can do anything further. There must be some way to turn this automation off, but I have not found it.
 
When you have the cell(s) selected: Edit/Undo Hyperlink Matt
 
Thanks. But I didn't find the Undo Hyperlink there. But I found another way, although slower; make an enpty cell contain number 1, rightclick it and choose COPY. Then highlight the cell (or cells by keeping contrl down) then Click Edit/Paste Special and under Operation click Multiple and then OK and loo and behold, the hyperlinks are deaktivated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top