| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing hyperlinks for all text in a colum shortkey
Is there a shortcut to removing the hyperlinks in a column so that there is
only text? -- --coastal |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing hyperlinks for all text in a colum shortkey
Select the column.
Alt-F11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete coastal wrote: Is there a shortcut to removing the hyperlinks in a column so that there is only text? -- --coastal -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing hyperlinks for all text in a colum shortkey
Copy an empty cell.
Select the column of hyperlink cells and Paste SpecialAddOKEsc David McRitchie has code and more suggestion for dealing with hyperlinks. http://www.mvps.org/dmcritchie/excel...#DelHyperlinks Gord Dibben MS Excel MVP On Mon, 25 Jun 2007 13:27:00 -0700, coastal wrote: Is there a shortcut to removing the hyperlinks in a column so that there is only text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Hyperlinks | Excel Discussion (Misc queries) | |||
| removing hyperlinks | Excel Discussion (Misc queries) | |||
| removing hyperlinks | Excel Discussion (Misc queries) | |||
| Hyperlinks - Turning off (Removing) | Setting up and Configuration of Excel | |||
| Removing Multiple Hyperlinks | New Users to Excel | |||
Hybrid Mode
