I'm not sure you can get there directly through keyboard commands, but this
code will do it:
Sub RemoveManyHyperlinks()
'select the column or row or group of cells
'that you want to remove hyperlinks from
'and then, with them selected, use
'Tools | Macro | Macros
'to select this macro and click the
'[Run] button to kiss them bye-bye
Selection.Hyperlinks.Delete
End Sub
To put the code into the workbook, open the workbook, press [Alt]+[F11] to
open the
VB Editor. Use Insert | Module to open a new code module, then copy
and paste the code above into the module. Close the
VB Editor and then
follow the instructions in the code.
HTH
"childofthe1980s" wrote:
Hello:
Do you know how to eliminate hyperlinks, for all cells from within a column
in Excel? I know how to do it by cell but not by column.
childofthe1980s