How to remove Hyperlink without changing cell format?

J

JAB

I have created a spreadsheet to use as a Master Form and many of the calls
are use as title boxes. Some of them will include Hyperlinks. At times I will
change or remove a Hyperlink, but when I do, that cells format changes. So,
my question is how do I prevent this from happening?
 
A

Anne Troy

You may want to consider creating a new style (create a cell formatted to
look just like your hyperlinks, then hit Format-->Style and choose Add, give
it a name) that looks the same as a cell with a hyperlink (which is an
automatic or predefined style) and apply it to the cell after you remove a
hyperlink.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 
Top