ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I stop excel from automatically making hyperlinks (https://www.excelbanter.com/excel-discussion-misc-queries/89781-how-can-i-stop-excel-automatically-making-hyperlinks.html)

MAB5025

How can I stop excel from automatically making hyperlinks
 
I am using Excel 2003. Whenever I enter an email address in a cell, it turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty

Dave Peterson

How can I stop excel from automatically making hyperlinks
 
You can turn off this autocorrection featu

Tools|autocorrect options|autoformat as you type tab|uncheck that top option.

MAB5025 wrote:

I am using Excel 2003. Whenever I enter an email address in a cell, it turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty


--

Dave Peterson

Biff

How can I stop excel from automatically making hyperlinks
 
Hi!

In Excel 2002:

Goto ToolsAutoCorrect optionsAuto format as you type tab

Uncheck Internet and network paths with hyperlinks

Ok out

Biff

"MAB5025" wrote in message
...
I am using Excel 2003. Whenever I enter an email address in a cell, it
turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty




MAB5025

How can I stop excel from automatically making hyperlinks
 
Hello Dave Peterson,
Thank you very much for your help in solving my problem with excel. Your
solution was so easy to do, I'm sorry I didn't know about it. From now on I
will, thanks to you. Marty

"Dave Peterson" wrote:

You can turn off this autocorrection featu

Tools|autocorrect options|autoformat as you type tab|uncheck that top option.

MAB5025 wrote:

I am using Excel 2003. Whenever I enter an email address in a cell, it turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty


--

Dave Peterson


MAB5025

How can I stop excel from automatically making hyperlinks
 
Hello Biff,
Thank you very much for your help in solving my problem with excel. I
appreciate your speedy response, since I had trouble moving forward with my
work.
Marty

"Biff" wrote:

Hi!

In Excel 2002:

Goto ToolsAutoCorrect optionsAuto format as you type tab

Uncheck Internet and network paths with hyperlinks

Ok out

Biff

"MAB5025" wrote in message
...
I am using Excel 2003. Whenever I enter an email address in a cell, it
turnes
into a hyperlink as soon as I click enter. How can I stop excel from doing
that. It is making it very difficult to work with excel. It started to do
this even though I have been using excel for years.
Thank you for you help.
Marty





Biff

How can I stop excel from automatically making hyperlinks
 
You're welcome. Thanks for the feedback!

Biff

"MAB5025" wrote in message
...
Hello Biff,
Thank you very much for your help in solving my problem with excel. I
appreciate your speedy response, since I had trouble moving forward with
my
work.
Marty

"Biff" wrote:

Hi!

In Excel 2002:

Goto ToolsAutoCorrect optionsAuto format as you type tab

Uncheck Internet and network paths with hyperlinks

Ok out

Biff

"MAB5025" wrote in message
...
I am using Excel 2003. Whenever I enter an email address in a cell, it
turnes
into a hyperlink as soon as I click enter. How can I stop excel from
doing
that. It is making it very difficult to work with excel. It started to
do
this even though I have been using excel for years.
Thank you for you help.
Marty








All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com