View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
TK TK is offline
external usenet poster
 
Posts: 177
Default How do I remove numerous Hyperlinks all at once within a worksheet

Hi,

select any other cell(non-hyperlink), click Format Painter on Home -
Clipboard and select all the hyperlink cells.

Check the excel sheet.

-TK

"Cheryl J" wrote:

I have a worksheet that has numerous hyperlinks attached to many of the
cells. I would like to remove all Hyperlinks associated with this worksheet.
Is there a way to do this without doing one cell at a time? I have many
hundreds.