【Excel】With automatic hyperlink Say No

Do you all encounter such a problem?

Whenever Excel detects that your cell contains a URL or email format, it automatically converts it to hyperlink form. However, in most cases we do not need a hyperlink form.

So how do we avoid Excel turning such cells into hyperlinks?

Example:

Solution:

1. Ctrl + Z to cancel the hyperlink

2. Disable automatic hyperlinks

Excel Options—Proofing—AutoCorrect Options—AutoFormat as you type—Internet and network paths with hyperlinks (Cancel)