View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default eliminating hyperlinks from a complete column in Excel

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