| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the @ symbol in a cell
I have a friend at work who was using Excel (2003) and was typing using the @
character for something totally unrelated to an email hyperlink and Excel turned all of the cells in her spreadsheet using the @ symbol into hyperlinks. I used replace to get rid of the "@" and turn it into "at", but it remained a hyperlink. I got rid of the hyperlink by right clicking each cell and deleting it. Is there someway to get Excel to automatically not assume you are typing in a hyperlink? Also, I couldn't find a way to choose all the cells and have the same option of clearing the hyperlink? Any easy way to do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the @ symbol in a cell
Tools/ AutoCorrect Options/ AutoFormat as you Type: uncheck the one about
hyperlinks for internet and network paths. -- David Biddulph "jknapp1005" wrote in message ... I have a friend at work who was using Excel (2003) and was typing using the @ character for something totally unrelated to an email hyperlink and Excel turned all of the cells in her spreadsheet using the @ symbol into hyperlinks. I used replace to get rid of the "@" and turn it into "at", but it remained a hyperlink. I got rid of the hyperlink by right clicking each cell and deleting it. Is there someway to get Excel to automatically not assume you are typing in a hyperlink? .... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the @ symbol in a cell
Click TOOLS in the menu and select AUTOCORRECT. In the Autocorrect dialog
box click the AUTOFORMAT AS YOU TYPE tab and remove the check from the INTERNET AND NETWORK PATHS WITH HYPERLINKS check box. Just another attempt to be overly helpful by the application... -- Kevin Backmann "jknapp1005" wrote: I have a friend at work who was using Excel (2003) and was typing using the @ character for something totally unrelated to an email hyperlink and Excel turned all of the cells in her spreadsheet using the @ symbol into hyperlinks. I used replace to get rid of the "@" and turn it into "at", but it remained a hyperlink. I got rid of the hyperlink by right clicking each cell and deleting it. Is there someway to get Excel to automatically not assume you are typing in a hyperlink? Also, I couldn't find a way to choose all the cells and have the same option of clearing the hyperlink? Any easy way to do that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the @ symbol in a cell
go to toolsauto correct optionsautoformat as you type tab and unselect
replace as you type internet and network paths with hyperlink. this will not remove existing hyperlinks and you can still add a hyperlink using cell formatting -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "jknapp1005" wrote: I have a friend at work who was using Excel (2003) and was typing using the @ character for something totally unrelated to an email hyperlink and Excel turned all of the cells in her spreadsheet using the @ symbol into hyperlinks. I used replace to get rid of the "@" and turn it into "at", but it remained a hyperlink. I got rid of the hyperlink by right clicking each cell and deleting it. Is there someway to get Excel to automatically not assume you are typing in a hyperlink? Also, I couldn't find a way to choose all the cells and have the same option of clearing the hyperlink? Any easy way to do that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the @ symbol in a cell
You may find that you generally want the links and that it is easier to
remove the ones you don't want rather than changing your autocorrect options. Three manual methods of deleting the unwanted hyperlinks http://www.mvps.org/dmcritchie/excel...#DelHyperlinks Ctrl+Z to immediate removal of the link, if you catch it in time Ctrl+K to edit the hyperlink and remove copying an empty cell then using Edit, Paste Special, Add on a selection and with using VBA code Use of a macro two such macros and more details on the above at http://www.mvps.org/dmcritchie/excel...#DelHyperlinks or someone even suggested you copy or paste into the intermediate window Selection.Hyperlinks.Delete -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Vista / Excel 20007: http://www.mvps.org/dmcritchie/vista/vista.htm "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Tools/ AutoCorrect Options/ AutoFormat as you Type: uncheck the one about hyperlinks for internet and network paths. -- David Biddulph "jknapp1005" wrote in message ... I have a friend at work who was using Excel (2003) and was typing using the @ character for something totally unrelated to an email hyperlink and Excel turned all of the cells in her spreadsheet using the @ symbol into hyperlinks. I used replace to get rid of the "@" and turn it into "at", but it remained a hyperlink. I got rid of the hyperlink by right clicking each cell and deleting it. Is there someway to get Excel to automatically not assume you are typing in a hyperlink? ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does the ^ symbol mean in an Excel cell? | Excel Discussion (Misc queries) | |||
| How can I remove the % symbol from a cell. Thanks | Excel Discussion (Misc queries) | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Linear Mode
