Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Hyperlink to cell in another Workbook saved in Doc Manageme DeniseS Excel Discussion (Misc queries) 0 January 3rd 07 04:33 PM
How do I create a hyperlink to a cell with the hyperlink function S. Bevins Excel Worksheet Functions 2 July 20th 06 08:06 PM
How do I create a formula where a cell is automatically shaded ? Rafi2288 Excel Worksheet Functions 1 April 21st 06 03:14 AM
Convert Hyperlink to cell value automatically Convert Hyperlinks Excel Worksheet Functions 0 January 25th 06 09:53 PM
How to create a hyperlink in excel, using the text in a cell. Leo Excel Worksheet Functions 1 January 29th 05 04:32 AM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"