Removing hyperlinks while still retaining formatting (fill colors, bold, etc.)

[harrisondebord]

Is there a way to remove all hyperlinks from an excel sheet without removing formatting such as fill colors, boldness, italics, etc?

Thank you in advance!
Harrison

 

[harrisondebord]

I could really use some help with this one.
Thanks,
Harrison

 

[edokhotnik]

Deleted. Response in error

 

[harrisondebord]

Thanks for trying anyway.

Harrison

 

[edokhotnik]

Give this a try.

Select/Highlight the cells you need.
On the Home tab of the ribbon, select "Format Cells"
Select the Font tab.
Under "Underline" select from the dropdown list "None"
On the "Color" dropdown list select the font color you want.


HTH