| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Hyperlinks
How do I stop an email address in a cell appearing as a hyperlink?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
put a leading apostrophe in front of it.
"oceanmist" wrote in message ... How do I stop an email address in a cell appearing as a hyperlink? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
Hi oceanmist. You could also go to Tools-Auto Correct Options, select the
Autoformat as you type tab and uncheck Internet & network paths with hyperlinks. HTH -- Sincerely, Michael Colvin "oceanmist" wrote: How do I stop an email address in a cell appearing as a hyperlink? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
Hi there Michael,
What if the text is already in the cell - and you want to activate it? Without right clicking on each cell individually? Thanks! WHyvon "Michael" wrote: Hi oceanmist. You could also go to Tools-Auto Correct Options, select the Autoformat as you type tab and uncheck Internet & network paths with hyperlinks. HTH -- Sincerely, Michael Colvin "oceanmist" wrote: How do I stop an email address in a cell appearing as a hyperlink? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
Hi Why Von. If you select the cell where you want the hyperlink, you can
then press f2 and then press enter and it will create the hyperlink. This only works one cell at a time, but it goes pretty fast. HTH -- Sincerely, Michael Colvin "Why Von" wrote: Hi there Michael, What if the text is already in the cell - and you want to activate it? Without right clicking on each cell individually? Thanks! WHyvon "Michael" wrote: Hi oceanmist. You could also go to Tools-Auto Correct Options, select the Autoformat as you type tab and uncheck Internet & network paths with hyperlinks. HTH -- Sincerely, Michael Colvin "oceanmist" wrote: How do I stop an email address in a cell appearing as a hyperlink? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
THANK YOU Michael!
I since found another similar option - just double click each cell. Tedious but does the trick. There was a response on the forum for a macros - but I'm not that advanced of a user. Whyvon "Michael" wrote: Hi Why Von. If you select the cell where you want the hyperlink, you can then press f2 and then press enter and it will create the hyperlink. This only works one cell at a time, but it goes pretty fast. HTH -- Sincerely, Michael Colvin "Why Von" wrote: Hi there Michael, What if the text is already in the cell - and you want to activate it? Without right clicking on each cell individually? Thanks! WHyvon "Michael" wrote: Hi oceanmist. You could also go to Tools-Auto Correct Options, select the Autoformat as you type tab and uncheck Internet & network paths with hyperlinks. HTH -- Sincerely, Michael Colvin "oceanmist" wrote: How do I stop an email address in a cell appearing as a hyperlink? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Hyperlinks
Thanks for the tip Why Von. I'll add it to my list.
-- Sincerely, Michael Colvin "Why Von" wrote: THANK YOU Michael! I since found another similar option - just double click each cell. Tedious but does the trick. There was a response on the forum for a macros - but I'm not that advanced of a user. Whyvon "Michael" wrote: Hi Why Von. If you select the cell where you want the hyperlink, you can then press f2 and then press enter and it will create the hyperlink. This only works one cell at a time, but it goes pretty fast. HTH -- Sincerely, Michael Colvin "Why Von" wrote: Hi there Michael, What if the text is already in the cell - and you want to activate it? Without right clicking on each cell individually? Thanks! WHyvon "Michael" wrote: Hi oceanmist. You could also go to Tools-Auto Correct Options, select the Autoformat as you type tab and uncheck Internet & network paths with hyperlinks. HTH -- Sincerely, Michael Colvin "oceanmist" wrote: How do I stop an email address in a cell appearing as a hyperlink? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
| Why no XML in Excel 2003 with Office Standard? | Excel Discussion (Misc queries) | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
