ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create an hyperlink automatically in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/238661-create-hyperlink-automatically-cell.html)

João Carlos

Create an hyperlink automatically in a cell
 
Hello!
Up until recently an hyperlink would automatically be created when I entered
a www or e-mail address in a cell. It no longer does it!
I must have action-ed the change by mistake (clicking / pressing a key or
using the Ctrl / Alt incorrectly) or a gremlin has crept in!
Your help in re-establishing this feature in a worksheet would much
appreciated
--
Thank you.

Mike H

Create an hyperlink automatically in a cell
 
Hi,

Try:-

Tools|Autocorrect options - Autoformat as you type tab
Ensure 'Internet and network paths with hyperlinks' is checked.

Mike

"João Carlos" wrote:

Hello!
Up until recently an hyperlink would automatically be created when I entered
a www or e-mail address in a cell. It no longer does it!
I must have action-ed the change by mistake (clicking / pressing a key or
using the Ctrl / Alt incorrectly) or a gremlin has crept in!
Your help in re-establishing this feature in a worksheet would much
appreciated
--
Thank you.


João Carlos

Create an hyperlink automatically in a cell
 
Hello Mike H,

You did it! I owe you one, whenever I meet up with you in my travels, unless
you live in South Africa!
--
Thank you.


"Mike H" wrote:

Hi,

Try:-

Tools|Autocorrect options - Autoformat as you type tab
Ensure 'Internet and network paths with hyperlinks' is checked.

Mike

"João Carlos" wrote:

Hello!
Up until recently an hyperlink would automatically be created when I entered
a www or e-mail address in a cell. It no longer does it!
I must have action-ed the change by mistake (clicking / pressing a key or
using the Ctrl / Alt incorrectly) or a gremlin has crept in!
Your help in re-establishing this feature in a worksheet would much
appreciated
--
Thank you.



All times are GMT +1. The time now is 06:56 PM.

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